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 / Changing Column Value ...
Power Apps
Unanswered

Changing Column Value With Button

(0) ShareShare
ReportReport
Posted on by 232

Hello, I have two buttons that I would like to make change the value of a column in my datatable. The choice of this column are "Submitted", "Approved", and "Rejected".  I would like to be able to press these buttons to either reject or approve the submission. Here is a screenshot below:Screen Shot 2022-06-23 at 10.25.17 AM.png

Categories:
I have the same question (0)
  • VeGETzX Profile Picture
    367 on at

    Try

    Patch('Employees Activity List', DataTable.Selected, {Status: {Value: "Approved"}})

     

    Make sure that you replace DataTable with the name of your DataTable.

  • Dknight7 Profile Picture
    232 on at

    It gave me this error (And thank you so much with your help on my two posts):Screen Shot 2022-06-23 at 10.37.05 AM.png

  • VeGETzX Profile Picture
    367 on at

    I've made some misspelling, Replace Employees with Employee from the code.

  • Dknight7 Profile Picture
    232 on at

    Im still getting the same error:Screen Shot 2022-06-23 at 10.46.29 AM.png

  • VeGETzX Profile Picture
    367 on at

    Try change Status to match with the name of Choice column in your SharePoint list.

  • Dknight7 Profile Picture
    232 on at

    Its still not taking it:Screen Shot 2022-06-23 at 10.56.23 AM.png

  • WarrenBelz Profile Picture
    156,110 Most Valuable Professional on at

    @Dknight7 ,

    What is your data source ? If SharePoint and the actual name of your Choice (not Lookup) column in SharePoint is Status_Column1_1 (which I find unusual), you can do this

    Patch(
     'Employee Activity List', 
     {
     ID: DataTable1_1.Selected.ID, 
     Status_Column1_1: {Value: "Approved"}
     }
    )

     

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 326 Most Valuable Professional

#2
11manish Profile Picture

11manish 168

#3
sannavajjala87 Profile Picture

sannavajjala87 75 Super User 2026 Season 1

Last 30 days Overall leaderboard