Use Sharepoint to exctract email addresses

Help Studio
1

Hello!

I am new to this, so I understand if you find this a bad question. Is it however possible to use Sharepoint to individually extract email addresses from the group membership, using UI elements to which I want to send email every week to every member individually?

The purpose is that an unattended robot sends out standard mail every week to all group members. Is it possible to send one email to everybody at one time?

Thanks in advance!

2

@Ronaldo_Romi

Welcome to the community

You can achieve this using thw office365 activities…you have to send the group id and it would give the members of the group.

https://docs.uipath.com/activities/docs/about-the-microsoft-office-365-activities-pack

Cheers

3

Hi @Ronaldo_Romi
You need to install the office365 activities package in UiPath. After that follow the below steps.

Steps:

  1. Use the Get Groups activity to retrieve a list of groups from SharePoint.
  2. Use a For Each loop to iterate over the list of groups.
  3. Inside the loop, use the Get Users in Group activity to retrieve a list of users in the current group.
  4. Get the mail ID’s and store into variable
  5. Use the Send Outlook Mail Message or SMTP mail activity to send an email

For more reference : Refer the UiPath docs portal
Thanks!!!

4

I really appreciate your response. Thank you @Anil_G and @Kaviyarasu_N .

Is there a way to to the same process as a REF instead of a regular process?

5

@Ronaldo_Romi

You can use these activities in Ref as well…That is up to you where you configure it

Instead of for each change the transationItem variable type to required string type and then pass it and do the get in Process xaml

cheers

6

Just a question. Is there a way around to get groups from SharePoint without installing the office365 package into UiPath?

7

By using O365 api is another options

Regards
Kaviyarasu N

8

The problem is that I don’t have permission to add the Office365 to UiPath from Microsoft Azure.