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


Report
All responses (
Answers (