Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Remove duplicated record (Power automate flow)

(0) ShareShare
ReportReport
Posted on by 8

Hello everyone, I'm working on creating a Power Automate flow to eliminate duplicate (serial number) records but I'm struggling to get this works. Please refer to the attached screenshots for details on data table and my flow.

 

When I remove the NextLink from the skip token field in the "List rows 2" step, the flow works well but it removes both the original and duplicate records. However, when I input the NextLink variable into the skip token field, an error occurs in the "List rows 2" part. I suspect the problem lies with the NextLink variable. I would appreciate it if someone could review my flow and identify any issues. Feel free to ask for any additional information about this flow.

 

Data table:

KSean_0-1699786189121.png

 

 

1)

KSean_1-1699786188991.png

 

 

2)

KSean_2-1699786189042.png

 

 

3) Input: @{length(outputs('List_rows')?['body/value'])}

KSean_3-1699786189027.png

 

 

4)

KSean_4-1699786189009.png

 

Name : NextLink 
Value: @{if(empty(outputs('List_rows')?['body/@odata.nextLink']),'',decodeUriComponent(last(split(uriQuery(outputs('List_rows')['body/@odata.nextLink']),'skiptoken=')))}

 

5)

KSean_5-1699786189016.png

 

KSean_6-1699786188975.png

 

 

6)

KSean_7-1699786189198.png

 

KSean_8-1699786188965.png

 

KSean_9-1699786189419.png

 

 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard