Answered

Duplicate Items from Get Items Activity

(0) Share

Report

Posted on by MiPP

Hello everyone,

I have a problem with duplicating lines coming from a list. In short, what I do is to call the items form a list with the "Get items" activity, then with a "Select" I create the table, after that I use "Create CSV" and "Create file" activity. The problem is that when the file is created, duplicate lines appear in it. From what I have observed, the problem is from retrieving items from the "Get items" activity, where in response they are already duplicated.

Anyone with any ideas? Thank you very much😁

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

v-yueyun-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi , @MiPP
According to your description, you want to delete the duplicate in Get Items action.
First , you can use the Select action to extract the column you need ;
item()?['FieldName']
Perform operations on data - Azure Logic Apps | Microsoft Learn

Then you can use the union() function to delete the duplicate in an array:
union(body('Select'),body('Select'))
For more information, you can refer to :
Reference guide for expression functions - Azure Logic Apps | Microsoft Learn

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,
Yueyun Zhang

Was this reply helpful? Yes No
Verified answer

MiPP 12 on at

Like (0)

Report
Copy link

Link copied!

For those who have this problem, this solution is a good one.

Although I still don't understand why the "Get items" activity duplicates or triples items from the list, you just have to use the above syntax in "Create CSV table".

Thanks a lot😎

Was this reply helpful? Yes No