Share
Report
2In my job I track Live Chat query trends. My team of agents currently count queries on an excel template, email to me and I input data manually into a master sheet (report).
I want to automate this on Microsoft Teams, so that their data input is automatically updated minute by minute and is then populated into my master sheet; therefore automatically creating a report for me to just email/distribute with no effort.
The issue I run into, is that on a Monday the agents will then start populating the new weeks data into their excel sheets which will overwrite the data/formulas in my master sheet. To solve this, I want to create a Power Automate process to save the mastersheet as a new file, while copying all the data and pasting as values rather than formula, into a location on SharePoint and emailing a copy of this new excel file.
Any idea how this flow would look? Thank you.
All responses (
Answers (
