web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Calendar Bot for Holidays

Power Apps

Unanswered

Calendar Bot for Holidays

(0) Share

Report

Report

Posted on by Cjcolson

Does anyone know if Power Apps can be used to calculate the next weekday after a holiday?

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Cjcolson
It would be pretty straightforward I think.

Make a Collection of all your holidays like this.

ClearCollect(colHolidays, [Date(2020, 1, 1), Date(2020, 4, 3), Date(2020, 12, 25)])

I assume you are selecting a date from a DatePicker. This code would add 1 day to the DatePicker today.

If(DatePicker1.SelectedDate in colHolidays.Value, DatePicker1.SelectedDate + 1, DatePicker1.SelectedDate)

If this wasn't what you wanted to know, please provide more details than just one sentence!

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Joel CustomerEffective 3,224 on at

Like
a
(0)

Report
Copy link

Link copied!
so it would depend on how you want to do it. For example, Weekday(DatePicker1.SelectedDate) will get you the numerical day of the week for a selected date

So if I feed it December 25, 2020, it gives me 6.

So if you want the next day of the week after a holiday, you could set the default date of another date field to
DatePicker1.SelectedDate+1
If by week date you mean next working date, you would have to define what your workplace rules are.
For example, could be something like this if you say that if a holiday happens on on Friday-Sunday, the next weekday should be Monday:
If( Weekday(DatePicker1.SelectedDate) < 8, DatePicker1.SelectedDate + 1, If( Weekday(DatePicker1.SelectedDate) > 5, DatePicker1.SelectedDate + 2 ) )

Join the conversation