Unanswered

Patch Date from Datepicker WITHOUT Time

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I've been working on this for hours and it's driving me bonkers. I have a simple Power App with some fields that I Patch to an Excel so I can run a Power Automate off of it. However, when it moves the date, it brings it over as a Date Time. Even more odd, when it was first running, it was date only. For the Power Automate to work, I only need the date in the field. Any suggestions? My code is below.

Patch(
Table1,
Defaults(Table1),
{'Assigned To': Name.SelectedText.Value},
{Date: RDate.SelectedDate},
{Region: RegionCode.Text},
{'Company Code': CompanyCode.Text},
{'Company Name': CompanyName.Text},
{Action: Action.Text});
Navigate(Screen1_1)

Categories:

Building Power Apps

All responses (12)

Answers (0)

Sort by

AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, @Anonymous First let me know where to you have use in Date filed in PowerAutomate?

That section to update your Date filed without time use formatedatetime function. See below
formatDateTime('<your-datevalue>', 'dd/MM/yyyy')

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 or you liked the post and want to show some appreciation, please give it a Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm a little confused where I enter formatDateTime('<your-datevalue>', 'dd/MM/yyyy')
Power Automate pulls the date from my Excel. I want to use the Patch function from the PowerApp to push the date to Excel, without the date / time.
AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

Power Automate.. let you share your Power Automate to use Date time from excel in Snap. I will told you.
AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous
Power Automate. let you share your Power Automate to use Date time from excel in Snap. I will told you.

Or my another suggestion. you can try
Your date picker format to change like this only for date value passed.
So, you above patch coding working fine with date value only not time value

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 or you liked the post and want to show some appreciation, please give it a Thumbs Up.
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

I assume you are storing the date in Excel in text format ?

Patch( Table1, Defaults(Table1), { 'Assigned To': Name.SelectedText.Value, Date: Text(RDate.SelectedDate,"dd/mm/yyyy"), Region: RegionCode.Text, 'Company Code': CompanyCode.Text, 'Company Name': CompanyName.Text, Action: Action.Text } ); Navigate(Screen1_1)

Excel is quite unfriendly as a data source with dates and you normally have to store them this way.

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.

Visit my blog Practical Power Apps
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
I have found that Excel is indeed quite unfriendly.
Date: Text(RDate.SelectedDate,"dd/mm/yyyy"),
The above doesn't work because it submits the data as text, not a date. The column is a date field so it won't accept it. The PowerApp is very lean / streamlined, so I don't want to use Power Automate with it.

For the date picker formate, I don't see that option is Power App.

The solution I've using now is I copy the data to a hidden column. I then set the visible column to = the hidden one. For whatever reason, this then strips the data of the time. :shrug:
AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous

you can try above my point / reply . I hope it will resolve your issue

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 or you liked the post and want to show some appreciation, please give it a Thumbs Up.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Which Dropdown option do I enter this into?
AsanKani 710 on at

Like
a
(0)

Report
Copy link

Link copied!

Your rdate datepicker format property to change.

If you appreciate my reply give thumbs up 👍
And your problem resolved make my reply as a solution
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

Your issue unfortunately Excel and Dates - I have tried to find some posts for you (this one describes the issue fairly well), however you really need to store the date as Text (there is a much more complex solution storing it as a date value number) for it to work reliably (hence my assumption earlier). The other alternative (which I highly recommend) is to use SharePoint instead of Excel and all of this will work as expected.

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.

Visit my blog Practical Power Apps