Hello,
As part of developing a back-office for an existing application, I need to manipulate CosmosDB documents in order to make modifications on them individualy.
Here is my code:
Set(Update; {Value: ParseJSON(JSON({Designation: {fr: DesignationInput.Text}}))});;
Set(ProductToSave; Patch(Product; Update));;
UpdateCosmosDB.Run(ProductToSave; "products");;
I am facing several technical difficulties with this.
Indeed, in order to use my data in PowerApps, I use ParseJSON which returns an object containing a Value attribute of type UntypedObject, on which I cannot modify the child attributes.
If I attempt a Patch, PowerApps directly replaces the entire content of Value with the Value of the second record.
I cannot set all the fields to my "FieldsToUpdate" object, as the resource I am trying to modify has more than sixty fields, arrays, maps ...
What solution could I use to resolve my saving issue?
One approach I tried, which was not successful, was to send "Product" and "Update" to Power Automate, but I am unable to perform a "merge" of the two JSON objects after analysis.
Thank you in advance for your responses.

Report
All responses (
Answers (