Answered

Getting dates between datepickers.

(0) Share

Report

Posted on by LiamR89

Hi all after some help please,

Built the beginnings of a Holiday booking app (copied from a very good guide here)

I'd like to add in a gallery showing all dates between the start and end dates booked, to allow users to select if this day is a half day.

I imagine it is some combination of sequence and for all but I can't get it , also i'd only like to show the days we're actually booking - so exclude any weekend days and non working days ( I have this working in a label)

So for the below dates picked there are only actually 2 working days so I'd like my horizontal gallery just to have those days.

Any help will be much appreciated.

Thanks

2021-03-11 13_52_51-Graphs - Power Apps.png

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

LiamR89 51 on at

Like
a
(0)

Report
Copy link

Link copied!

I have this working, could have combined the filters but it works regardless.

Filter(
Filter(
Filter(
AddColumns(
Sequence(
Sum(
DateDiff(
dte_Event_StartDate.SelectedDate,
dte_Event_EndDate.SelectedDate,
Days
) + 1
)
),
"AddedDate",
DateAdd(
dte_Event_StartDate.SelectedDate,
Value
) - 1
),
Text(
AddedDate,
"[$-en-US]ddd"
) <> "Sat"
),
Text(
AddedDate,
"[$-en-US]ddd"
) <> "Sun"
),
Not(AddedDate in NonWorkingDays.Date)
)
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@LiamR89

Please consider changing your Formula to the following:

Filter( ForAll(Sequence(DateDiff(dte_Event_StartDate.SelectedDate, dte_Event_EndDate.SelectedDate, Days) + 1), With({_cDate: DateAdd(dte_Event_StartDate.SelectedDate, Value, Days)}, { AddedDate: If(WeekDay(_cDate) = 7 || WeekDay(_cDate) = 1 || !(_cDate in NonWorkingDays.Date), Blank(), _cDate) } ) ), !IsBlank(AddedDate) )

That should give you what you are looking for and perhaps a little easier to maintain and change.

I hope this is helpful for you.