Performing a FOR loop in PowerApps

[Anonymous]

Until FOR loops are added in PowerApps, I have a workaround that I've been using and it's really come in handy.

I start by adding a collection in my App's OnStart property (I'll show at the end how to do this in Flow, which I prefer).

I've attached a template for this from 0-1000 (For.txt at the bottom)

ClearCollect(Loop,
{Index:0},
{Index:1},
{Index:2},
{Index:3},
...
{Index:100}
)

 You can now perform a FOR loop by filtering this collection. For example, if I want to get a collection of dates that are 7 days from a selected date, I can do this:

Clear(NextDates);
ForAll(Filter(Loop,Index<=7),
Collect(NextDates,
 {
     Date:DateAdd(DatePicker1.SelectedDate,Index,Days),
     DaysSincePickedDate:Index,
     DayOfWeek:Weekday(DateAdd(DatePicker1.SelectedDate,Index,Days))
}
))

I get this result:
\

Remember that the numbers don't have to be hardcoded. You can use CountRows(),a numeric input, or any other integer to drive this code.

The shell of the FOR loop looks like this:

Set(i,0);
ForAll(
Filter(Loop,Index<=7,Index>=i),
//Code
)

This would be the equivalent to something like this:

for (i = 0; i <= 7; i++)
{
 //code
}

To clean up the Loop collection, I use Flow. Here's what that solution looks like:

I can now use this code to get my Loop collection (I like to rename the column to Index, since Value is the generic term from Flow)

ClearCollect(Loop,RenameColumns(For.Run(1000),"Value","Index"));

That will return a collection of 1000 rows without all the manual coding! This Flow is pretty slow, so you can also setup this logic to only load it once for each user (this saves the collection to memory on mobile):

LoadData(Loop,"Loop", true );
If(CountRows(Loop)=0,
  ClearCollect(Loop,RenameColumns(For.Run(100),"Value","Index"));
  SaveData(Loop,"Loop")
  )

[Anonymous]

True. And you wouldn't necessarily need to bother with incrementing since you already have the loop number to either use or operate on. Of course a count table inside the loop would work too.  You could use the below code (with what I posted earlier) to make your number list real quick.

Collect(countTable, {nextNum: 0});

ForAll(FirstN(alongtable, 10),

Collect(countTable, 

{nextNum: Value(Last(countTable).nextNum) + 1}))

[007James_Bond]

Hi.

I have similar kind of requirement to find users consecutive months.

We have a table in sharepoint that have ID,Name,Months column.

Let say find the 5 consecutive month of users but always value should dynamic .

please suggest can we apply loop>

[MarcCoton]

Another option for creating an Index of numbers for managing your processing:

You can add an index column to any collection using these functions:

ClearCollect, AddColumns, CountIf, ForAll, Table

//Create a collection containing my shopping list
ClearCollect(colShopping1, Table({List: "Apples"},{List:"Bananas"},{List: "Cherries"}));

//Append two columns to the collections
ClearCollect(colShopping2,AddColumns(colShopping1,"Processed",false, "Index", 0));

Then use ForAll to loop through each record, updating the Index value with the CountIf running total, as follows:

//Process each row in turn using ForAll, Adding in the count of those already true and then updating Processed to be true (for next time around)
ForAll(colShopping1, Patch(colShopping2, ThisRecord, {Index: CountIf(colShopping2,Processed=true), Processed: true}));

[JonP2]

• Open an excel spreadsheet.
• type “1” in cell A1
• type “=A1+1” in cell B1
• with B1 selected, Shift+Right Arrow to select the remainder of row 1
• Ctrl+R to fill the ++ integers across row 1
• file > save as > comma separated values CSV
• open the CSV in any text editor
• copy and paste all (or what you need) of the CSV contents between the array brackets “[]” in PowerApps

Should take less than a minute to produce what’s needed.

[Richard_Ogoma]

This was surely written in love. So brilliant ☺️

[Richard_Ogoma]

ClearCollect(LoopMaster, 
    RenameColumns([0,1,2,3,4,5,6,7,8,9],"Value","Index"))

Correction: To create the 'Loop' collection....

[joshmyg]

How to write this kind of nested loops in PowerApps

Main loop -         1 2 3 4 5 6 7 8 9 10 ... 123 124 125 126 127 128   129   130  131 ...

Backend loop -    1 2 3 4 5 6 7 1 2 3  ...  1     2       3     4     5     6   7          1       2  ....

Please also give me some references

[Anonymous]

Here.  This is just the thing you need: 

Sequence function in Power Apps - Power Platform | Microsoft Learn

[Craig_Humphrey]

Good find! That's got to be a new function!

[Anonymous]

Thanks. Its the first time I had need of a loop, so I wouldn't know how long the Sequence function has been around, but it does the trick quite nicely. I had to make a horizontal gallery that acted as a timeline for a project. To do that, I needed to create a record for every day in the project scope. This worked great: sequence DateDiff +1. Then stet a variable for the day defore you want to start your timeline. Run it in your ForAll statement and you're in business. Throw some formatting in there to pick up milestone dates and you have a beaufiful thing.