Convert Object to String with seperator.

(0) Share

Report

Posted on by anthonys123

445

I've tried following a number of online solutions but they either don't apply directly to this simple action or just don't work.

The input is coming from a Choice column in SharePoint. It could be any number of items from 0 to 12+. I need to get the "VALUE" shown below and convert it to a string to feed into a Child Flow.

Expected output should be "M365 Basic, Google, Cell Phone".

[
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 0,
 "Value": "M365 Basic"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 3,
 "Value": "Google"
 },
 {
 "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 "Id": 9,
 "Value": "Cell Phone"
 }
]

All responses (5)

Answers (1)

Verified answer

anthonys123 445 on at

Like (0)

Report

Re: Convert Object to String with seperator.

Solved.
I found this helpful How to convert array to a string in Power Automate (tomriha.com)
anthonys123 445 on at

Like (0)

Report

Re: Convert Object to String with seperator.
VictorIvanidze 12,463 on at

Like (0)

Report

Re: Convert Object to String with seperator.

Could you show your current flow please?
anthonys123 445 on at

Like (0)

Report

Re: Convert Object to String with seperator.

Could you be more specific, please?
VictorIvanidze 12,463 on at

Like (0)

Report

Re: Convert Object to String with seperator.

Use the "Select" action of the "Data Operation" connector.