Share
Report
12I have a master sharepoint list my team uses to track and assign tickets that we receive from the sales team. I currently have a view for each sales VP (3 views total).
I want to create a flow that will send from this particular view and in an attached spreadsheet provide the information from the view as long as the status is anything other than "completed". I only want to show lines that have "completed" if it was completed in the past 7 days.
I also want the system to update the report only (not sharepoint) for any status that says "completed" to "decision made".
I want the report to go out weekly on Fridays at 5am.
I would also like to include a line in the email that says something like "Please note there are ___ items in the queue". The blank should pull in the count of all lines in the master list (not just for that sales VP team) and all statuses that are not complete.
Any ideas on how to do this? I honestly don't even know where to start other than with "scheduler". I also would like the report to send using email notification (V3), so it comes from the system instead of from my name.
All responses (
Answers (
