Power Platform Community Forum Thread Details

Can I trigger Flow2 as a result of the successful completion of Flow1?

I have Flow1, with a trigger of 'When a file is created (properties only).

This flow has four 'Run Script' actions with a 2 min. 'Delay' between each.

Flow1 is accessing and initiating four scripts (one for each sheet in the workbook), formatting columns, deleting rows, and creating and naming tables, in preparation for copy to a SharePoint list.

I have attempted to include both the script actions and four 'Create item' actions in Flow1.

However, Power Automate is rejecting that concept, as the table names required in the 'Create item' are unavailable until Flow1 runs the script actions successfully. Consequently, when I try to save my flow, I get errors.

Can I have 'Run Script' actions and 'Create item' actions (based on the tables created by the 'Run Script' actions), in the same flow?

If no, what is best practice for initiating a second flow that will move the data from the for tables on the four sheets in the Excel workbook to a SharePoint list?

Alone, the four 'Run Script' actions are working fine.

Alone a 'Create item' would move the data (I've test that, also).

I don't want the flows to run concurrently, as it may create errors and fails.

How do I best achieve this goal?