How to load xlsx data to table via catalogue item with using flow designer?

Sifa Tok
Tera Contributor

I have a requirement that needs to load the attached xlsx spreadsheet into the services CMDB table via catalog item with using Flow designer. How to do that in Flow designer?

1 ACCEPTED SOLUTION

@Sifa Tok 

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

11 REPLIES 11

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Sifa Tok 

 

So, do you want the user to attach an Excel file, and after submission, the data from the Excel should be mapped into the CMDB tables? Or did I misunderstand?

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Yes, I need to do this. I have a variable called "Service" which is attachment type and the user have to attach xlsx sheet to upload data to services table. So, need to achieve this via Flow designer. If you can provide me how to set flow designer, would be appreciate. Thanks

Sifa Tok
Tera Contributor

Ankur Bawiskar
Tera Patron
Tera Patron

@Sifa Tok 

I shared blog for this but it uses workflow, see if you can leverage that

For flow designer you will anyhow require scripting (Use GlideExcelParser) so why not use the workflow logic

Data load and transform via Catalog Item 

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader