# While Add queue Item in queue how to avoid duplicate data in queue

**URL:** <https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734>\
**Category:** Orchestrator\
**Tags:** question, orchestrator\
**Created:** [December 27, 2021, 10:27am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734 "2021-12-27T10:27:28Z")\
**Posts on this page:** 16\
**Page:** 1

<div class="post-metadata">

**Author:** ![PRABHJOT\_SINGH](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prabhjot_singh/32/268791_2.png) [@PRABHJOT\_SINGH](https://forum.uipath.com/u/PRABHJOT_SINGH)\
**Post date:** [December 27, 2021, 10:27am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/1 "2021-12-27T10:27:28Z")

</div>

Hi ,

i want to avoid duplicate data in queue while adding data in queue .Really Apricated if any Example and workflow shared how to handle.

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 10:30am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/2 "2021-12-27T10:30:11Z")

</div>

Hey,  
You can use ‘reference’ in the ‘add queue item’ activity and in the queue settings mark unique reference as true.  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/2/8/0/2804ca2d5fd9dc13667e48c86f8ad5379da540b6.png)  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/5/0/0/50004a82f1879375794ee783df12501a38ac1b3c.png)

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 10:33am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/3 "2021-12-27T10:33:47Z")

</div>

Ach. When you do this and reference number will be exists in the queue you will get an exception. So please remember handle this activity for example using ‘try catch’.

---

<div class="post-metadata">

**Author:** ![PRABHJOT\_SINGH](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prabhjot_singh/32/268791_2.png) [@PRABHJOT\_SINGH](https://forum.uipath.com/u/PRABHJOT_SINGH)\
**Post date:** [December 27, 2021, 10:34am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/4 "2021-12-27T10:34:40Z")

</div>

Thanks Pikorpa For quick reply. can you please let me know one more thing what should use in reference section in property section.

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 27, 2021, 10:34am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/5 "2021-12-27T10:34:43Z")

</div>

Hi @PRABHJOT_SINGH

Welcome back to UiPath Forum,

Please look at this.

You can use Unique reference option for this to avoid duplicating the same queue item

![image](https://global.discourse-cdn.com/uipath/original/4X/0/d/4/0d467149fa801c15c81932d2b02f5f03c6cde389.png)

Thank you.

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 27, 2021, 10:36am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/6 "2021-12-27T10:36:50Z")

</div>

Unique reference should be some unique identifier.

Example:

PolicyNumber, ClaimNumber etc.

Thank you

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 10:38am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/7 "2021-12-27T10:38:32Z")

</div>

The reference number should be unique value like: ‘order number’, ‘guid’ etc.  
To set ‘unique reference’ in Orchestrator you have to create new queue. If I remember correctly you can’t add this properties when editing.

---

<div class="post-metadata">

**Author:** ![PRABHJOT\_SINGH](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prabhjot_singh/32/268791_2.png) [@PRABHJOT\_SINGH](https://forum.uipath.com/u/PRABHJOT_SINGH)\
**Post date:** [December 27, 2021, 10:40am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/8 "2021-12-27T10:40:49Z")

</div>

Thanks @Jobin_Joy . Its Like a Unique Key!! Right. Is there any way to edit Unique Reference from No to Yes in existing Queue or i need to create new Queue. Because System does not let me allow to change this.

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 10:43am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/9 "2021-12-27T10:43:28Z")

</div>

@PRABHJOT_SINGH unfortunately you have to create new one.

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 27, 2021, 10:44am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/10 "2021-12-27T10:44:55Z")

</div>

As @pikorpa mentioed we can’t change it once created. Thank you

---

<div class="post-metadata">

**Author:** ![PRABHJOT\_SINGH](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prabhjot_singh/32/268791_2.png) [@PRABHJOT\_SINGH](https://forum.uipath.com/u/PRABHJOT_SINGH)\
**Post date:** [December 27, 2021, 11:48am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/11 "2021-12-27T11:48:15Z")

</div>

Thanks @pikorpa @Jobin_Joy , Can you please look once on mentioned screenshot while first run its added the data and when add more data in excel and run the Workflow its showing unique Reference error .how to solve this issue if i want to add those data which not added before and avoid duplicate those which is already added. For Example if we getting data every hr and appending frequently.  
 ![SCREENSHOTS11](https://global.discourse-cdn.com/uipath/original/4X/f/8/0/f8099374c92fcbdd04e662a4d338166d1a29c029.png)

 ![image](https://global.discourse-cdn.com/uipath/original/4X/3/f/c/3fc6a874b3a87b06ca209b96fefa00e509c0a19b.png)

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 11:55am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/12 "2021-12-27T11:55:01Z")

</div>

As I mentioned before, you cannot add the same ‘unique reference’ twice.  
You have to handle this, for example by adding ‘try catch’.  
 ![image](https://global.discourse-cdn.com/uipath/original/4X/3/2/5/325faac957e0e63557329f1bb83027ebd2a02207.png)

---

<div class="post-metadata">

**Author:** ![Jobin\_Joy](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/jobin_joy/32/555040_2.png) [@Jobin\_Joy](https://forum.uipath.com/u/Jobin_Joy)\
**Post date:** [December 27, 2021, 11:58am UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/13 "2021-12-27T11:58:01Z")

</div>

> [@PRABHJOT\_SINGH](#):
>
> unique Reference error

If you want add item(s) which are not added before means, simply set the unique reference error exception as nothing instead of throwing errorthat so the BOT will add the missed items to the queue.  
Basically, error will be there but you are not taking any action since it is excepted one in your case.

Thank you.

---

<div class="post-metadata">

**Author:** ![PRABHJOT\_SINGH](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/prabhjot_singh/32/268791_2.png) [@PRABHJOT\_SINGH](https://forum.uipath.com/u/PRABHJOT_SINGH)\
**Post date:** [December 27, 2021, 12:22pm UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/14 "2021-12-27T12:22:43Z")

</div>

Thanks @Jobin_Joy @pikorpa .Its Working

---

<div class="post-metadata">

**Author:** ![pikorpa](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/pikorpa/32/548059_2.png) [@pikorpa](https://forum.uipath.com/u/pikorpa)\
**Post date:** [December 27, 2021, 1:01pm UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/15 "2021-12-27T13:01:24Z")

</div>

you’re welcome 🙂

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/uipath/user_avatar/forum.uipath.com/system/32/182466_2.png) [@system](https://forum.uipath.com/u/system)\
**Post date:** [December 30, 2021, 1:02pm UTC](https://forum.uipath.com/t/while-add-queue-item-in-queue-how-to-avoid-duplicate-data-in-queue/385734/16 "2021-12-30T13:02:21Z")

</div>

Closed on December 30, 2021, 1:02pm UTC

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
