Append to String Troubles

Options
Sarah Homan
Sarah Homan
Tenth Anniversary Name Dropper Photogenic First Comment
in SKY Developer General Discussions

I have a long list of flows to get up and running for 2025 and I thought I had started with an easy one…

I have looked through the community and found a couple of other references, but it's not quite making sense. I am happy to also bring this to the Power Automate User Group.

I'm trying to append to string multiple Custom Field Descriptions separated by a “,”.

I first did a Filter Array to isolate the Category I wanted.

A screenshot of a computer Description automatically generated
a2636ed106fed54296deab690ee0f2a0-huge-im

Then looped through the results in hopes of appending to string so all entries were in one field.

A screenshot of a computer Description automatically generated

Expression in Compose: item()?['codetableentry_value']

8c8567a6ac50b33b812eebe5af31b343-huge-im

I'm thinking I'm not using the apply to each correctly.

As always, thank you.

Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary 1,500 Likes 2500 Comments Name Dropper

    @Sarah Homan
    there is no need for the apply to each for the gift custom fields.

    • list custom fields
    • filter array
    • select
      • select the “value” (don't need to specifically use the codetableentry_value, but you can) and don't “map” a field.
    • set varaible (not append)
      • join(body('select'), ‘,’)
  • Alex Wong
    Alex Wong Community All-Star
    Ninth Anniversary 1,500 Likes 2500 Comments Name Dropper

    @Sarah Homan
    Screenshots

    f31320970895c3fa1237dc8ae0d26342-huge-im
    overview of 3 steps
    a604bfc126b21a11f485415e4b5a66c2-huge-im
    make sure to click the “icon” circle in red to remove the “2 fields”. Only need ONE field, and then select “value”
    5befefc067467135bd82a9aab08025cd-huge-im

    join(body('Select'), ', ')

  • Sarah Homan
    Sarah Homan
    Tenth Anniversary Name Dropper Photogenic First Comment

    @Alex Wong
    It worked perfectly; I'll save this for future flows. Thank you

Categories