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 / Update SharePoint list...
Power Apps
Unanswered

Update SharePoint list choice column (dropdown) with a button click

(0) ShareShare
ReportReport
Posted on by Microsoft Employee
Hello all. I have list customised powerapps form with three buttons. Reject, Approve and hold. On click of the button I want to update a choice column dropdown (status)with same value. I'm able to achieve this using flow, is there a way to get this done by powerapps formula?
Categories:
  • v-sheyu-msft Profile Picture
    Microsoft Employee on at

    Hi @Harikrishnan,

    Can you share a bit more about your issue ?

    Do you mean that the choice column has three options : “reject”, ”approve” , “hold” ?

    Do you want to update the corresponding options according the selected button ?

     

    I made a test. And it worked

    11.PNG

     

    Set the DefaultSelectItems property of combo box to:

    Var1 

    Set the Onselect property of reject button to :

    Set(var1,Filter(Choices(test.status),Value="Reject"))

    Set the Onselect property of approve button to:

    Set(var1,Filter(Choices(test.status),Value="Approve"))

    Set the Onselect property of hold button to :

    Set(var1,Filter(Choices(test.status),Value="Hold"))

    Regards,

    Eason

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi Eason, 

    Thank you for your reply.

    I'm able to change the dropdown value using the above solution. But I have to do a submit right after the set. Like this

     

    Set(var1,Filter(Choices(Intake1.Status),Value="Hold"));SubmitForm(SharePointForm1)

    I can see that value is getting changed in the UI and submit is happening.

     

    But if check the list after submit 'Status' column will be empty.

     

  • amalinabaha Profile Picture
    38 on at

    what is (test.status)?

  • amalinabaha Profile Picture
    38 on at

    what is test.status?

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

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 224 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 189 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 126

Last 30 days Overall leaderboard