Answered

Wrong date format when submitting Power App entry to SHP list

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have an issue with a flow, when I am sending the data, which is entried in a Power App, to a SharePoint Library. The date entry gets formatted in the wrong way and switches the day and the month.

This is the entry in the Power App, which is the 8th of June.

However, the following screenshot shows the date which gets posted in the library thereafter, which is the 6th of August.

As shown in the flow output below, the created date is still holding the correct date but the file date gets somehow converted and switches day and month.

I am assuming this is an issue with date and time formatting in Power Apps, Flow or Sharepoint but I haven't figured out exactly where the problem is. Could you please help me out with that matter?

Thanks a lot in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Is the date of files in the sp library or the date of items in the sp list wrong?

Could you provide some formulas or screenshots of the flow?

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,

the date is wrong in the SHP library.

I am converting the date from power app to a string and store it in a variable. Here the date is still correct (8th of June, which is equal to the entry in power apps)

However, in the library it stores the 6th of August (06.08.2021 instead of 08.06.2021 > month and date get switched).

This is what happens next

Here, when I update the properties of the created file, this is what happens in the code: the "created date" is still correct, but the "File Date" (the column in the library) changes month and date.

Does this help?

Regards

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

The value you enter is a string, and flow automatically converted it to a date value and reverse the date and month.

So ,please use formatDateTime function:

formatDateTime(variables('Thevar'),'dd-MM-yyyy')

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @v-xiaochen-msft ,

thanks, this helped! However, when the day is after the 12th of a month, I get an error message again (possibly, since it would primarly assume, that the day is the month and there exists only months from 1 to 12). This is the error message that gets displayed:

Template language expressions in the entries of the action "FileProperties_Update" in row "1" and column "13965" cannot be processed: An invalid value was specified for the date/time string "13.06.2021" in the function "formatDateTime". The datetime string must comply with the ISO 8601 format....

Thanks a lot for your help!

Best regards

Was this reply helpful? Yes No
Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I did a test for you.

split(variables('Thevar'),'.')

variables('Thevar2')[1].variables('Thevar2')[0].variables('Thevar2')[2]

formatDateTime(outputs('Compose'),'MM-dd-yyyy')

Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.

Was this reply helpful? Yes No