I have a flow that has a Recurrence trigger. I am trying to create a flow that can extract a unique value (email address) from an excel spreadsheet and send one email instead of multiple emails. My spreadsheet is linked to our Sharepoint site. The spreadsheet sheet has over 400 rows of data that needs to be parsed out by which Rep owns which account, which could be multiple. Please help.
my flow is below:
Recurrence
List rows in present table
create an html table
apply to each and inside that loop send email
Solved! Go to Solution.
Hi @Olijk
I made a video based on this. Please have a look.
Power Automate - How to Filter Excel Unique Email Address Column Values & Send Email - YouTube
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Olijk
Please have a look at my tutorial video
Power Automate - How To Get Distinct Values From An Array - YouTube
Once you extracted the distinct values (email address) use the select filter action step to filter the values
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello,
Thank you for the reply. I actually watched that video as well. It didn’t work for me, but will try again. Also, I saw you used the Get Items in the video and I used List Rows from present table. Do I need to adjust my spreadsheet for it to work?
Also, I saw in your video, a Sharepoint list. My info is from and excel file
I received this message
I tried again and am still getting duplicate emails
Hi @Olijk
Could you post a sample 5 rows of data?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogYes in your case you need the Excel connector.
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogThis is just a snippet, but it’s usually 60 unique sales rep email values
Thank you!
Also, forgot to mention that this data will change weekly. I would upload files to Sharepoint weekly
Hi @Olijk
Thanks for your reply. I will update something soon.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHi @Olijk
Thanks for your reply. I will update something soon.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogAlso, when changing the spreadsheet out from Sharepoint it broke my flow… I added more actions… this was the error message
Hi @Olijk
I made a video based on this. Please have a look.
Power Automate - How to Filter Excel Unique Email Address Column Values & Send Email - YouTube
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello,
Thank you so much! This was super helpful! I am super glad this community was created. I have one more question,
when changing the spreadsheet out from the Sharepoint doc list, it broke my flow. The error message is listed below. I have to update the file weekly and having to go back in the flow to update the table will be time consuming. Is there a way to build it the flow that even though different excels files will be uploaded weekly, it would have the same name? I hope this question makes sense.
Hi @Olijk
Thanks for your reply. Where you uploading the excel sheet? As a list attachment or document library? Not sure what you meant by changing the spreadsheet out from the Sharepoint doc list? Please explain?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello,
I upload excel sheet to the document library. When I saved a new spreadsheet with the same name and uploaded it to the doc library, my flow stopped working. I had to go back in my flow, delete the list rows present, readd list rows present, update a few connectors and then it worked again. I’m trying to avoid not having to do this all the time. Please help
Thank you!
Hi @Olijk
Yes that will fail because behind the scenes the identifier will be different for each Excel file.
Here is my blog about how to create excel table dynamically and read.
You might need something like this to implement.
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogHello,
Thank you! I will try this. Can I still use my same recurrence trigger at the beginning? Your trigger is when a file is added. Also, does all these steps need to be before the list rows in table and the remainder of my flow?