Start subworkflows from excel sheet

0

hi,
you can use standard functionalities and import Excel to Item list and based on the list start workflows with the action "Start a subworkflow (SQL)"

Hi Cezary,

it's definitely possible with the options Jacek mentioned.

There's only one thing to keep in mind. Starting so many workflows will take some time and you will probably run into a timeout starting all of these in one go.
Therefore you should create a loop and always start only a batch of maybe 50 -100 workflows in on iteration.


Best regards,
Daniel

Cezary, you can use openrowset function from ms sql.
https://www.sqlpedia.pl/import-danych-z-excela-do-bazy-sql-server-za-pomoca-t-sql/
https://www.mssqltips.com/sqlservertip/6178/read-excel-file-in-sql-server-with-openrowset-or-opendatasource/