In a catalog item, the user attaches an Excel file and submits the request. Using Flow Designer

[Srilatha Vadlam]

In a catalog item, the user attaches an Excel file and submits the request. Using Flow Designer,
1. it should read the Excel data line by line
2.loop through each row using a script, in the flow designer and
3.then use GlideRecord on the u_data_source table to update existing records or create new records if they do not exist.
for this requriment via flow designer suggest the solution

[Ankur Bawiskar]

@Srilatha Vadlam 

you can use custom flow action and use script to parse the Excel

GlideExcelParser - Scoped, Global 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[jonsan09]

I had a similar use case for updating/inserting records based on an attached spreadsheet. The route I took was setting up a Data Source with a Transform Map. When a request with an attachment was submitted, a Flow would run to copy the attachment to the Data Source, removing the existing file and validating the new one. Then, the Flow would trigger the Scheduled Import.