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 ?
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)
User | Count |
---|---|
27 | |
14 | |
12 | |
10 | |
9 |
User | Count |
---|---|
51 | |
29 | |
28 | |
24 | |
21 |