Unanswered

Patch Date from Datepicker WITHOUT Time

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (12)

Answers (0)

AsanKani 710 on at

Like (0)

Report

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.

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

Like (0)

Report

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.

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

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

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report
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

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

Like (0)

Report
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:

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

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.

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

Like (0)

Report

Which Dropdown option do I enter this into?

Was this reply helpful? Yes No
AsanKani 710 on at

Like (0)

Report

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

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (0)

Report

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

Was this reply helpful? Yes No