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

I have the same question (0)

All responses (3)

Answers (0)

dave-jorgensen 502 on at

Like (0)

Report

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})});

Was this reply helpful? Yes No
dave-jorgensen 502 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
dave-jorgensen 502 on at

Like (0)

Report

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

Was this reply helpful? Yes No