upload excel file to the catalog item to create sc_task for users

[LakshmiVenkata]

there is one catalog form in that we created one variable to attach the excel sheet on that catalog item after submitting the catalog form i need to create sc_tasks for those users which the data is available in the excel sheet like for one row one sc_task for this i want the run script to create the task by using workflow

[Bhuvan]

@LakshmiVenkata 

Check if you want to create task records directly without creating REQ and RITM.

https://www.servicenow.com/community/developer-forum/task-without-ritm/m-p/1528420

You can use below as reference and create tasks. In the example, user records are created based on the attached excel and logic would be similar

https://www.servicenow.com/community/developer-blog/automate-data-import-from-excel-file-attachment-...

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Ankur Bawiskar]

@LakshmiVenkata 

you can use workflow run script

parse the excel and create those many sc_task

Parsing the Excel Sheet data & Use the data In automation via Request Item(Catalog Item) 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@LakshmiVenkata 

based on rows in the attached excel you want those many catalog tasks?

If yes then in your flow you will have to create flow variable of type Integer, use GlideExcelParser and determine the number of rows

Then use For Each based on that count and create tasks

check this link

Increment integer flow variable in each loop until variable reach 5 not working with below approach 

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@LakshmiVenkata 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.