Is there a way to set multiple variables in a flow without it applying an apply to each, each time?

(0) Share

Report

Posted on by sLifestyle

So for a bit of background context, I have a SharePoint list with 3 columns which make use of the "Person or group" type. These columns represent different departments. Each column will most likely have multiple values in each entry.

I am using power automate to update the SharePoint list based on a set of requirements and to also send an email out. These emails need to go out to those users in those 3 columns. Each time I go to initialize and set these variables, it creates an apply to each. Meaning, there will be 3 apply to each's in total. Is there a way to avoid this and only perhaps have 1 apply to each?

I'm already needing an apply to each to go through each entry on the SharePoint list totaling the amount of "Apply to Each" actions to 4. It makes the flow look a bit messy and I want it to be as clean as possible. What would be the best way to tackle this if it's at all possible?

All responses (1)

Answers (0)

tom_riha 10,127 Most Valuable Professional on at

Like (0)

Report

Re: Is there a way to set multiple variables in a flow without it applying an apply to each, each time?

Hello @sLifestyle ,

that's the standard behaviour - you have multiple people picker columns, Power Automate prepares the flow to process all the entries one by one by adding a loop.

If you don't want a loop you can use the 'Select' action, This action will allow you to extract values, e.g. email addresses from the array of users in a single step, without the loop as explained e.g. here. Once selected you can send an email to the users or update them in a different SP list.