web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Power apps don't see d...

Power Apps

Unanswered

Power apps don't see date in excel

(0) Share

Report

Report

Posted on by Alexey_bot

49

Hello everyone I faced with following problem

I connected FormViewer to my Gallery to be able to edit record. I added fields with date and text and noticed that power apps don't see my date in excel, it's written empty value. I tried to save data with selected date and i saw very strange date format. Please advice how can I to to make power apps able to see my dates in excel, and how to change updated date format to necessary one without time.

This is my table dates, DateC first row is what power apps updated with selected date, anoter format and i don't need time

This is how power apps see date that it's updated, value Date but time is also mentioned

This is how power apps see my date, empty value and format is Date and time

Please advice how to solve this problem

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Alexey_bot ,

I suggest you use ‘general’ instead of 'date' in Excel.

Patch(Table1_1,Defaults(Table1_1),{Col1:"Test2",DateC:Text(DatePicker1.SelectedDate,"dd-mmmm-yyyy")})

Best Regards,

Wearsky

Was this reply helpful? Yes No

Join the conversation