Power Platform Community Forum Thread Details

Hi all,

I'm struggling with a dynamic approvals workflow.

I have two lists - one for new submissions that triggers the automated flow, and one with dynamic approvers based on "Subjects".

in the submissions list, there's a multiple selectable choices column called "Subject".

In the dynamic approvers list, for each "Subject", there's person column with multiple approvers per "Subject".

Regardless if one or multiple "Subjects" are selected, I want to combine all the approvers together that apply to the one or more "Subjects" into one string of e-mail addresses to send the approval to.

Some "Subjects" approvers may have the same approvers as other subjects, so a given approver might appear twice based on the subjects picked.

I'm struggling (!) with trying to get the list of combined approvers e-mails into a single string with duplicate e-mails removed. Every video I find showing how to do this has multiple approvers but doesn't combine multiple topics approvers together into one.

Thanks in advance for any assistance!

Categories:

Building flows