Power Apps Collection equivalent in Power Automate

Like (0) Share

Report

Posted on 3 Jan 2022 16:07:24 by TheGame

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
);

All responses (3)

Answers (1)

Verified answer

Pstork1 66,093 Most Valuable Professional on 03 Jan 2022 at 17:43:24

Like (0)

Report

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

Like (0)

Report

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 66,093 Most Valuable Professional on 03 Jan 2022 at 16:40:05

Like (0)

Report

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.