News and Announcements icon

Power Platform CommunityForums Power Apps - Building Power Apps Date Picker to Excel F...

Power Apps - Building Power Apps

Answered

Date Picker to Excel Format

Like (0) Share

Report

Report

Posted on 13 Dec 2021 16:21:28 by naddie627

8

Hello!

I am looking to patch the date from the Date Picker, but the format sent to Excel is not my preferred view. Ideally it would read mm.dd.yyy

Any guidance would be greatly appriciated!

Categories:

General Questions

Connecting to Data

Capture.PNG

Capture1.PNG

Capture3.PNG

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-qiaqi@microsoft.com on 16 Dec 2021 at 03:26:47

Like (1)

Report

Re: Date Picker to Excel Format

Hi @naddie627,

From the error message saying that your Date_Time column expects DateTime value, so please check the column setting in your Excel table.

Select the whole Date_Time column and format it as a general column.
naddie627 8 on 15 Dec 2021 at 15:04:40

Like (0)

Report

Re: Date Picker to Excel Format

Hello Qi,
Thank you for the response! The column type I am using is set to General. I tried using the formula you provided, but I am still receiving an error. Any suggestions?
v-qiaqi@microsoft.com on 14 Dec 2021 at 06:38:59

Like (1)

Report
Re: Date Picker to Excel Format

Hi @naddie627,

Do you want to patch a selected date to excel as "mm.dd.yyy"?

Could you please tell me that which column type you save the date in excel?

I would always suggest a GENERAL column in the excel table to save the selected date from Power Apps.

If the GENERAL column does not affect your data set, please make sure you have a GENERAL column to save the date and modify your formula as below:

Patch(Table_1,Defaults(Table_1),{Date_Time:Text(DatePicker1_1.SelectedDate,"mm.dd.yyy")})