Pretty sure this is impossible, but I'd love for someone to prove me wrong, since I've looked everywhere and tried everything at this point,
I'm having the following issue:
I have an Untyped Object type data inside a table, I can take it out easily via the dot notation, however, now I want to edit this Untyped Object and then patch it back into the table, now I'm fairly certain this isn't possible without some extremely dirty work-arounds, the one I'm working on and what this title is based on is this:
The Untyped Object has several properties, I only care about one and I can easily convert it using the following formula to text:
{ field: Text( ParseJSON( "{ ""field"": ""value"" }" ).field ) }
This works fine and allows me to edit the property, but I need to convert the other required properties and combine them to make one whole Untyped Object using an additional ParseJSON to patch into the table I've mentioned above, however, one of them is a variable (it changes for a selected item in a dropdown list) and the above expression does not seem to work with variables! so I am stuck.
Any ideas or is this a lost cause until Microsoft updates this data-type?

Report
All responses (
Answers (