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 / Need help in Appending...
Power Automate
Unanswered

Need help in Appending Select Array Output

(0) ShareShare
ReportReport
Posted on by

Hi Guys,

Need your help in fix my flow.

I am sending HTTP request, in response I am getting top 100 values, total values are 1999, so I added Do Until action item >>In Do Until Section I have HTTP request in which startAt is keep on changing add +100 every run.Do until stops when startsAt > 1999. HTTP is working fine.

Under HTTP I have added Select Array :

 

HTTP Resposne is :

[
{
"id": "11820",
"value": "Arcelik Anonim Sirketi",
"disabled": false
},
{
"id": "11821",
"value": "Littelfuse, Inc.",
"disabled": false
},
{
"id": "11822",
"value": "Red Rock Resorts, Inc.",
"disabled": false
},
{
"id": "11919",
"value": "Fcc Construccion S A, UK Branch Office",
"disabled": false
}
]

From This response I have added select to get Value only, so Select output is :

[
"Arcelik Anonim Sirketi",
"Littelfuse, Inc.",
"Red Rock Resorts, Inc.",
"Ambuja Cements Limited",
"B E & K, Inc.",
"Bourns, Inc."
]

Now I want to append this response into a single array. Like HTTP request is running 20 times, 20 time I get different value. I want to those into a single array. Kindly suggest. How can I do this.

When I am trying to create an Array variable and appending into it, getting this error :

The input value is of type 'Array' which cannot be appended to the variable 'cfValues' of type 'Array'. The action type 'AppendToArrayVariable' only supports values of types 'Float, Integer, String, Boolean, Object'.

Categories:
I have the same question (0)
  • Verified answer
    v-yueyun-msft Profile Picture
    on at

    Hi , @vikrantyadav11 

    According to your description, you want to union your array from the output of the "Select" action in your Do until action.

    You can refer to my test flow.
    First , we need to initialize the variable before your do until:

    vyueyunmsft_1-1718328684142.png

     

    Then we in the do until action, you can refer to :

    vyueyunmsft_2-1718328741009.png

    union(body('Select'),outputs('Compose'))

     

    Then in the last and out of your do until action, you can get the union array:

    vyueyunmsft_3-1718328785694.png

     

     

     

    If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

     

    Best Regards,

    Yueyun Zhang

     

     

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 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard