Unanswered

Unable to get "value" in Append to string variable action

(0) Share

Report

Posted on by ahartsfield

Hi,

I have a SharePoint list which has a couple multi-choice/select multiple answer fields. I am attempting to create a flow that generates both an Excel report and an HTML table based on a limited view of the SP list. The problem is, when I use the action "Append to string variable", neither of my multi-choice fields have the "value" option in dynamic content. I'm hoping someone can either help me determine what I'm doing wrong, or give a different idea of how to accomplish this.

My flow is currently messy because I've been attempting to use Parse JSON, but haven't been able to get the Schema to make any sense.

I'm aware my Select action doesn't have the value field filled in. It was in there when I was testing and was working fine, so that is not the problem.

Much appreciation for any ideas!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
To convert a multiselect column entry into a string use the Join() function.

join(<<columnname>>,';')

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

Thank you! Use the join function where? As a separate compose action? Should I be removing the Parse JSON and and Select actions?

I've had success in other flows getting these multi-select fields to show the correct values, but in those instances the "value" option shows up in the dynamic content.

Was this reply helpful? Yes No
Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Join() is used to concatenate the values of a multiselect string array into a single string with a delimiter. So you would use it in place of the reference to a column value in something like an append to string. The exact syntax is dependent on the type of column you are using. Is it a choice column, a lookup or something else? In the following screenshot its a choice field.

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

I removed the JSON action and updated the Select and Compose actions. The Select action would not allow me to add the multi choice field without turning it into a double apply to each loop. And then the Compose join expression would not let me refer either to the Select action or the Apply to each loops.

Was this reply helpful? Yes No
Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Can you show the definition of your multiselect column? You will have at least one Apply to each since you are accessing a set of records with that column. But you shouldn't need two. Also, the compose needs to be inside the loop if you want to access the values. there shouldn't need to be the Apply to Each 3 loop.

Was this reply helpful? Yes No
ahartsfield on at

Like (0)

Report
Copy link

Link copied!

It adds the first loop when I put the multi-select field in the "From" field. Then it adds the second loop when I add the multi-select value field to the Map field. I'll try adding the compose inside the innermost loop.

Was this reply helpful? Yes No