Concat variables

(0) Share

Report

Posted on by Eeyore2005

119

Dear all,

I have a flow with a trigger "When an item is created or modified" and in one of my conditions I need all the items from the SP list to be exported to a csv and sent by e-mail.

The problem is that one of the choice fields is multi-select field (Destination Country) and that is why I need a variable to have all the choices in one field as a string (DestinationCountries).

However, as a result of my flow below I get a csv with all the list items, but all of them have the same value from the multiselect choice field - DestinationCountries of the item that was modified.

Could you please advise how to avoid having all the rows in the csv with the same destination countries?

Thank you in advance.

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Suggested answer

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

Set variable would keep updating the values from the previous iteration with the recent one, to avoid this from happening you can use "Append to string variable" action

Was this reply helpful? Yes No
Verified answer

Chriddle 8,685 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
A more efficient method using XPath instead of loop and variable:

Here the Sharepoint's choice column is named "TestChoice".

Create an XML from the TestChoice array and query the values.

Then join these values.

join( xpath( xml(json(concat('{"Root":{"Item":', item()['TestChoice'], '}}'))), '//Item/Value/text()' ), ',' )

The result looks like this:

Was this reply helpful? Yes No