Power Platform Community Forum Thread Details

Hi,

I'm just looking for some advice on possible best ways of automating a task list we've been given from area of our business.

They currently have a list of jobs that are all recorded in a spreadsheet for compliance purposes with different people allocated to the tasks as well as due dates.

They'd like a power automate/logic app to look up this spreadsheet (if possible), create a task/calendar reminder on the due date + 1 week prior to the due date for the allocated peoples' calendars as well as probably a task in planner so that they're able to mark it as complete too.

It would ideally need to look up the existing spreadsheet to create all the current tasks, as well as when they add new ones too.

Just wondered what you may think the best format would be to have the data in in the first place? Screenshot below of some of the information that's needed. Annotation 2020-05-20 173315.png