Format a Date dd.mm.yyyy into yyyy-mm-dd in power Apps
If the DataCardValue is a date picker control (that already gives you the a date value), then you can use the Text function to format it as you want:
Text(
DataCardValue.SelectedDate,
"yyyy-mm-dd"
)
If the date you have is a text value, then you can use the DateValue function to convert that into a date value. The second argument of DateValue is a locale, and the date will be parsed in that locale. In "dd.mm.yyyy" is the default format for the de-DE locale, so you can use an expression like the following:
Text(
DateValue(<your date as text>, "de-DE"),
"yyyy-mm-dd"
)
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.