Hello, I am looking to optimize my workflow with Power Automate and while it seems like a simple request, my knowledge on Power Automate is limited. We have a SharePoint task list with thousands of different tasks assigned to different people. Each week, I send all assignees in the marketing department an email with everything they have due this week. This takes me a lot of time but helps the team out and we have seen some benefits from it when it comes to assignees knowing what they need to do and completing tasks on time. I would like to automate this...
My thought on how this would work... each Monday at 7am gather all the tasks assigned to the Marketing Department that are due this week. Then the system would run through each assignee and compile as of John Doe's tasks into a Table format (Title, Due Date, Link to SP) to be sent view Teams. Instead of just doing John Doe's tasks, once his is complete it would move onto Mary Jane's tasks, and continue until there are no more names with items due this week.
Any ideas on how to do this? Or do something similar? Copilot hasn't been much help but that could also just be user error
