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

[jamunatj (jamuna)]

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.

[TimK (Tim Kok)]

• 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

[sarathi125 (Parthasarathi)]

Hi,

Check this xaml, it may help you

AddToQueueItems.xaml (6.1 KB)

[jamunatj (jamuna)]

Thanks for your support.