Unanswered

Confused by PowerApp requirement for Patching a Date into a SharePoint List

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a very simple SharePoint List that consists of five columns:

In PowerApps, in order to allow the user to update the Time_Out column in SharePoint, I have used the Patch function to change the record. The patch function is created in a button under the ONSELECT property as follows:

ViewForm(Form1);Navigate(DashboardScreen);Patch(E_Visitor_log2,Time_Out, {Time_Out: Now()})

However, I keep receiving an error stating it is the wrong data type:

Can anyone explain what am I misinterpreting to satisfy this simple patch function?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

SebS 4,822 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

In this patch, the first Time out, how did you create this, or what does it contain? It should be the ID of a record that You try to update. Does it store the ID?

Patch(E_Visitor_log2, Time_Out, //<----- What is this and what data it contains { Time_Out: Now() } )

Was this reply helpful? Yes No
jadhav_ravi_oo7 276 on at

Like (0)

Report
Copy link

Link copied!

Patch(E_Visitor_log2,Time_Out, {Time_Out: Now()});ViewForm(Form1);Navigate(DashboardScreen)

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

Like (0)

Report
Copy link

Link copied!

How did I create "Time_Out"? I created it in a Form template which captured the format from the appropriate SharePoint List as shown below:
Are you suggesting that the second parameter of my patch function should be "Time_Out_DataCard1" or "Time_Out.Selected"?

Was this reply helpful? Yes No
SebS 4,822 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Yes it should pass the record ID right now the patch do not know where to patch it or what you try to do in my opinion.

Best approach is add it to Update property of the DataCard TimeOut and replace TimeOut with ThisItem but every time someone create new record or update this record you get the Time Out update

Was this reply helpful? Yes No