Power Automate Get Unique Values from Array | Distinct Items from Excel, SharePoint & Dataverse

This video is a step-by-step tutorial on how to get Unique or Distinct values from Array in Power Automate flows. The flow will use an expression function called Union to get the unique values.
We will Get Unique values from Array of data coming from Excel file, SharePoint list & Dataverse Table.

Scenarios covered:
✅ Excel Sales Report
✅ SharePoint Task Reminders
✅ Dataverse Devices Assignment Report

Power Automate Expression Union – Return Unique Values Blog Post.

Power Automate Playlist -

Table of Contents:
00:00 - Intro
00:36 - Get Unique / Distinct Values from Array using Union expression in flow
05:16 - Get Unique Values from Excel in Power Automate - Send Sales Report
15:26 - Get Unique Rows from SharePoint List in flow - Task Due Reminders
19:34 - Get Unique Values from Microsoft Dataverse in flow - Devices Assigned Report
22:02 - Subscribe to Reza Dorrani channel

#PowerAutomate #Excel #SharePoint #Dataverse #UniqueArray

[Itsprincessa]

Thanks Reza, I finally achieved what i wanted with this video.

[GMarshll]

This is the best flow on YouTube, saved me so much time in sending reports. Thank you!

[liko]

I have been looking for this solution for several days
Thanks for the hard work!

[Artiqx]

Again, you are one of the most valuable presenters here on youtube. why? high value per video, videos are well structured, short and crisp project overview (very important. most dont do it) and finally you bring it to the point without blabla. good to have you here!

[TheDistractionStudio]

Not only are your videos informative but your use cases are the best. Thank you

[analyticsadda]

Thanks Reza for this . You are a star. This will also work on powerbi click flow for making the email id unique there

[pesalsa]

Many many thx Reza, the most useful video about loop and uniq email to send. Thx from Bordeaux France

[KamaleshBhamare]

At first, I thought it might not possible in Power Automate. But then I saw your video. :) You make complex things look so easy. Thank you so much!

[vkrish]

Yet another amazing video with Reza's signature crystal clear explanation.

[krishnabairi]

This is exactly (send email with the table of items for each owner) what I asked you for help few months ago and I am glad that finally you made it. Thank you Reza.
I actually achieved it via a different method but it required one more manual step in excel...

[olisaemekaaghabuilo]

Thanks Raza.... Today this video have saved me a lot of time of having to brainstorm over dynamic filtering of data source. Thanks once again for your kind efforts.

[johnnytao]

I have similar project few months ago. You make my life easier after watching your video. Great work !

[jaded]

Reza, You saved me today! Thank you so much for this extremely informative and user friendly demo!!

[yirgak]

Hi Reza, Thanks for all your supportive posts. I posted a question yesterday and waiting to have some clues on that. Thanks!

[CédricCHEVALIER-yd]

I've just discovered this old video. Great job. I want more videos like this

[reginaldbal]

Hi Reza, after spending hours of searching I came across this video of yours which was exactly what I needed. Thanks a lot!

[TaxMentors]

This is very informative and amazing video. Thanks Reza brother. You solved many of our work related peoblems. Wish you good luck for keep continue to spread your knowledge.

[arshad]

Awesome Reza...there is always something new to learn from your videos and there is always a use case for me..really appreciate your work and dedication..

[leoszavrel]

After a few days of development and googling, your video helped me the most! Thank you very much, Reza!

[handro]

Thank you so very much. I needed this and could not find on any website how to do the select right. You're awesome.