cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SkiDK
Solution Sage
Solution Sage

Sharepoint not in sync with app?

I have a powerapp with a datatable made from a sharepoint list. I have two options:

 

Directly from datasource:

Items: 'SP_List'

Or with collection (and to update I just do a clearcollect again on a button click):

OnStart: ClearCollect(col_List, 'SP_List')
Items: col_List

Now I have noticed that neither way are in sync with the Sharepoint list when an item is added in Sharepoint itself. For example, if I add a file to a library list in sharepoint, neither the datasource or the clearcollected collection will detect this difference. Staying exaclty the same. However, when I close and reopen the application, then all the changes are shown correct in the datatable.

 

Writing a property of an existing item does update when I clearcollect. It just does not show the new items.

 

Is this normal?

 

Many thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

The data source isn't a live connection to the SharePoint list (or any other data source).  It is a connection that requests a set of records when you load the app or do different actions like editing and resubmitting a record.  If you add a button with 

Refresh(datasourcename)

it will refresh the records displayed when you press the button.  That is the way its designed to work.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

4 REPLIES 4
Pranav_Shroti
Kudo Collector
Kudo Collector

Hi, I have observed in edit mode sharepoint record changes may not get reflected immediately, however when you are actually running the app, by Playing it in a different instance of browser, then you will always gets updated results. The catch is you will have to refresh the page/grid on powerapps.

 

Hopo this helps,

Pranav

Hi @Pranav_Shroti 

 

Thanks for your reply, but unfortunately it does not change anything for me.

 

I have to reload the application to 'refresh' the datatable.

 

I have no idea why it does not sync. Is this by design?

Pstork1
Dual Super User III
Dual Super User III

The data source isn't a live connection to the SharePoint list (or any other data source).  It is a connection that requests a set of records when you load the app or do different actions like editing and resubmitting a record.  If you add a button with 

Refresh(datasourcename)

it will refresh the records displayed when you press the button.  That is the way its designed to work.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Great, that was all there was to it. Thanks!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,960)