How to add the data from excel attachement to queues in orchestrator?

I have attached my excel sheet here


I need to add the Invoice numbers only 1177,330,12244,INVOICE1184 from excel to Queues in orchestrator.
Can anyone guide me how to add the invoice numbers to queues in orchestrator.

  • Read the spreadsheet using read range

  • Get distinct values within the ‘Invoice Number’ column to a list

    • Assign (From r In DataTable.AsEnumerable() Select r.Field(Of String)(“Invoice Number”)).Distinct.ToList() to a list
  • Loop through that list using add queue item with parameters of Invoice Number

2 Likes

Hi,

Check this xaml, it may help you

AddToQueueItems.xaml (6.1 KB)

1 Like

Thanks for your support.