cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Olijk
Helper II
Helper II

Help with unique values

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

43 REPLIES 43
abm
Super User
Super User

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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?

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

I received this message

 

EA06F9A0-FAC9-452A-A752-B24C4A242410.jpeg

Olijk
Helper II
Helper II

I tried again and am still getting duplicate emails 

Hi @Olijk 

 

Could you post a sample 5 rows of data?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Yes in your case you need the Excel connector.



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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

FBB83F62-103A-4F46-A4B7-EA4B94512575.jpeg

Thank you!

Olijk
Helper II
Helper II

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Hi @Olijk 

 

Thanks for your reply.  I will update something soon.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials
Olijk
Helper II
Helper II

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

9C257CE2-A8EA-4343-9EEC-98B80662E3A0.jpeg

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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.

Olijk_0-1644891771779.jpeg

 

 

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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!

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



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

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?

 

6EAC3B31-218C-492D-846C-9EC8EA15221B.jpeg

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,309)