How to call multiple procedures in sequence or concurrent in Microsoft Fabric Factory

Hey jlakshminaraya 

The details provided by Anonymous  is correct but it is too manual and in case of new additions, you would have to manually add in new activities.

The below design is a meta data driven flow :

1) Create 2 variable like ParallelExecution and Sequentailexecution with semicolon seperated values

wherein values would your SPname1;spname2 etc

2) use 2 foreach activities one for parallel execution and another one for sequential execution with values for thier settings :

value : 

@split(variables('ParallelExecutionSPs'),';')

 

 

Similarly for sequentail :

 

@split(variables('SequentailExecutionSPs'),';')

 

3) within for each , use stored procedure activity

similar would be for sequentail foreach as well

 

 

hope this helps.

 

You can even have the variable as type array and directly use in foreach as is if need be

Thanks NandanHegde  and Anonymous.

Hi jlakshminaraya 
Thanks for using Fabric Community.
Can you please explain your ask a little bit more? So that I can help you better.
Thanks.

Thanks NandanHegde for your time and detail explanation. 

In step 3, do i need to import all 5 stored procedures inside of "for each" and edit the settings of each procedure? 

if yes, stored procedure name on each is SP setting is @item() is final , or something to be enterd?

If No, what is the body  of stored procedure you have imported in step?

Thanks,

Lakshmi Narayana