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

Видео Power Automate Get Unique Values from Array | Distinct Items from Excel, SharePoint & Dataverse канала Reza Dorrani