Why would you need to do a PowerApps Refresh SharePoint List function? One reason is to have the latest changes from our data source. There are times when we may make changes to our data sources. For example, we may want to add or remove fields. Perhaps we want to rename a column or two because there is a business need or it could be that we thought of a better name.
Whenever we make changes to our data source, it is not reflected back immediately in PowerApps. This is when a refresh of the data is needed. If we have made a change to our SharePoint data source then we can quickly perform a PowerApps Refresh SharePoint List task. First head over to the PowerApps menu and select the ‘View’ option. Then click on the Data sources button. You will then see your data sources listed. Click on the ellipsis next to the one you want to select. A small menu pops and all you need to do is to select the ‘Refresh’ option.
Once the data has been refreshed you will have the latest changes to hand and can carry on with your work.
It is not only data structure changes that benefit from a refresh. The data itself can be changed and you will want to have the latest data available that includes the changes.
This is again where you can use the Refresh function because it will go and retrieve a fresh copy of the data source. You’ll then be able to see changes that other users made.
In the OnVisible property of a screen enter the refresh command. It would look something like:
If you make any changes to your SharePoint list you will need to refresh the data source in PowerApps in order to use the latest changes.
The Refresh() function only updates data from the original lists in SharePoint. It does not refresh collections. To do that you will need to invoke the ClearCollect() function on the SharePoint list. It is not possible for PowerApps refresh data source functionality to work in the same way when using collections.
PowerApps Refresh SharePoint List and Update Data Table or Gallery
There may be times when you want to make use of the Data Table control. This offers a spreadsheet type of look as a grid to hold multiple values. At the time of writing this article, the Data Table control does not appear to pick up the latest data once a PowerApps Refresh SharePoint List has been done. Personally, I find this is a bit of a hindrance and tend to use the Gallery control to give me the same multiple record layout. The data table looks great when sitting on a screen, but attempting PowerApps refresh data table functionality right now would prove futile. I’m sure this problem will be addressed and fixed in the future though.
The same applies for the Gallery control. A refresh of the Gallery control can be done via the OnVisble property of the screen. If you are saving data using the Patch command, it may be a good idea to include a Refresh statement once the save has been done. That way the Gallery control will have the latest data in the data source.
Current SharePoint or SQL Data
It is important that we always have the latest data to work with. Also, we should be working with the latest data source structure. Data is important, not only for our organisations, but for the clients we are serving.
Also Check What is a PowerApps Collection