web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to patch/update in...
Power Apps
Suggested Answer

How to patch/update into a JSON Sharepoint List Column

(0) ShareShare
ReportReport
Posted on by 2
Famous first words: I dont know if this is the correct forum. But it's a tough question.
 
 
How does the Patch expression look like in this scenario? I even tried to do this with a nested gallery, but it didnt work out
I'm really happy for every help and information :)
I only get an the specified column doesnt exist error.
My goal is here to patch into the correct passage of the JSON which is in a SP-List Column
 

This is the patch expression, i'm trying to use for my TextInputCanvas1:

Patch(

    varPredictResultsCol,

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

    {

        prediction: [{

            result: TexInputCanvas1.Text, 

        }]

    }

)



This is my variable:
 

Set(

    varPredictResultsCol,

    Table(

        ParseJSON(

            Text(

                LookUp(

                    DocExtract_Answers,

                    documentID = varDocID // this works

                ).result_prediction_JSON

            )

        )

    )

)

Then i iterate through the Table

ForAll(

    varPredictResultsCol,

    {

        key: Text(Value.key),

        prediction: ForAll(

            Table(Value.prediction),

            {

                result: Text(Value.result),

                confidence: Value(Value.confidence)

            }

        )

    }

)

 

Categories:
I have the same question (0)
  • Suggested answer
    mmbr1606 Profile Picture
    14,605 Super User 2026 Season 1 on at
    hey
     
     
     
    cn u  try this:
    Patch(
        varPredictResultsCol,
        LookUp(
            varPredictResultsCol,
            Text(Value.key) = ThisItem.key
        ),
        {
            prediction: Table(
                {
                    result: TextInputCanvas1.Text
                }
            )
        }
    )
    
    if it helped please mark as verified answer
     
    cheers
  • JD-21010831-0 Profile Picture
    2 on at
    thanks for your help @mmbr1606
    unfortunately not, its still the same error

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 93 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
Valantis Profile Picture

Valantis 49

Last 30 days Overall leaderboard