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! 🙏

[Ankur Bawiskar]

@Srilatha Vadlam 

Hope you are doing good.

Did my reply answer your question?

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

[Srilatha Vadlam]

Hi @Ankur Bawiskar ,
Can you explain me in detail and step by step to write in the flow
Regards
srilatha

[Ankur Bawiskar]

@Srilatha Vadlam 

Unless you start you wont' learn

where are you stuck?

sample links below to parse excel

How to populate Manager field(reference type) and effective date from excel sheet when using Glide E... 

How to read the data from attached Excel file and store it in a variable before submitting the catal... 

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