Hi! Building my first PowerApp and on one screen I show a list of store locations as items in a Gallery. Within the Gallery Item, I display the name of the location, and under that I have additional text labels that show information about that location, like number of upcoming events and number of recent customers. To achieve that, in each label, I am using a CountIf on a Filter of items in a different SharePoint list, matching by the related column. This data changes externally every minute or so, so I’ve added a timer to the screen to refresh the locations data source every 30 seconds.
It all works, but I don’t like using the refresh function there, and I’m pretty sure I could be doing the logic more efficiently overall, so I’m hoping to get some input. Oh yeah, my biggest complaint is that when the locations data source refreshes, the labels doing the related lookups all visibly flash and reset, which I want to avoid. I don’t think hiding them briefly is the answer either. Anyway, thank you!!!
