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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Appending Filter Query...
Power Automate
Unanswered

Appending Filter Query results to an Array

(0) ShareShare
ReportReport
Posted on by 46

Hi,

I am trying to update a multi-person column using the output of a filter query. However, I can't figure out how to convert the output to a proper Array structure.

 

I want to convert the below output (left) to the desired outcome shown in Screenshot on the right (Sponsor) so that I could use it to update a multi-person column.

MaanR_0-1649278725655.png MaanR_1-1649278863636.png

 

Screenshot for my flow setup.

MaanR_2-1649279041725.png

 

I can't use the output of select in Append to Array Variable as this action combines the multiple people together which makes it useless in Append to Array Variable.

MaanR_3-1649279122346.png

 

@RezaDorrani 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,865 Most Valuable Professional on at

    Hi @MaanR 

     

    Try the below steps:

     

    1. Declare an array.

     

    2. Construct an Apply to each to read the body output (your screenshot left hand side one)

     

    3. Inside the loop add a compose action step and add the following:

     

       {

          "Claims":item()

       }

     

    Note: Above item() must be add as an expression.

     

    4. Next Append the array using output from the compose step.

     

    5. Finally map the array variable for the update.

     

    Thanks

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard