web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to set format date...

Power Apps

Unanswered

How to set format date after save data in sharepoint?

(0) Share

Report

Report

Posted on by Community Power Pla...

I set format in power app as below.

But data write in file excel = 2021-08-19T17:00:00.000Z

I want to write format date = dd/mm/yyyy

Please guide me about it.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Change the column format in Excel from General to Short Date.

Was this reply helpful? Yes No
PriyankaGeethik 3,320 Super User 2024 Season 1 on at

Like (0)

Report
Hi @Anonymous,

If the date getting saved is right than I guess you need to change format of Excel file column into required format.
If you observe one day difference between the date submitted from PowerApps to Datebase than it is due to Timezone difference. Please try the below formula for the Timezone saving if it helps.

DateAdd(datepickercontrolName.SelectedDate,TimezoneOffset(),Minutes)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report
One thing to add to @PriyankaGeethik response. If you are going to use TimezoneOffset() to adjust for the time zone then you really need to pass the date being converted as an argument of the TimezoneOffset. Otherwise it won't allow correctly for daylight savings time. The formula should be.

DateAdd(datepickercontrolName.SelectedDate,TimezoneOffset(datepickercontrolName.SelectedDate),Minutes)

Was this reply helpful? Yes No

Join the conversation