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

Notifications

Announcements

Community site session details

Community site session details

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

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,567 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 759 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 310 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 228

Last 30 days Overall leaderboard