Unanswered

patching CDS record in a variable doesn't work

(0) Share

Report

Posted on by dave-jorgensen

502

I have a record that I read from CDS which I put into a local variable. I can't seem to update that local variable. Creating just a simple record and patching that works fine, but for some reason when I get a record from CDS I can't patch it locally. I do NOT want to patch the record in CDS, I'm just trying to patch the local copy of the record. Any suggestions?

// this doesn't work, 'Program Code' is not updated
UpdateContext({Program: First(MAG_MDM_Programs) });
UpdateContext({Program: Patch(Program,{'Program Code': "Test Program Code"})});
// this works, count is updated
UpdateContext({record: { name: "Hello", count: 0 }});
UpdateContext({record:Patch(record, {count: record.count + 1})});

Categories:

Power Apps Pro Dev & ISV

All responses (3)

Answers (0)

Sort by

dave-jorgensen 502 on at

Like
a
(0)

Report
Copy link

Link copied!

and further information, choosing a different CDS entity, I can patch that locally fine. IE this works:
UpdateContext({Test: First(MAG_MDM_Traxes) });
UpdateContext({Test: Patch(Test,{cr6e6_adjustmentvaluescore: 567})});
dave-jorgensen 502 on at

Like
a
(0)

Report
Copy link

Link copied!

Wow. I think powerapps is a little buggy here. eventually figured out, that if I patch using the internal field name it works, but using the display name doesn't work.
IE this works:
UpdateContext({Test: First(MAG_MDM_Programs) });
UpdateContext({Test: Patch(Test,{cr6e6_programcode: "Test Program Code"})});

and this doesn't work:

UpdateContext({Test: First(MAG_MDM_Programs) });
UpdateContext({Test: Patch(Test,{'Program Code': "Test Program Code"})});

Is this a known bug with Patch?
dave-jorgensen 502 on at

Like
a
(0)

Report
Copy link

Link copied!

Even that actually isn't consistent, doesn't work all the time. So I guess that brings me around to the original problem, which is how to patch a local record that came from CDS