web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Unable to join a Share...

Power Automate

Unanswered

Unable to join a SharePoint choice which allow multiple selection:- "@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":-1,"Value":"Select.."}

(0) Share

Report

Report

Posted on by johnjohnPter

1,811 Super User 2024 Season 1

I have a SharePoint choice field which allow multiple selection, as follow:-

now i want to show all the selected options seperated by ';', i tried this formula:-

join(items('Apply_to_each_Charge')?['SurfaceTravelDetails'],';')

but i got this result:-

"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":-1,"Value":"Select.."}

any idea?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

v-yetonggu-msft on at

Like (0)

Report
Hi @johnjohnPter ,

Please try this expression:

join(join(xpath(xml(json(concat('{"body":{"value":', items('Apply_to_each_Charge')?['SurfaceTravelDetails'] , '}}'))), '/body/value/Value/text()'),','),';')

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
johnjohnPter 1,811 Super User 2024 Season 1 on at

Like (0)

Report

@v-yetonggu-msft i got this error on the formula you provided:-

Unable to process template language expressions in action 'Append_to_string_variable_5' inputs at line '0' and column '0': 'The template language function 'join' expects its first parameter to be an array. The provided value is of type 'String'. Please see https://aka.ms/logicexpressions#join for usage details.'.

Was this reply helpful? Yes No

Join the conversation