Answered

Power Apps V2 String to Multi select Sharepoint document set column

(0) Share

Report

Posted on by DS-14111351-0

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!

Categories:

Business Process Flows

All responses (4)

Answers (1)

DS-14111351-0 14 on at

Like (0)

Report

Power Apps V2 String to Multi select Sharepoint document set column

Screen shoot from my flow

This is from running my test
Suggested answer

Nived_Nambiar 16,877 on at

Like (0)

Report

Power Apps V2 String to Multi select Sharepoint document set column

Hi @DS-14111351-0

Can you show how json which you are passing looks like - seems like it is not as per schema

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!
DS-14111351-0 14 on at

Like (0)

Report
Power Apps V2 String to Multi select Sharepoint document set column

I've created the Schema as suggested but came back with an error upon testing :
Action 'Parse_JSON' failed: The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: C. Path '', line 0, position 0.'.

{

"type": "object",

"properties": {

"Value": {

"type": "array",

"items": {

"type": "string"

}

}

}

}
Verified answer

Nived_Nambiar 16,877 on at

Like (1)

Report

Power Apps V2 String to Multi select Sharepoint document set column

Hi @DS-14111351-0

I think you should parse the input string coming from power apps trigger using parse JSON and then convert it to the following format which can be passed to drop-down field of update file properties action as shown below

[

  {

    "Value": "C3 - Hexavalent chromium compounds (Y21)"

  },

  {

    "Value": "C6 - Copper compounds (Y22)"

  },

  {

    "Value": "C7 - Zinc compounds (Y23)"

  }

]

See below flow for reference,

The above action transform the below json structure to json object

{
"Value": [
"C3 - Hexavalent chromium compounds (Y21)",
"C6 - Copper compounds (Y22)",
"C7 - Zinc compounds (Y23)"
]
}

Now use the select action to transform to final format which can be passed to dropdown (as shown first)

Now the output of select action can be passed to the multiselect column value in sharepoint actions.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!