Applies to Product - Power Pages
What’s happening?
Changes made to SharePoint lists are not being reflected in the Power Pages forms that are connected to these lists.
Reason:
This arises from the use of a virtual table in Dataverse, which references external SharePoint data but does not allow direct updates. Additionally, the configuration of the tenant name field as a choice field instead of a lookup field limits dynamic updates.
Resolution:
- Clear the cache in the Power Platform admin center to ensure the latest changes are displayed.
- Verify that changes in the SharePoint list are saved and published. If the changes are not properly published, they will not sync to the Power Pages form.
- Create a new standard table in Dataverse (not virtual) to store the data locally.
- Replace the choice field with a lookup field pointing to the tenants table for proper relational data management.
- Manually replicate the existing structure from the virtual table to the new Dataverse table.
- Ensure all future updates are made within Dataverse to maintain data integrity across Power Pages.