Search code examples
azure-logic-apps

Update table entity with a variable not explicit JSON


I compose a string of the properties I want to update on a table storage entity in the jsonString variable. The value of jsonString is like "prop001": "false","prop002": "false". Where there are a variable number of properties.

I was hoping to use it like the image below illustrates but it does not allow this as a validator insists on valid JSON.

enter image description here

Is there aniother way to achivee what I am trying to do?


Solution

  • Try the following workaround:

    1. Initialize / set a String variable using the input that currently doesn't work for you (because it isn't recognized as JSON)
    2. In the Entity field of your action insert the following expression: json(variables('name_of_your_variable'))

    The field value in the code will look like this: enter image description here

    Hopefully, that helps.