Get value from column in the queue

Help
1

Hi Community

I am trying to assign a value from the queue to a string, but i get this error below.

It seems it cannot value in the column “Navn”

So… how can I get the value from the ‘Navn’ Column, can i maybe indicate the index instead of “Navn” ?

What is the best practice for this?

Thank you

image
image1293×660 46.7 KB

image
image1385×737 36.9 KB

image
image703×147 12.9 KB

2

Hi @ChrisPals,

Which datatype you are using to store the values in the Queue.

3

@ChrisPals

  1. Is your Uipath studio connected to Orchestrator or not ?

  2. Is TransactionItem of type QueueItem ?

  3. Is Navn Column data existed in Orchestrator Queue or not ? Could you please show me screenshot of your Orchestrator Queue data.

4

Hi @lakshman

  1. Yes it is connected.

  2. TransactionItem is QueueItem

  3. How can i take a screenshot of the queue?

5

hi @sarathi125

I suppose you mean DataTable?

image
image744×370 8.45 KB

6

Yes, Do you have datatable inside your Queue item?

7

I am not sure what you mean exactly.

As you can see,in the screenshot, each row in the DT is added to the queue.

So it might be DataRow?

8

You can use "Convert.ToString(datarow.Item(“Navn”)), if you are getting datarow from queue.

9

@ChrisPals
Can you share with us the configuration details for the item information Click on the … (Add Queue Item Activity)
grafik

10

Where should i write this, before adding it to the queue or after?

11

hi @ppr

Here you go:

image
image832×287 8.81 KB

12

@ChrisPals
thanks
the ItemInfo looks Ok, the retrieval statement on the TransactionItem.SpecificContent Looks Ok
So for the next analysis step I would suggest:

Is Navn Column data existed in Orchestrator Queue or not ? Could you please show me screenshot of your Orchestrator Queue data.

Post from @lakshman
therefore check for an added QueueItem if the Navn Value is available

Check the ItemInformation Setting if there is not a space on end of the Navn name
grafik

Debug your Workflow with Breakpoint on
grafik
and check TransactionItem in the local Panels

1 Like
13

Hi all

I figured it out. Everything was ok, i just had old queue items in the queue that I needed to delete.

Thank you for all the input.

Happy Automating.

1 Like