Have a label at the top of app using as a header... [ Awards - Week of ]
Need to auto-populate the date for the end of each week.
You could try the formula listed below. It assumes Sunday is the first day of the week and Saturday is the last day. You can tweak the formula to your use case.
"Awards - Week of " & DateAdd(Today(), 7 - Weekday(Today(),StartOfWeek.Sunday), Days)
Create a label with this formula
Where 6 = the day of week number for Friday
there is currently an idea under review for this: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Addition-of-Week-Number-function-in-Powerapps/i...
Also the user mickg posted some code that should work to display the weeknumber:
If(RoundDown((Today() - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Monday))) / 7, 0) = 0, 52,RoundDown((Today() - Date(Year(Today()), 1, 1) + (Weekday(Date(Year(Today()), 1, 1) - 1, Monday))) / 7, 0))
Hope this will help you! 🙂
If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.
I might as well join the party as I have already done this on a test app and it works fine (using Sunday as End of week)
"Awards for Week ending " & Text( Today() + (8 - Weekday(Today())), LongDate )
Just checking if you got the result you were looking for on this thread. Happy to help further if not.
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!