cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
powerupguy
Frequent Visitor

Power Automate collate multiple lines of approvers in a single line separated by a semi-colon

1. There is a  Sharepoint list where the approvers column is a person type column allowing only a single entry (not multiple).

2. For a particular package ID there could be multiple approvers one in each line.

3. In a flow,  need to collate that into a single line of text separated by a semi-colon in a compose or best suited action.

4. This i need to use it as an approval workflow in Power Automate.

How can i do that ?

 

powerupguy_0-1665533555493.png

 

1 REPLY 1
srduval
Super User
Super User

use a get items action, using the odata filter or a filter array step to return only the rows that match the given package ID, then an apply to each for that get items, appending to a string variable (must initialize prior to using in the loop) 

 

alternatively, you can use the join function to replicate the same process as above:
Power Automate Fundamentals # 40: Usage of Join Fu... - Power Platform Community (microsoft.com)

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,416)