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:
List rows in present table
create an html table
apply to each and inside that loop send email
Solved! Go to Solution.
Please have a look at my tutorial video
Once you extracted the distinct values (email address) use the select filter action step to filter the values
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?
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.
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?
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
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.
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?