How to Add SharePoint Choice Values to a Power Apps Canvas App
Question details
The user wants to ensure that a new fill-in value added to a SharePoint Choice column through Power Automate appears immediately in a custom Power Apps canvas app.
- Product
- Microsoft Power Apps & SharePoint
- Device & OS
- not provided
- Scenario
- Creating or updating list records using custom SharePoint apps and Power Automate workflows.
- Observed behavior
- New choice values added via Power Automate do not appear immediately in the Power Apps canvas app due to workflow execution and data-refresh delays.
Ensure your Power Automate workflow has successfully completed its run before checking the canvas app for new choice values.
Refresh the SharePoint Data Source in Power Apps
Manually triggering a data source refresh forces the canvas app to retrieve the latest choice values and schema from SharePoint.
Because custom canvas apps rely on cached schemas and asynchronous data calls, new fill-in values injected via external workflows (like Power Automate) won't show up until the app is explicitly told to fetch fresh data.
Launch Power Apps Studio and open the custom canvas app where the missing choice values should appear.
Navigate to the Data pane on the left sidebar to view your connected sources.
Locate your SharePoint data source connection, click the ellipsis (...) next to the data source name, and select 'Refresh'.
If you are implementing this for end-users, add the `Refresh([SharePointListName])` function to the OnSelect property of a button or immediately following the workflow execution step.
Account for Execution Phase Delays
Understand and manage the timing between canvas app execution phases and backend data calls to prevent missing values.
Looking for a Lightweight Document Solution? Try WPS Office
While Power Apps and SharePoint are highly specific Microsoft ecosystem tools for enterprise apps, managing everyday office documents shouldn't require complex setups. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office for all your word processing, spreadsheet, and presentation needs.
- 1. Download the installer: Visit the official WPS Office website to download the free installation file.
- 2. Install the software: Run the downloaded file and follow the simple on-screen instructions to install WPS Office.
- 3. Start creating documents: Open WPS Office to instantly create, view, or edit your Word, Excel, and PowerPoint files seamlessly.
Frequently Asked Questions
Why does the default SharePoint form show the new choice value immediately, but my custom canvas app doesn't?
The default SharePoint form is directly integrated with the list and updates synchronously. In contrast, a custom Power Apps canvas app relies on asynchronous data calls and a cached schema. It requires a manual or scripted data refresh to pull the latest structural changes and new choices.
How can I automatically refresh the SharePoint choice values in Power Apps?
You can use the `Refresh([YourDataSourceName])` function within your canvas app. For best results, trigger this function immediately after your Power Automate flow returns a success signal indicating the new choice value has been written to SharePoint.
Where can I find advanced support for Power Apps integration issues?
For complex scenarios involving canvas app execution phases, backend data flow delays, and custom SharePoint integration, it is highly recommended to consult the official Microsoft Power Apps documentation or post your question in the Microsoft Power Apps Community forums where specialized experts can assist.
