Announcements
To achieve this in Power Automate, follow these steps:
ID
Power Automate does not have a built-in "Remove Duplicates" function, so we need to use an Array Union Trick:
Use the "Select" action to format the row data.
Use a "Compose" action with the following expression to remove duplicates:
union(body('Select'), body('Select'))
This removes duplicate values because union() merges arrays and automatically removes duplicates.
union()
Use another "Filter array" action.
In From, select the output of the previous "Compose" step.
Set the condition to remove blank values:
item()
is not equal to
''
Use a "Join" action to convert the filtered array into a single string:
,
Finally, use the "Return value(s) to Power Virtual Agents" action (if using Copilot Studio as a bot backend).
Your Copilot Studio will receive a clean, unique, and formatted row data without duplicates or blank values. Hope it helps!!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 586
chiaraalina 170 Super User 2026 Season 1
deepakmehta13a 118
