Help with unique values

[Olijk]

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

[abm]

Hi @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

[Olijk]

Hello,

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?

[Olijk]

Also, I saw in your video, a Sharepoint list. My info is from and excel file

[Olijk]

I received this message

 

[Olijk]

I tried again and am still getting duplicate emails 

[abm]

Hi @Olijk 

Could you post a sample 5 rows of data?

Thanks

[abm]

Yes in your case you need the Excel connector.

[Olijk]

This is just a snippet, but it’s usually 60 unique sales rep email values

 

[Olijk]

Thank you!

[Olijk]

Also, forgot to mention that this data will change weekly. I would upload files to Sharepoint weekly 

[abm]

Hi @Olijk 

Thanks for your reply.  I will update something soon.

Thanks

[abm]

Hi @Olijk 

Thanks for your reply.  I will update something soon.

Thanks

[Olijk]

Also, when changing the spreadsheet out from Sharepoint it broke my flow… I added more actions… this was the error message

 

[abm · Accepted 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

[Olijk]

Hello,

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.

[abm]

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

[Olijk]

Hello,

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!

[abm]

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.

Power Automate – Excel – How to create Table and Read the Contents Dynamically? | @mydevexperience #...

You might need something like this to implement.

Thanks

[Olijk]

Hello,

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?