Using a find and replace to populate list of email addresses

(0) Share

Report

Posted on by nbarta

I have an automation I'm building to send out Calendar Event Invitations (Outlook) when a particular column in a Sharepoint List is triggered. Steps I'm trying to create:

1. End User changes column from "No" to "Yes" - this initiates the flow

2. Flow grabs contents of the lists, populates an Outlook Calendar Event to send out

3. Addresses of the people who need to receive the email depend on what Group they are in. The Sharepoint List contains only the Group. There is a separate Excel file that will have the list of email addresses per group in a Table.

How can I use Power Automate to grab the name of the group from Sharepoint, cross reference with the Table in Excel, and then populate the list of email addresses into that Calendar Invite? This is the last step that I am stuck on.

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-yujincui-msft on at

Like (0)

Report
Re: Using a find and replace to populate list of email addresses

Hi @nbarta ,

Do you want to send Calendar Event Invitations based on group name when item in SharePoint List is modified?
Could you please tell me what is the data type of the column used to store the Group name? “Person or Group” or “Text”?

I have made a test for your reference.

1.Here is my SharePoint List.
2.Here is my excel table.
3.Create a flow.
4.Here are some expressions for your reference.
concat(item()?['GroupName'], ' Members') item()?[‘MemberAddress’] formatDateTime(addHours(triggerOutputs()?['body/starttime'],8),'yyyy-MM-dd HH:mm:ss') formatDateTime(addHours(triggerOutputs()?['body/endtime'],8),'yyyy-MM-dd HH:mm:ss')
Result Screenshot:

Best Regards,
Charlie Choi

Was this reply helpful? Yes No