Hi, first time posting on here so if I am missing some clarity on this issue please let me know.
I send reports of how many users use about 9 different software each month to the finance team so they can keep track of who is using what and bill them accordingly. This report is an excel spreadsheet with a sheet for each software and each sheet contains the email of the user, department and manager. So for example: Karen Smith | HR | John Doe
I want to send a report to each manager (e.g. John Doe) with only how many users who have John Doe as their manager. I considered using Power BI however there is a chance that not all users have a BI license (and doesn't make sense to get a license just for this report) so for now I have settled on an email that will give the manager a count of how many users are using each software; for example:
Manager: John Doe
Airtable: 34
Confluence: 2
Jira: 56
Mentimeter: 4
Mural: 13
etc....
I figured the best way might be to create a pivot table which can give me this sum of each software but I have no clue on how to pull this data from Excel into Flow and then create an email populated with the numbers. Perhaps there is another way without needing a pivot table?
I have over 1,000 managers to send this to so there is no chance of performing this manually, I understand when I send the email I can put in a variable which would automatically change the manager depending on a list.
I am fairly new to Power platform, I typically use a flow which uses data from excel to send a prepopulated email with variables according to the excel data however this one has stumped me.

Report
All responses (
Answers (