Announcements
All,
I'm new to creating power apps and I trying to create one for the business to submit help requests, then the IT team will use the created SharePoint list to manage. My question is where is the best place to manage the fields that are choices, trying to future proof for changes that will inevitably happen - is it in SharePoint and if they are updated will this auto filter to the Power App or am I best creating them as collections in PowerApps?
Thanks
@SH0lm3s
I would strongly recommend doing them in PowerApps rather than using a Choice type field. When developing in SharePoint, I use single line of text, numbers and date/time type columns. The rest can be done in PowerApps.
Respectfully, I have to disagree with @Drrickryp . If the team is going to access the items created and manage them in the SharePoint list directly you should use the SharePoint Choice field. It can make things a bit more difficult in Power Apps. But not doing that will leave you open to data corruption when someone changes the text field in SharePoint and misspells something.
@Pstork1
You are correct of course, but I hate to give users access to the back end of a database for the reasons you state above. If a user has only access to the front end, the choices offered to them can be limited. My experience with end users is something like the picture below.
When using SharePoint as a data source you really have no option other than giving users access to the backend. You can try to hide it, but you can't deny them permissions or Power Apps won't work. The key in your meme is that too many developers think "intuitive" means the user's don't need to be trained. That is the problem in my experience. In addition the original post stated that IT would be using the SharePoint list to manage the tickets. So keeping everything in Power apps was a non-starter.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 493 Most Valuable Professional
11manish 479
Haque 328
