web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Duplicate Items from G...

Power Automate

Answered

Duplicate Items from Get Items Activity

(0) Share

Report

Report

Posted on by MiPP

12

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:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

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

Join the conversation