Creating users using a excel sheet on catlog item

[TOXIC STORM]

Hi,

I have a requirement to create a catalog item which can take a excel file of users and create users in sys_user table. But I do not want to use a business rule which runs a schedule import. 

Is it possible to do the above requirements using a Flow Designer. Any leads or help is appreciated

[Najmuddin Mohd]

Hi @TOXIC STORM ,
The below link may help you.

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

It uses a business rule, but not a scheduled one.


Regards,
Najmuddin.

[TOXIC STORM]

Hi @Naj ,

I don't prefer using a BR for a catlog item however I was able to develop a flow but now i am not able to process multiple excel files in one go. All the attachments are copied to Data Source however there is only one import set which is in inserted state the other is still in pending state. 

So I am not sure how to process multiple attachments from data source.

any help or guidance is appreicated

[Najmuddin Mohd]

Hi @TOXIC STORM ,

Try to Use the flow as a sub flow, and call it with the number of Attachments attached.
Hope this helps.

Regards,
Najmuddin.