StartWith current week of the year

(0) Share

Report

Posted on by ssskimmed

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 (2)

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