Fix Power Apps SharePoint Form Data Loading Issues
Question details
Users need to resolve an issue where a customized SharePoint Online Power Apps form fails to properly load a variable-based text input.

- Product
- Power Apps / SharePoint
- Device & OS
- not provided
- Scenario
- Opening a customized SharePoint Power Apps form where a specific text input relies on a variable for its default value.
- Observed behavior
- The text input data fails to load initially when the form is opened and only displays correctly after the application is reopened.
Ensure you have the appropriate edit permissions for the SharePoint list and access to the Power Apps Studio environment to modify the form's control properties.
Review Control Properties and Refresh Variables
Check the Default property of the control and ensure variables are properly reset when the selected item changes in the SharePointIntegration control.
This issue is often related to the Power Apps form lifecycle and how the SharePointIntegration behavior handles variables. If variables are not explicitly refreshed during the OnView or OnEdit actions, the form may hold onto empty or outdated states.
Navigate to your SharePoint list, click on 'Integrate', select 'Power Apps', and choose 'Customize forms' to open the app in Power Apps Studio.
Select the problematic variable-based text input control and check its 'Default' property in the formula bar.
Compare the control’s Default property with 'SharePointIntegration.Selected.PP.Value' to ensure it is referencing the correct data context.
Select the 'SharePointIntegration' control from the Tree view. Update its 'OnEdit' or 'OnView' properties to explicitly refresh or reset the variable when the selected item changes.
Save and publish your changes, then test the form directly in the Power Apps environment to verify that the text input loads on the first attempt.

Seek Assistance in the Power Apps Community
Since this involves complex form lifecycles and backend data syncing, the official Power Apps forum is an excellent resource for specialized help.
Looking for a Lightweight Office Solution? Try WPS Office
While specialized form-building tasks may require the Microsoft ecosystem like Power Apps and SharePoint, your everyday document, spreadsheet, and presentation tasks don't have to be complicated or expensive. WPS Office provides a free, lightweight, and highly compatible alternative for your daily productivity needs.

Frequently Asked Questions
Why does my Power Apps text input only load after reopening the app?
This usually happens due to issues with the form's lifecycle and variable initialization. If a variable isn't properly reset or refreshed when a new SharePoint item is selected, the form may hold onto an empty state until a complete app reload forces it to fetch the new data.
How do I check the SharePointIntegration control properties?
In Power Apps Studio, select the 'SharePointIntegration' object from the Tree view on the left-hand side. You can then access its properties, such as OnNew, OnEdit, and OnView, from the advanced properties dropdown or the right-hand properties pane.
Can I use WPS Office to create SharePoint custom list forms?
WPS Office is a powerful suite for processing documents, spreadsheets, and presentations. However, for creating customized SharePoint list forms directly tied to Microsoft 365 data structures, you need to use Microsoft Power Apps as it is a proprietary integration.




