@Captainclaw
Get the Multi-Choice Field Key
In your previous flow run, view the body outputs from the form response. Locate the key (red text between the double quotes) for your multi-choice field and copy that text to your clipboard.
Convert the Multi-Choice Field String to JSON
Add a Compose action and expression to parse the JSON. Start off with a question mark, square brackets and single quotes
?['']
Paste the key from your clipboard between the single quotes. Mine looks like this (yours will be different)
?['r7ee873b61d10400c8280a445657a31ae']
Place your cursor at the start of the expression. Tip: Press the up arrow key.
Click on the Dynamic Content tab and insert the body dynamic content from the Get response details action.
My expression looks like this.
outputs('Get_response_details')?['body']?['r7ee873b61d10400c8280a445657a31ae']
Place your cursor at the start of the expression and wrap everything in a json() function. Type with an opening bracket at the start of the expression.
json (
Place your cursor at the end of the expression. Tip: Press the down arrow key. Enter a closing bracket.
This Compose action will output an array of the multi-choice selections.
Add a Value Key to the Array
If you want to map the multi-choice selections to a multi-choice column in SharePoint you need to add a value key to the array.
Add a Select action to your flow. In the From field, insert the Outputs from the Compose action above.
In the Key field enter the word Value. In the value field, enter an expression. Use the item() function to get each item from the array.
item()
To Convert the Array to a String
If you want to map the multi-choice selections to a single line text column in SharePoint you need to convert the array to a string.
Add a Join action. In the From field, insert the outputs from the Compose action above. In the Join with field, insert whatever separator you'd like between each selected option.
For my example I've entered a comma only.
This is what the output will look like. Note: If you'd like a comma and a space between each item, you'll need to add the space after the comma in the Join with field.
Create Item
Add a Create Item action to your flow. In the multi-choice column drop down click on the icon to the right of the dropdown to switch the input mode.
Insert the output from the Select action.
Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!
|
