Answered

Patching an existing record

(0) Share

Report

Posted on by CodyO

391

Greetings fellow powerapps users!

I am attempting to patch an existing record and I can't figure out where I went wrong. The below code is on the "Submit" button.

What is working - Onpress of the edit button, pause the refresh timer, set edit button visibility to false and the save button visibility true. I have achieved this. On press of the save button start the timer, Set save button visibility to false and edit button visibility to true.

What isn't working - On save I also want it to patch updates to the existing records in a sharepoint list 'TimeTracker'.

Error received - Invalid argument type. Expecting one of the following: Boolean, Number, Decimal, Text, OptionSetValue, UntypedObject. (This error isn't showing any red lines on the code; however, it isn't working as expected.)

Set(SubmitBtn, false) && Set(EditBtn, true) &&
Patch(
 TimeTracker, 
 Gallery2.Selected, 
 {
 Title: 'txt.Title',
 CostCode: 'txt.CostCode',
 'Time In':'txt.ClockIn',
 SwitchJob:'txt.Switch',
 'Time Out':'txt.ClockOut'
 }
);
UpdateContext({startTimer:true})

Thanks in advance for any assistance!
-CodyO

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CodyO,

Try:

Set(SubmitBtn, false); Set(EditBtn, true); Patch( TimeTracker, Gallery2.Selected, { Title: 'txt.Title', CostCode: 'txt.CostCode', 'Time In':'txt.ClockIn', SwitchJob:'txt.Switch', 'Time Out':'txt.ClockOut' } ); UpdateContext({startTimer:true});

Please tick Accept as solution if the answer is useful.

Thanks,

@AARON_C

Was this reply helpful? Yes No
CodyO 391 on at

Like
a
(0)

Report
Copy link

Link copied!

@Hey @AARON_C

Oddly enough I am now getting the same error I am getting on another part of this app.

"The requested operation is invalid. Server Response: TimeTracker failed: Object must implement IConvertible.clientRequestIDL a730b8c8-6036-4293-8e21-f953bd669637 serviceRequestId:a730b8c8-6036-4293-8e21-f953bd669637"

Was this reply helpful? Yes No
AARON_C 2,235 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@CodyO

Please also fix your patch function:

Patch( TimeTracker, Gallery2.Selected, { // This needs to be the <-- 'Column name in data source': 'control name'.Text --> Title: 'txt.Title', CostCode: 'txt.CostCode', 'Time In':'txt.ClockIn', SwitchJob:'txt.Switch', 'Time Out':'txt.ClockOut' } );

Was this reply helpful? Yes No
Verified answer

CodyO 391 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @AARON_C , I think I figured out my issue - I am able to patch existing records with everything but the dropdown. I currently have my "choice" fields in sharepoint list set to be fillable, and the choices are being pulled from another list. I think this might be causing an error. My workaround was adding a delete button. If someone enters the wrong Job number, they can just delete the record and recreate it with the correct number. I am still looking for a long-term solution to the dropdown issues, but for now I can say it's working mostly as expected. Thank you again for your help!

Was this reply helpful? Yes No