Answered

Format datepicker output in a label

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello guys,

I have this super simple app that uploads file to a specific document library. I want the name of the uploaded to be reporting data + selected date. But when I call on the datepicker, it formats the output in dd/mm/yy, and files are not allowed to have a "/" in their name. So I want for format the output of the datepicker to longdates. I tried changing the format in the datepicker control element, but it doesn't change the output

I was thinking maybe I could make this work with a couple of variables, but I can't seem to figure it out, please help.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Pstork1 69,665 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Use Text() when you are concatenating the label to reformat the date to whatever format you want. for example.

Concatenate("Reporting Data ", Text(DatePicker1.SelectedDate, "yyyy_mm_dd"))
BrianS 2,407 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

You could use variable is you need to refer to the name later or set the name to

"Reporting Data" & Text(DateTimeValue(Text(DatePicker2.SelectedDate)), "yy-mm-dd")

I know there are other formats you can use, but I think that one will give you a valid file name, and I could not find the reference.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This is exactly what I was looking for, thank you very much! 🙂