Unanswered

Power Apps Collection equivalent in Power Automate

(0) Share

Report

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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No
TheGame 19 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Pstork1 68,697 Most Valuable Professional on at

Like (0)

Report

Was this reply helpful? Yes No