web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send personalised lice...
Power Automate
Unanswered

Send personalised license report to managers based off multiple excel sheets

(0) ShareShare
ReportReport
Posted on by

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. 

Categories:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard