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!
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.
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.
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.
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.
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.
To convert a multiselect column entry into a string use the Join() function.
join(<<columnname>>,';')