web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How i can build a comb...

Power Apps

Answered

How i can build a combobox which contain years starting from 2024 till current year

(0) Share

Report

Report

Posted on by johnjohnPter

2,104 Season of Giving Solutions 2025

I want to build a Year filter combobox, which start from 2024 till current year + the All option, so if we are in 2026, the combobox should show:-

All
2024
2025
2026

and so on

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-mengmli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @johnjohnPter ,

Please try this:

ForAll(Sequence(Sum(Year(Today()),-2022),0),If(Value<Last(Sequence(Sum(Year(Today()),-2022),0)).Value,Text(Sum(2024,Value)),"ALL"))

Best regards,

Rimmon

Join the conversation