T13/ Power Automate - Tutorial: Create a scheduled cloud flow from a SharePoint list

Paid Tutorial: An access link will be sent to you after purchase.

In this Microsoft Power Automate tutorial, you will learn how to create a scheduled cloud flow from a SharePoint list connected to a Planning Ms project.

👉 Discover the full training program

To get started, create a new SharePoint list. To do this, go to the SharePoint home page and click on Create List . You can choose from an existing list, just like in our case, we will open an existing Excel file.

In our Excel file, we have the project schedule data. We will create a table from this data . In the Insert tab, click Table . Make sure that the option 'My table has headers' is checked, and then click OK . Now, go back to SharePoint and refresh the Excel file . And there you have it, we have created a list with the project columns.

Now it's time to create our flow on Power Automate to capture the schedule data every day. In the Power Automate app, click Create, then Scheduled Cloud Flows . Set the timing for the flow to run, for example, every day in the evening.

Add a second step to get the SharePoint list items from the current schedule. Select the site and list . If the list is not displayed in the available options, you can add a custom value .

Next, create a third step, find the action. Create a SharePoint item . Add the site and select the list we just created. Then map the corresponding fields. To summarize this flow, every night it will capture all the data via the 'Get Items' action and copy all the items to the new list. Save the flow and run it to test it.

Thanks for following this tutorial. See you next time.