web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Unable to get "value" ...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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.

 

ahartsfield_0-1703878931706.png 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. 

ahartsfield_1-1703878981567.png

ahartsfield_2-1703879095109.png

ahartsfield_3-1703879162284.png

 

Much appreciation for any ideas!

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    68,923 Most Valuable Professional on at

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

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

     

  • ahartsfield Profile Picture
    on at

    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.

  • Pstork1 Profile Picture
    68,923 Most Valuable Professional on at

    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.

    image.png

  • ahartsfield Profile Picture
    on at

    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.

     

    ahartsfield_0-1703882006561.png

     

  • Pstork1 Profile Picture
    68,923 Most Valuable Professional on at

    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.  

  • ahartsfield Profile Picture
    on at

    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. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 88

#2
WarrenBelz Profile Picture

WarrenBelz 85 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 45

Last 30 days Overall leaderboard