Skip to main content

Notifications

Power Apps - Building 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!

  • ahartsfield Profile Picture
    ahartsfield on at
    Re: Unable to get "value" in Append to string variable action

    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. 

  • Pstork1 Profile Picture
    Pstork1 64,996 on at
    Re: Unable to get "value" in Append to string variable action

    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
    ahartsfield on at
    Re: Unable to get "value" in Append to string variable action

    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
    Pstork1 64,996 on at
    Re: Unable to get "value" in Append to string variable action

    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
    ahartsfield on at
    Re: Unable to get "value" in Append to string variable action

    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
    Pstork1 64,996 on at
    Re: Unable to get "value" in Append to string variable action

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

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

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard