cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

SharePoint List parsed to email adress

Hello,

 

I am trying to create a Flow which would work the following way: 

 

1) Run Flow every 6 months 

 

2) I have a sharepoint list containing a column called 'Name', containing names. From that column i would like to extract all the UNIQUE data (the column contains multiple entries with the same name and i do not wish to send duplicates of the same mail).

 

3) Edit the names to format: 'firstname.lastname@suffix.com'.

 

4)Send an email to all the unique recipients

 

5) With an IF-statement control if the email was recieved.

5.1) If True (recieved); continue sending emails.

5.2) If false (Email adress is obsolete and could not be recieved); write the adress to an excel or text file which i can use to delete the obsolete names. Continue sending emails.

 

6) After every email has been written to this file it should be sent to myself so i can remove the obsolete emails.

 

Sorry for my English, it is not my primary language.

 

EDIT: Formatting and grammar fixes.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: SharePoint List parsed to email adress

Hi @RawrCheeze,

 

Could you please share a bit more about your SharePoint list?

Do you want to add a Condition to check if the email is received by the recipients within your flow?

 

If you want to add a Condition to check if the email is received by the recipients within your flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently. If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

I have created a SharePoint list on my side and the data structure of it as below:13.JPG

 

 

I suppose that you want to extract unique data (e.g. Kris Dai) from Names (Name) column and then format the data into the following format:

Kris.Dai@suffix.com

Is it true?

 

As an alternative solution, please take a try with the following workaround:14.JPG

 

15.JPG

 

16.JPG

 

Within "Compose" action, Inputs field set to following formula:

union(body('Select'),body('Select'))

Within "Compose 2" action, Inputs field set to following formula:

concat(split(item()?['Name'],' ')[0],'.',split(item()?['Name'],' ')[1],'@suffix.com')

Under "Send an email" action, configure a run after action ("Insert row" action) for it. I add a "Insert row" action under the "Send an email" action as a configure run after action. Then click "Menu" button-> "Configure run after":17.JPG

Then within the "Insert row" configure run after panel, select has failed option, then click "Done":18.JPG

 

 

Note: The Excel file (whose data has been formatted as an table) is stored in my OneDrive folder. On your side, you could consider take a try to store your Excel file within your OneDrive folder and create a connection to your OneDrive service through the Excel connector, then use the "Insert row" action to insert the obsolete emails into it.

 

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: SharePoint List parsed to email adress

Hi @RawrCheeze,

 

Could you please share a bit more about your SharePoint list?

Do you want to add a Condition to check if the email is received by the recipients within your flow?

 

If you want to add a Condition to check if the email is received by the recipients within your flow, I afraid that there is no way to achieve your needs in Microsoft Flow currently. If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

I have created a SharePoint list on my side and the data structure of it as below:13.JPG

 

 

I suppose that you want to extract unique data (e.g. Kris Dai) from Names (Name) column and then format the data into the following format:

Kris.Dai@suffix.com

Is it true?

 

As an alternative solution, please take a try with the following workaround:14.JPG

 

15.JPG

 

16.JPG

 

Within "Compose" action, Inputs field set to following formula:

union(body('Select'),body('Select'))

Within "Compose 2" action, Inputs field set to following formula:

concat(split(item()?['Name'],' ')[0],'.',split(item()?['Name'],' ')[1],'@suffix.com')

Under "Send an email" action, configure a run after action ("Insert row" action) for it. I add a "Insert row" action under the "Send an email" action as a configure run after action. Then click "Menu" button-> "Configure run after":17.JPG

Then within the "Insert row" configure run after panel, select has failed option, then click "Done":18.JPG

 

 

Note: The Excel file (whose data has been formatted as an table) is stored in my OneDrive folder. On your side, you could consider take a try to store your Excel file within your OneDrive folder and create a connection to your OneDrive service through the Excel connector, then use the "Insert row" action to insert the obsolete emails into it.

 

More details about using expression in flow actions, please check the following article:

Use expression in flow actions

 

 

Best regards,

Kris

 

 

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
FirstImage

Microsoft Ignite 2020

Check out the announcement of Power Platform content at Microsoft Ignite!

thirdImage

Experience what's new for Power Automate

Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (8,564)