web

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

News and Announcements icon

Power Platform CommunityForums Power Apps StartWith current week...

Power Apps

Answered

StartWith current week of the year

(0) Share

Report

Report

Posted on by ssskimmed

4

There's likely an easy solution to this but I'm struggling to find it. When opening the app, I need it to start with the current 'Week No.' at the top and then go down in ascending order. So, starting with Week 12 now, for example. How can I do this?

Screenshot 2024-03-20 at 10.44.14.png

Screenshot 2024-03-20 at 10.44.41.png

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @ssskimmed ,

I assume 'Week No.' is a number column, please try this formula:

Sort( Filter('MM Team','Week No.'>=WeekNum(Now())), 'Week No.'-WeekNum(Now()), SortOrder.Ascending )

Best Regards,

Bof

Was this reply helpful? Yes No
ssskimmed 4 on at

Like (0)

Report
Copy link

Link copied!

That's perfect, thank you!

Was this reply helpful? Yes No

Join the conversation