Answered

How to create a dropdown box containing all days of the year

(0) Share

Report

Posted on by YapaYapa

125

Hello everyone,

anyone that can help me with the following issue please:
I would like to have in my form a combo or drop down box where users could pick multiple dates.

Is there any other way rather than having to update dates in the related sharepoint column or using "start" and "end" date?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

turnerj3 2,039 on at

Like (0)

Report
Copy link

Link copied!

@Fedegallo ,
The best way I can think of is to open a blank excel document, format the first column to your date format you wish.
Then enter the first day of year in cell A, then drag the + down to 365 to have all dates. Keep those selected and choose table to create a table out of the dates. Save excel file, go into sharepoint and create a list from xls. Then add your list to powerapps data and make the items for your dropdown the list.

Was this reply helpful? Yes No
timl 36,558 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
@Fedegallo

Here's the formula to create a list of all days in the current year.

With({daysInYear:DateDiff(Date(Year(Now()),1,1), Date(Year(Now())+1,1,1) ) }, ForAll(Sequence(daysInYear,0), DateAdd(Date(Year(Now()),1,1), Value) ) )

Was this reply helpful? Yes No
turnerj3 2,039 on at

Like (1)

Report
Copy link

Link copied!

@timl ,
Hat's off to ya!

Was this reply helpful? Yes No
timl 36,558 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks @turnerj3!

Was this reply helpful? Yes No
YapaYapa 125 on at

Like (0)

Report
Copy link

Link copied!

Hello @timl ,

worked like a charm thanks.
However, I believe my format is off:

How can I solve it?

Was this reply helpful? Yes No
Verified answer

timl 36,558 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!
Hi @Fedegallo

You can format the date by adding a "DisplayText" column and applying your desired date format. In your combobox control, you would set the DisplayFields property to ["DisplayText"]

AddColumns( With( {daysInYear:DateDiff(Date(Year(Now()),1,1),Date(Year(Now())+1,1,1))}, ForAll( Sequence(daysInYear,0), DateAdd(Date(Year(Now()),1,1),Value) ) ), "DisplayText", Text(Value,"dd/mm/yyyy") )

Was this reply helpful? Yes No