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 Style HTML Table in Power Automate & send in Email - https://youtu.be/VnWg-Eox37Q Power Automate Expression Union – Return Unique Values Blog Post. https://flowaltdelete.ca/2020/06/03/power-automate-expression-union-return-unique-values/ Union function documentation - https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#union Power Automate (Microsoft flow) OData Filter SharePoint - https://www.youtube.com/watch?v=yeAnuTB85eg Power Automate Playlist - https://www.youtube.com/playlist?list=PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0 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