I hope someone can help me with this situation—it’s driving me crazy!
I have a Document Set in SharePoint, and I’ve built a Power Apps form to create new documents in my library. I use a Power Automate flow (Trigger: PowerApps V2) to send data back to my document set.
Here’s where I’m stuck:
- Inside my Power Apps form, I have a multi-select dropdown connected to a choice column in SharePoint (multi-select enabled).
- To pass the selections from Power Apps to Power Automate, I have to Concat the dropdown values into a string.
- However, I’m having a lot of trouble converting this string input back into the correct multi-select format to update my SharePoint column.
What I’ve Tried So Far:
- Splitting the String in Power Automate using the
split() function.
- Tried using the Select action to map the output with "
Value":@{item()}
- Used Apply to Each and Append to Array Variable to reformat the data.
Current Roadblock:
The flow fails to correctly format the data to be accepted by the multi-select choice column. They always come back as strings looking like this for exemple : {
"Value": [
"C3 - Hexavalent chromium compounds (Y21)",
"C6 - Copper compounds (Y22)",
"C7 - Zinc compounds (Y23)"
]
}
My Question:
How can I properly format a string of multi-select values in Power Automate so it can be sent back to a SharePoint multi-select choice column? I’d greatly appreciate any solutions or workarounds!
