Iterate over each Day between StartDate and EndDate by using ForAll

(0) Share

Report

Posted on by BKGOUD

Hi All,

I have a connector which should be return somedata based on From date to To date.

Ex: 03/11/2020 to 05/11/2020. Like For loop, based on start and end date. Can some help me on this by using ForAll in powerapps.

Like below:

for(DateTime date = StartDate; date.Date <= EndDate.Date; date = date.AddDays(1))
{
...
}

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @BKGOUD ,

The number of iterations of ForAll() function depends on the number of rows in collection, so first use DateDiff() function to get the total number of days, and use sequence() function to generate a sequence collection. Please try this:

ForAll(
Sequence(DateDiff(StartDate, EndDate, Days)),
...
)

Hope this helps.

Sik

Was this reply helpful? Yes No
BKGOUD 95 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

Thanks for helping me.
I'm using the findmeetingstimes connector to loop based on the start date and end date.
So, i have to run my loop based on date and by startdate and enddate each iteration to the connector.
Could you please help me on this.

ClearCollect(
ConflictsRooms,
Office365.FindMeetingTimes(
{
RequiredAttendees: AllRoomsConnector,
IsOrganizerOptional: true,
Start: DateTimeValue(StartDateTimeUTC1),
End: DateTimeValue(EndDateTimeUTC1),
MeetingDuration: 60,
MinimumAttendeePercentage: "1",
ActivityDomain: "Unrestricted"
}
)
);

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @BKGOUD ,

Sequence() function generates a sequence collection starts from 1, so the start and end parameter is based on the StartDate and sequence value of the current loop.

Clear(ConflictsRooms);
ForAll(
Sequence(DateDiff(StartDate, EndDate, Days)),

Collect(
ConflictsRooms,
Office365.FindMeetingTimes(
{
RequiredAttendees: AllRoomsConnector,
IsOrganizerOptional: true,
Start: DateAdd(StartDate, Value-1),
End: DateAdd(StartDate, Value),
MeetingDuration: 60,
MinimumAttendeePercentage: "1",
ActivityDomain: "Unrestricted"
}
)
);

)

Hope this helps.

Sik

Was this reply helpful? Yes No