Patch a date from a label

[Station1901]

Hello,

I have a label in my powerapp which displays a date (Label26).  Is there a way i can use a patch function to get the date value out of that label and store it in a Sharepoint list in the 'LastDate' column?

The Patch function will be triggered with a Button if that makes any difference.

Thankyou in advance

[panand99]

you can use :

Patch(ListName,LookUp(ListName,ID=1),{MasterDate:DateValue(lableDate.Text)})

ID=1, is the document ID which u want to update

lableDate is the lable form which date is written like - 30/12/2018

[Station1901]

Thanks for getting back to me.

This the current statement I have

Patch(Cars,LookUp(Cars,Callsign=Value(Label27.Text),{LastRota:Value(Label26.Text)}))

 Cars = List name

Label27 holds the number of the vehicle of the record to update (ID).

Label26 holds the date I need to patch into the LastRota column

When the button is pressed it is just creating a new blank record in the Cars sharepoint list

Any ideas?

[panand99]

Youhave to close your lookup formula with parenthesis .

use this :

Patch(Cars,LookUp(Cars,Callsign=Value(Label27.Text)),{LastRota:Value(Label26.Text)})

[panand99]

please accept my earlier reply as a solution if it works else let me know if any issues.

[Station1901]

Hi,

I have tried this and now the Patch command doesn't apepar to be doing anything.  It has not updated the record I wanted and It hasn't created a blank record in my sharepoint list, i'm not sure what it has done.

[Station1901]

It is not showing any errors either

[panand99 · Accepted solution]

Did you use 'DateValue' instead of 'Value' when trying to update date?

[Station1901]

Ive been stuck with this for sooo long.  Thankyou so much works like a charm now