Engineering tasks in a task management PowerApp created on a schedule

Hi,

Just looking for a bit of advice if anyone has experience of something similar.

I made an app for our engineering department that allows tasks to be created, viewed, marked as completed etc. It has been working successfully and I have now been asked to integrate it with scheduled maintenance tasks that are currently done on paper. The details of the tasks are kept in a Sharepoint list as that and Excel are the only options that I have.

So, I need a way of inputting a calendar of tasks for the year and then generating a task in the Sharepoint list, for example, once a month to cover all the tasks due for the next month. I can then get the app to pick up those new tasks in the list. Ideally, I want to be able to have some items triggered once a month, week, etc. I could do that by lots of individual PowerAutomate flows but is there a way that I could have an overall list that covers everything?

I was thinking PowerAutomate to generate tasks in the task list but any advice how/where to generate the background task schedule? Sharepoint list? Outlook calendar?

Thanks,

Izzy.

Categories:

General Questions

Connecting to Data