Skip to main content

Notifications

Community site session details

Community site session details

Session Id : dKXHo9mlVe1lR8e+/LWSW8
Power Automate - Building Flows
Answered

Power Apps Collection equivalent in Power Automate

Like (0) ShareShare
ReportReport
Posted on 3 Jan 2022 16:07:24 by 19

Hi,

Where in PowerApps we can build collections to then use values from there within the app, how can we build collections in Power Automate and how do we call upon the values?

 

e.g. I have this collection in an app. I want to convert this to Power Automate.

 

ForAll(
 Sequence(30,1),
 Collect(
 colDateRange,
 {
 RowIndex: CountRows(colDateRange) + 1,
 Date: DateAdd(Today(), Value)
 }
 )
);
//Remove Weekends from the calculated collection
RemoveIf(
 colDateRange,
 Weekday(Date) = 1 || Weekday(Date) = 7
 ) > 0
);
  • Verified answer
    Pstork1 Profile Picture
    66,442 Most Valuable Professional on 03 Jan 2022 at 17:43:24
    Re: Power Apps Collection equivalent in Power Automate

    image.png

    image.png

    image.png

  • TheGame Profile Picture
    19 on 03 Jan 2022 at 17:11:39
    Re: Power Apps Collection equivalent in Power Automate

    Thank you for your quick response, however everything just went well over my head. The only part I understood is the part i have to initialize an array variable. 

  • Pstork1 Profile Picture
    66,442 Most Valuable Professional on 03 Jan 2022 at 16:40:05
    Re: Power Apps Collection equivalent in Power Automate

    The equivalent of a collection in Power Automate is a JSON array.  Create it by creating an array variable and then appending JSON formatted records to the array.  You can then access the records and the values in the records using an Apply to Each loop.  To create the array you want use a Do Until loop and a counter to create the Rows.  Using a condition inside the loop will let you ignore weekend days.

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 276 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 234 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 210

Overall leaderboard
Loading started