cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Srinath
Helper III
Helper III

Adding a new value to SharePoint 'Choice' Column through Power Apps

Hi All,

 

I have a SharePoint list in which i have a choice column which has 4 choices, say 'A', 'B', 'C', 'D'.

 

Now I want to know if there is a way through which I can directly add a new choice say 'E' to the SharePoint column from PowerApps.

 

The 'E' entry should be constant and should be available to all the users next time they open the app.

 

Any help will be greatly appreciated.

 

Regards

Sri

2 ACCEPTED SOLUTIONS

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

Hi @Srinath ,

 

You could set onstart property of your app to:

Set(Thevar,"E")

 

Add a button control and set its onselect property to:

Patch(LIST162,Defaults(LIST162),{Title:"TEST",TestChoiceA:{Value:Thevar}})

 

vxiaochenmsft_0-1630387340095.png

 

Best Regards,

Wearsky

 

View solution in original post

Hi @v-xiaochen-msft ,

 

I have achieved the desired outcome by creating a flow.

The solution you suggested will add a new choice as a new row, but i want to patch the text as a new choice which will be permanently available.

 

The below video really helped me;

https://www.youtube.com/watch?v=woG8njjyScM

 

Regards

Sri

View solution in original post

2 REPLIES 2
v-xiaochen-msft
Community Support
Community Support

Hi @Srinath ,

 

You could set onstart property of your app to:

Set(Thevar,"E")

 

Add a button control and set its onselect property to:

Patch(LIST162,Defaults(LIST162),{Title:"TEST",TestChoiceA:{Value:Thevar}})

 

vxiaochenmsft_0-1630387340095.png

 

Best Regards,

Wearsky

 

View solution in original post

Hi @v-xiaochen-msft ,

 

I have achieved the desired outcome by creating a flow.

The solution you suggested will add a new choice as a new row, but i want to patch the text as a new choice which will be permanently available.

 

The below video really helped me;

https://www.youtube.com/watch?v=woG8njjyScM

 

Regards

Sri

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,749)