web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How can i replace stat...

Power Apps

Answered

How can i replace static ”Monday“ with dynamic value according to today's date.--get todays weekday

(0) Share

Report

Report

Posted on by GGG666

190

Dear all,

How can i replace static ”Monday“ with dynamic value according to today's date.

Filter('Home working schedule',"Monday" in Home_working_day.Value)

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

Mike2500 1,247 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
The Text function can be used to format dates, and we can use custom formats:

Text(Today(),"dddd")

"dddd" = day of the week. "ddd" = day of the week, abbreviated.

You can just swap the above in for the "Monday":

Filter('Home working schedule',Text(Today(),"dddd") in Home_working_day.Value)

Join the conversation