Patch a date from a label

(0) Share

Report

Posted on by Station1901

209

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

panand99 641 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
panand99 641 on at

Like (0)

Report
Copy link

Link copied!

Youhave to close your lookup formula with parenthesis .

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

Was this reply helpful? Yes No
panand99 641 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report
Copy link

Link copied!

It is not showing any errors either

Was this reply helpful? Yes No
Verified answer

panand99 641 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Station1901 209 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No