Power Platform Community Forum Thread Details

Famous first words: I dont know if this is the correct forum. But its a tough question :)

I even tried doing this with a nested gallery.

With this patch expression I get the error message, that specified (in this case - "prediction") column doesnt exist.

I want to patch the input back to original datasource, namely Doc_Answers in result_prediction_JSON column at the correct passage ("result")

What am I missing?

First I set this table variable:

Set(

    varPredictResultsCol,

    Table(

        ParseJSON(

            Text(

                LookUp(

                    Doc_Answers,

                    documentID = varDocID // this works

                ).result_prediction_JSON

            )

        )

    )

)

Then my gallery items property is set to this:

ForAll(

    varPredictResultsCol,

    {

        key: Text(Value.key),

prediction: ForAll( 
Table(Value.prediction),  { 
result: Text(Value.result), 
confidence: Value(Value.confidence) 
} 
) 
}
)

After that i want to patch via user TextInput:

Patch(

    varPredictResultsCol,

    LookUp(varPredictResultsCol, invisible_key_text.Text = ThisItem.key),

    {

        prediction: [{

            result: TexInputCanvas1.Text,

            confidence: ThisItem.prediction[0].confidence

        }]

    }

)

The JSON schema goes as follows:

{

    "type": "array",

    "properties": {

        "key": {

            "type": "string"

        },

        "prediction": {

            "type": "array",

            "items": {

                "type": "object",

                "properties": {

                    "result": {

                        "type": [

                            "string",

                            "null"

                        ]

                    },

                    "confidence": {

                        "type": [

                            "number",

                            "null"

                        ]

                    }

                }

            }

        }

    }

}