I always look for the way of how to create fast and performant Flows. I was quite annoyed when each time when wanted to add a couple Users Emails from SharePoint Person field to notification or approval, I needed to use
Append to String variable
action in the For Each loop. In Power Automate Select vs Append to String I will show you the alternative way with Select & Join actions. Of course this technic can be used not only with Person field, but I will start with it.
Table of content:
What more if Users Email property (right side) would be added to Approval action it would create a situation where Approval action is executed one after another for every User. For instance if 3 Users are added it would start Approval action for User 1 and wait for feedback, then start next Approval action for User 2 and so on. Again not desired behavior…
Long story short in many scenarios it is required to group/connect/concat/append values into one string.
I really wanted to write Power Automate Select vs Append to String. As I like this method and for me the Flow configured in such a way is much easier to read, analyze and later on to maintain. As a bonus it is also next method how to remove the loop form your Flows, If you like to remove loops from your configurations check also
Power Automate without loop
.
I hope you will like this method and will start to use it in your Flows.
Post navigation
When I use select data operation it will go array within array can you please help me in this?
Hi Revati,
It all depends on the data which you are using, check if you are using Get Item or Get Items as first is returning object and second array, so if you have People picker with option to select then you have first array of items and second array of Users selected.
If this is not it, please provide more details.
Regards
Dawid
I have 2 list first one is dynamic and second one is approver.
In dynamic, One column is tech(choice type).
In approver, one column is Title(tech value) and another column is approver(people or group type) having multiple approver. and I want to develop a dynamic approval flow.
firstly I used Get items field and in which I enter filter Oquery : Title eq ‘Tech value from dynamic list’
Then i used select data operation in which using from section i entered approver(from approver list) , this forced a apply to each loop which makes sense.
When O go to map the Approvers email, it creates another apply to each. It goes array within the array.
Please help as soon as possible.
