Dropdown with 8 year & quarter values starting from today

(0) Share

Report

Posted on by bmtb

I would like to create a dropdown list with 8 values that display years and quarters, e.g. "Q1'2023". I have tried to do something like this:

["Q1'" & Year(Now()),"Q2'" & Year(Now()),"Q3'" & Year(Now()),"Q4'" & Year(Now()),"Q1'" & Year(Now())+1,"Q2'" & Year(Now())+1,"Q3'" & Year(Now())+1,"Q4'" & Year(Now())+1]

However, the issue with that is that it ignores current quarter and bases everything solely on year. So if we are in Q3'2023, I will still have an option to choose Q1'2023, which I do not want. Instead it should move in sequence 1 quarter forward each time current quarter concludes, i.e. dropdown quarter should be >= current quarter.

Any suggestions on how I could implement this?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

BCBuizer 22,854 Super User 2026 Season 2 on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @bmtb ,

The below formula creates the 8 items, based on the current time:

ForAll( Sequence(8), $"Q{RoundUp( (Mod( ((ThisRecord.Value - 1) * 3) + Month(Now()) - 1, 12 ) + 1) / 3, 0 )}' {Year(Now()) + RoundDown( (Month(Now()) - 1 + ((ThisRecord.Value - 1) * 3)) / 12, 0 )}" )

You can test this by replacing Now() with any date or a reference to a datepicker.