Excel upload / validation via catalog item variable before submitting the catalog request

[Sachin Gavhane]

hi @Ankur Bawiskar 
I’m working on a Service Catalog item with the following variables:

• Attachment variable – used to upload an Excel file

• List Collector variable – used to store users

The uploaded Excel file contains only two columns:

• User Name

• User ID (primary key; corresponds to sys_user.upn)

Requirement

When a user uploads the Excel file via the attachment variable:

1. The system should read and validate all rows in the Excel file against the sys_user table using the User ID.

2. If every entry in the Excel file is valid:

   • Populate the List Collector variable with the corresponding users.

3. If any single row contains an invalid or non-existent User ID:

   • Prevent the catalog item from being submitted.

   • Display a clear list of invalid entries on the catalog form so the user can correct the Excel file and re-upload it.

Key Constraint

• Validation must be all-or-nothing — partial population of the List Collector is not allowed.
  
  Requesting your help for this solution.
  
  Thanks !

[Ankur Bawiskar]

@Sachin Gavhane 

so what you tried and where are you stuck?

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