Answered

Patch() not updating record but creates new one

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Community,

Cannot figure what am I doing wrong with my patch function because instead of updating existing sharepoint item it is creating new one.

SharePoint list:

OnSelect button:

Patch('Time Records',LookUp('Time Records', 'Active Session'= true , {'End time': Now(), 'Time Spent': DateDiff(varNewItem.'Start time',Now(),Minutes), 'Active Session': false}))

Result:

I know that Defaults() function it is used for creating new item but i am not using it and still the button is creating new item.

All I want is the button to update or 'insert' data in 'End Time' and 'Time Spent' columns and switch 'Active Session' (Yes/No column type) from true(check mark) to false(no check mark).

Any help would be really appreciate since i'm struggling with this issue for quite some time ...

Thank you in advance !

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

timl 37,160 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
@Anonymous

The call to LookUp here is incorrect.

If you want to update the first record in your SharePoint list where 'Active Session' is true, the syntax would look like this.

Patch('Time Records', LookUp('Time Records', 'Active Session'= true) , {'End time': Now(), 'Time Spent': DateDiff(varNewItem.'Start time',Now(),Minutes), 'Active Session': false} )

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

Like (0)

Report
Copy link

Link copied!

@timl many thanks for your fast reply !
Cannot belive that only some ( ) got me in all these trouble ... thank you so much, you saved me.
Now the function is working as intended but the only thing now is that it is not calculating any more the time spent between start time and end time. Could you also help me solve this please ?

Was this reply helpful? Yes No