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