Afternoon All,
Myself and a colleague have built an Engineering system in PowerApps which currently is working quite well, we'd like to try and streamline things a little for quicker loading times etc on future builds, my question seems simple in my head but I'm not sure if there is a better way of achieving it.
Each screen in the app has a set of menu icons across the top showing the amount of requests for that section (4 in total), for example we have how many Unplanned requests we have in the pool (on the pictures below thats 22), currently each screen looks at the same gallery on the UPM screen (scrAllUPM) for the 22, so on loading from what I've read each screen that has this menu will load in full as its an item pointing at another screen. This isn't going to help load time, which at this point isn't the fastest but it's definitely useable.
Here is a few of the screens to show you what I mean, so the label on the home screen menu for UPM (22) looks at the UPM screen (scrAllUPM) gallery which already has this filter done to get the correct figures. (Blurred text for GDPR etc)
It's possible I'm way over thinking this but I see a few options
To me, option 2 seems the most logical but I'm unsure if I'm missing something obvious. All I need is a good way to count rows in a filter from a SharePoint List and display the number on 10-15 screens (4 needed in total - UPM, Requests, Jobs and TAGS) whilst keeping API calls down to a minimum.
Any thoughts or ideas welcome
Cheers
Solved! Go to Solution.
So I've gone with setting a global variable for each Count Row number which refreshes every 10 minutes if the app is signed into, it seems to be functional plus the app has sped up a little bit which is nice.
Cheers
So I've gone with setting a global variable for each Count Row number which refreshes every 10 minutes if the app is signed into, it seems to be functional plus the app has sped up a little bit which is nice.
Cheers
User | Count |
---|---|
160 | |
95 | |
76 | |
72 | |
58 |
User | Count |
---|---|
213 | |
165 | |
97 | |
95 | |
75 |