Answered

Select first day of week and translate to table

(0) Share

Report

Posted on by YasmineH

Hi, I have a app for hour registration, someone else built this one.

You should select the first day of the week, I selected the 30 of oktober (30/10/2023) and than it shows 29 of october till the 4 th of november

but it should start on the 30th ( the field below the 29 is called monday.

the formula is: Today()-(Weekday(Today(); StartOfWeek.MondayZero))+1

But that doens't doesn't do the trick.

ChatGTP told me to use : Today() - Weekday(Today(), FirstDay.Monday) + 1

But this doens't work as well since it doensn't reconize "FirstDay.Monday"

Any tips?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (2)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YasmineH

Try this:

Today() - Weekday(Today(), 2) + 1

My code:
DatePicker1.SelectedDate - Weekday(DatePicker1.SelectedDate, 2) + 1

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
YasmineH 52 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot @SpongYe , I tried your solution an still got this:

Was this reply helpful? Yes No
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YasmineH

The DefaultDate is the initial value of a date control unless the user changes it.
I would suggest to store 'Dag van de week' in a variable and then use the variable to calcualte the weekdays.

Leave the DefaultDate as:
Today()

Datepicker.OnChange:
UpdateContext({ varBeginVanDeweek: DatePicker1.SelectedDate - Weekday(DatePicker1.SelectedDate, 2) + 1 })

On the Label.Text:
Text(varBeginVanDeweek, "dd")

You can create a extra label below the Datepicker:
"Begin van de week: " & varBeginVanDeweek
And hide it when varBeginVanDeweek isBlank():
If(!IsBlank(varBeginVanDeweek), true, false)

Check my use case:
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No
Verified answer

YasmineH 52 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe Thanks a lot, just a minor issue... it hops a week back?

Was this reply helpful? Yes No
Verified answer

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @YasmineH

I get the same value if I change my DateTimeZone from
DateTimeZone.UTC
to:
DateTimeZone.Local
If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻

Was this reply helpful? Yes No