Hi@rsparks,
Based on the issue that you mentioned, do you want to format the date as the "dd-mm-yyyy"?
Could you please share a bit more about the related date column, is it a DateTime type or a Text type?
Do you use SubmitForm() or Patch() to save data?
If this is a Text column, you could directly use the Patch() as following formula:
Patch(
SPlist,
Defaults(
SPlist
),
{
'test1': Text(
DatePicker1.SelectedDate,
"[$-en-US]dd-mm-yyyy"
)
}
)
If you use the SubmitForm() function, you could modify the Update property of the corresponding data card to the Text column as:
Text(
DatePicker1.SelectedDate,
"[$-en-US]dd-mm-yyyy"
)
And if you use a DateTime column to store the date value, you format the language as "en-GB" that is a correct direction. In european regions, they display date as "dd-mm-yyyy". However, it's not enough to convert the formatting in Power Apps, you need to go to SharePoint's site settings and make some changes.
Go to site settings>Site Administration>Regional settings>Region, select an european country as below:
If this is a DateTime column, you can use Patch() as below:
Patch(
test0917,
Defaults(test0917),
{
Title: "1009",
TestDate: DateValue(
Text(
DatePicker1.SelectedDate,
"[$-en-US]dd-mm-yyyy"
),
"en-GB"
)
}
)
If you use the SubmitForm() function, you could modify the Update property of the corresponding data card to the DateTime column as below:
DateValue(
Text(
DatePicker1.SelectedDate,
"[$-en-US]dd-mm-yyyy"
),
"en-GB"
)
Note: Only "/" could be recognized at this point, if this does not matter, please use the "/" rather than "-"
Best Regards,
Qi
