How to load excel data into servicenow group member table using flow designer

[HemaLatha Koyya]

Hi team,

I have a requirement to create a catalog item with attachment variable, if the excel attachment is attached with group member and group name then need to load the data into servicenow group member table using the flow designer.

[Tony Chatfield1]

Hi, this thread should help you with the record producer side of the process.

Import data via a Record producer and generate a n... - ServiceNow Community

But the normal process for loading data into the platform from file is to use import set\transform process.

Imports (servicenow.com)
Can you explain why you need to use flow?

[Community Alums]

Hi @HemaLatha Koyya ,

This article should give you an idea :https://www.servicenow.com/community/now-platform-articles/create-custom-csv-files-in-flow-designer-...

[Riya Verma]

Hi @HemaLatha Koyya ,

Hope you are doing great.

1. Create a new catalog item Define the relevant details such as the item name, description, and category.

2. Add an attachment variable to the catalog item by choosing the attachment variable type. Specify the appropriate label and any other desired properties for the variable.

3. In order to process the attachment and load the data into the ServiceNow group member table, create flow designer. 

4. Drag and drop the "Attachment Received" trigger onto the canvas. This trigger will initiate the flow when an attachment is received.

5. Add a condition to check if the attachment has an Excel file extension (.xlsx, .xls). If the condition is met, proceed to the next step; otherwise handle the situation accordingly.

6. Next, add a "Create Record" action to the flow. Configure the action to create a new record in the ServiceNow group member table. Map the relevant fields from the Excel attachment to the corresponding fields in the group member table.

7. Save & Activate flow  

Also, We have a blog created in servicnow to load excel data into servicenow group member table using flow designer, Please find below blog link for reference:

https://www.servicenow.com/community/developer-blog/data-load-and-transform-via-catalog-item/ba-p/22...

[yaswanth123]

Hi,

Could you please share the flow that you created for that.