Power Platform Community Forum Thread Details

Hi!

I created a Flow to ask approval to 8 several employees from several departements (quality, program manager, etc.).

Values are filled in a SharePoint list, for each functions, we can have 3 or 4 employees, so it's not automatically filled.

Sometimes, some of this fills are empty (EHS is not mandatory) and I want to start the flow however:

1 - technical expert - mandatory

2 - Safety leader - mandatory

3 - Engineering leader - mandatory

4 - engineering manager - mandatory

5 - EHS

6 - Quality Manager - mandatory

7 - Program Manager - mandatory

How can we make the flow to start the approval to select only the filled value columns ?

Thank you!

Categories:

Building flows

Do you have one approval step where you add all approvers from the different SharePoint columns?

If yes, I suggest creating an array variable called Approvers and appending the approvers from each column into that array. Then use that array in the single approval action.

If columns 1–4 and 6–7 are truly required in SharePoint and can never be empty, you don’t strictly need conditions for them (though adding checks is safer, especially for older items or imports).

For EHS (optional), add a condition to include it only when it’s filled, example:

not(empty(outputs('Get_item')?['body/EHS']))

If true, append:
outputs('Get_item')?['body/EHS/Email']

Finally, in the approval action use:

join(variables('Approvers'), ';')

To remove duplicates use:
union(variables('Approvers'), variables('Approvers'))

Let me know if it helped!