web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Collecting a sequence ...
Power Apps
Unanswered

Collecting a sequence of days

(0) ShareShare
ReportReport
Posted on by 2

I have the following formula to collect each day and its next day. The problem I am having with this is the 'Value' seems to be the number of iterations it has passed through the sequence. This means if the first day displayed by the calendar is not the selected month then it will bleed into the wrong dates. I tried fixing this by simply copying and pasting the formula for calculating each 'Value'.

 

I feel like if PowerApps had breakpoints like coding with C# in Visual Studio then I would be able to have a breakpoint to check what values are being passed into the filter. I have no idea why but as far as I know there is no feature for this. Does anybody know a way around this or a way to debug the values other than sticking them in a gallery that displays them?

 

Code:

UpdateContext(
{
colDays: ForAll(
Sequence(42),
{
Value: varFirstDayOfMonth + Value - 1 - Weekday(
varFirstDayOfMonth,
StartOfWeek.Sunday
) + 1,
NextDay: varFirstDayOfMonth + Value - 1 - Weekday(
varFirstDayOfMonth,
StartOfWeek.Sunday
) + 2,
EventsOnThatDay: Filter(collectionOfEventsOnThatDay, Value = EventDay)
}
)
}
);

 

 

 

Thankyou

Categories:
  • JR-BejeweledOne Profile Picture
    5,836 Moderator on at

    What are you trying to accomplish?   I have built a few calendars that show events on certain days, so maybe I can help if you tell me what you ware wanting to do.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 342 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 258

#3
Mohsin Ali Profile Picture

Mohsin Ali 231

Last 30 days Overall leaderboard