Hi All I have used get Queue item activity in UiPath and i got the output ienumerable values, how do i convert into datatable without loop? Can anyone suggest me how do i do that?

[image] divya.17290: JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable) @divya.17290 , Modifying it a bit to add the namespace, could you check the below expression : Newtonsoft.Json.Linq.JArray.FromObject(YourGetQueueItemsOut.Selec…

With loop Build Data Table (Create an empty DataTable with the desired columns) For Each item in IEnumerable a. Add Data Row (Add each item to the DataTable) With out loop you can try this way YourIEnumerableVariable.CopyToDataTable() @divya.17290

Hi @divya.17290 , Could you maybe check with the below post : [image] How to convert ienumerable<queueItem> to datatable Studio We assume that get Queue Item->s is used here we would recommend to specify what is needed. QueueItems Properties e.g. Reference, Status,… Spe…

He suggest the querry " JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable)" but i got error for JArray not declared

Can you try this Assign Activity: dtData = JArray.FromObject(YourGetQueueItemsOut.Select(Function (x) x.SpecificContent).toArray).toObject(Of DataTable) @divya.17290

I can extract the queue items and write into the excel.Thanks!

How to convert iEnumerable into datatable

Help Studio

supermanPunch (Arpan) September 16, 2023, 11:07am 3

Hi @divya.17290 ,

Could you maybe check with the below post :

Topic		Replies	Views
How to convert IEnuberable into Datatable Studio studio , question , project_panel	6	624	December 11, 2023
How to write IEnumerable<QueueItem> to DataTable Activities datatable , uiautomation , activities , studio , question	9	568	July 19, 2024
How to convert ienumerable<queueItem> to datatable Studio	5	3583	February 3, 2023
Create datatable from queue items Studio orchestrator , activities , studio	7	1580	May 29, 2024
Storing queue items in a DataTable... Armazenar os itens de uma fila em um DataTable Activities datatable , orchestrator , activities , studio , question , data_service	14	538	January 9, 2024

How to convert iEnumerable into datatable

Related topics