New to PowerApps and Microsoft Flow so any help here could be appreciated.
I have List A which contains all sales including Employee Name and Income per sale. I want to create a "leaderboard" of sorts using this information via Flow that goes to List B and displays each salesperson's (we only have 25, so I can enter them manually) total units sold (only one unit is ever sold at one time) and total Income. I have attached a screenshot of my current attempt, but the expression
seems to only count one time and fails to iterate. Any help would be greatly appreciated!
I plan on making one list per calendar year, so at the end of the year List A might have ~1500 items. List B (the leaderboard) will only show employees' names, and we have around 25 employees that should show on the leaderboard. Ideally I'd have the leaderboard show as a sharepoint list and just customize views for each month (i.e. January shows data for January, etc.). This might not be possible, though. Here's a picture of what the ideal output would be in List B:
I think right now I'm just having trouble filtering the query, as with every Flow run the "Policies Written" value does not increment.