cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PhilD Kudo Kingpin
Kudo Kingpin

Recommendations for auto refresh every minute

I have a functioning, but not yet deployed, app that involves dispatching cases to a group of around 30 users. The app uses SharePoint lists as the datasource and has tables like Tasks, Task Events, Employees, Locations, etc. This all works pretty well so far in my prototype. The dispatcher can marry employees to tasks and employee's status is updated throughout the process. All the activity can be viewed/managed by the dispatcher from a screen with multiple galleries filtered to show employees and tasks in various status. The employees will use iPhone devices with a simple screen showing tasks assigned to them.

 

I have the main data source (tasks) sorted first, then filtered so the sort is delegated to SharePoint and only the X most recent records are returned each time.

 

In order to keep the data presented fresh, I have used a timer to refresh the relevant data sources (tasks, employees) every minute. My question is, will this present problems with around 30 users having the app open 24/7?  Would there be a benefit to collecting the main data source every minute vs. refreshing it? Is there a theoretical limit to the number of requests that can occur in a period of time after which this will simply stop working?

 

Any and all advice is much appreciated, thanks !

6 REPLIES 6
Jdemke
Frequent Visitor

Re: Recommendations for auto refresh every minute

Would having a button on the screen for the user to manually refresh the data not work?

PhilD Kudo Kingpin
Kudo Kingpin

Re: Recommendations for auto refresh every minute

This would not work because they would have to refresh after every transaction. There are a lot of changes to the status of each task which also changes the status of the employee. Any of these changes could be made by any of the 30 or so people using the app.
Highlighted
Jdemke
Frequent Visitor

Re: Recommendations for auto refresh every minute

You could have it refresh after they complete the transaction and have a manual refresh button. Have a constant update would probably slow the app down, I don't know for sure because I haven't done something like that on that scale.

PhilD Kudo Kingpin
Kudo Kingpin

Re: Recommendations for auto refresh every minute

I was thinking about that but  if an employee in the field produced a transaction which also refreshed the datasource, the dispatcher wouldn't see the results of the refresh on their end until their instance of the app refreshed.

PhilD Kudo Kingpin
Kudo Kingpin

Re: Recommendations for auto refresh every minute

I was more worried about possiblyl running up against some sort of limit to the number of data requests then slowing down the app but of course that would be a concern as well.

PhilD Kudo Kingpin
Kudo Kingpin

Re: Recommendations for auto refresh every minute

Quote from blog post Performance Considerations with PowerApps

 

"When deploying your app to a large number of user, one has to keep in mind the connectors are throttled. PowerApps currently support 600 requests per minute per user and up to 30 concurrent calls per user."

 

I think I need some help understanding how that statement relates to refreshing a SharePoint list on a timer. Is each refresh of the list counted as a request? If a SharePoint list that is refreshed has lookup type columns, do these affect the number of requests counted to when refreshing the list? I'm not really clear on a straightforward way to measure this to determine where I stand.

 

Any help understanding how to accommodating this throttling is appreciated, thank you!

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,449)