Answered

Trying to patch an excel table and have date formatting issue

(0) Share

Report

Posted on by MikeNPD

When I patch to an excel worksheet, while testing during development all was fine. As soon as I published the app the patch function is brining dates in the following format in excel:

2021-06-22T20:57:07.240Z

My code is this:

Patch(
TimeSheetData,
LookUp(
TimeSheetData,
NEWID exactin NewIDVal
),
{Stop: Now()}
)
);

Any thoughts on how to correct this issue? It seems that it works sometimes, and then doesnt others.

Thanks,

Mike

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MikeNPD ,

Dates , Power Apps and Excel . . . not the best combination. What you are seeing is UTC format. Try patching

Text(Now(),"dd/mm/yyyy")

or whatever your data format is.

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
MikeNPD 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks, when I try that I see the following:

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,382 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@MikeNPD ,

You need to change the format of your Excel to Text - here is a post with a solution.

I am not an Excel user for many reasons - you might have a look at the video below

and dates (as I started my post) are problematic.

You might consider going to SharePoint - most of these issues will go away.

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
MikeNPD 22 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for this, I did something similar by adding 2 new columns and formatting them as text, then pointing the patch function at those columns. Seems like power apps was trying to force that formatting in. This is working for now. Thanks for the help.

Was this reply helpful? Yes No