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})});
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})});
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?
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
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
1 |