Answered

Patch Issue

(0) Share

Report

Posted on by Kiwi22

Hi Guys

Hope you can assist? I've got a vehicle check app that allows users to update things like Registration expiry and Service due information. This works only if I'm updating one field at a time. If I try to change more than one of these fields, it defaults back to the previous values. The formula I'm using is:

Patch(ListVeh2,ThisItem, {'Wof Expiry':DPCChangeWOFDATE.SelectedDate,'Registration Expiry':DPCChangeRegistrationDATE.SelectedDate,'COF Expiry':DPCChangeCOFDATE.SelectedDate,'Service Due kms':Value(UpdateServicekms.Text)})

Any help would be appreciated. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

Pstork1 69,581 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Your code is correct. The problem is that you aren't setting the defaults on the DatePickers using the default values in the item being edited. So when you Patch its picking up the date field that you changed, but all the rest are being set back to the defaults in the datepickers. Make sure the DatePicker for each field defaults to the value in the field when you edit the record. Then whichever field you change that field will be saved when you Patch and the other fields will overwrite the existing values with the values that are already saved. Make sure you do the same for UpdateServicekms too.

Was this reply helpful? Yes No
Kiwi22 35 on at

Like
a
(0)

Report
Copy link

Link copied!

That makes sense, thank you very much. Would something like CurrentDate() work in the default value?

Was this reply helpful? Yes No
Pstork1 69,581 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

yes you can set the default to the currentDate, but if you do that all the fields that you don't edit will get set to the current date. I thought that was what you were trying to avoid.

Was this reply helpful? Yes No
Kiwi22 35 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry, you're right. I didn't phrase my question correctly. I've changed the default to ThisItem."Field I want to show if it's empty". I've done some testing and this seems to have worked, thank you very much for the help.

Was this reply helpful? Yes No