web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Form cards changing da...

Power Apps

Answered

Form cards changing date format to datetime

(0) Share

Report

Report

Posted on by chahineatallah

31

Hello

I have an app that is connected to excel file, in excel file i have date field with only dates

When form is connected to excel, the date field also gets time with it , as in the below photo, how to fix this?

Also why my date is shown in american format mm/dd/yyyy, my system is dd/mm/yyyy, how to change that also?

Thanks for the replies power app.JPG

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @chahineatallah ,

When form is connected to excel, the date field also gets time with it , as in the below photo, how to fix this?

Delete the drop down controls

Set the data card's Update property to:

DatepickerName.SelectedDate

Also why my date is shown in american format mm/dd/yyyy, my system is dd/mm/yyyy, how to change that also?

You could set the datepicker's Format property to:

"dd/mm/yyyy"

Best Regards,

Bof
chahineatallah 31 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, great!
It worked, learned something new 🙂

Join the conversation