Table and Form Screen - Use OnSelect button to edit the value of a SharePoint drop down field

(0) Share

Report

Posted on by KW-04121632-0

I have an app with a Table and Form screen connected to a SharePoint List.

Each record will have a Status value that could be one of various choices in a drop down.

I want to have a button called "Approve Final Draft" which will set that status to "Approved"

How do I set the selected record to "Approve" using a button without setting all the records to "Approve"?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Kalathiya 1,069 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @KW-04121632-0,

If your table is a Gallery, Power Apps already knows which item is selected.

Option 1: Button inside the Gallery (simplest)

If the Approve Final Draft button is inside the gallery, set the button’s OnSelect to:
Patch( 'Your SharePoint List', // 'Your SharePoint List' - Replace with your SharePoint List ThisItem, { Status: "Approved" } //Status - Replace with your column name )

This only updates that row.

Option 2: Button outside the Gallery

If the button is outside the gallery, use the selected item:

Patch( 'Your SharePoint List', //'Your SharePoint List' - Replace with your SharePoint List. {ID:Gallery1.Selected.ID},//Gallery1 - Replace with your Gallery Control Name. { Status: "Approved" } //Status - Replace with your SharePoint List Column. )

Replace Gallery1 with your gallery name.

Hope that helps.

If you’re still stuck, please share your current setup (gallery/form, where the button sits, and how Status is configured). That’ll make it easier to give an exact formula for your case.

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

---------------------------------------------------------------------------------

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No
KW-04121632-0 6 on at

Like (0)

Report
Copy link

Link copied!
Hi @Kalathiya

I tried the formulas above, but they didn't quite work. I made some modifications and think I'm close?

Patch('KW Test List',CurrentItem, {Status: "Approved"}) I also tried: Patch('KW Test List',{ID:Table1.Selected.ID},{Status:"Approved"})

But I get this error:

"The type of this argument 'Status' does not match the expected type 'Record'. Found type 'Text'."

The set up is basically the default set up if you select New Screen > Table and form

The records sit in the table but will also show in Form Container when selected. I have a container below the form container with my button in it.

Was this reply helpful? Yes No
Verified answer

Kalathiya 1,069 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hello @KW-04121632-0,

I got it. Status column type is choice that's why it's giving this error:

Please try below code:

Patch('KW Test List',CurrentItem, {Status:{Value: "Approved"}}) I also tried: Patch('KW Test List',{ID:Table1.Selected.ID},{Status:{Value:"Approved"}})

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

Was this reply helpful? Yes No