Unanswered

Delete rows in a dataset using PowerAutomate

(0) Share

Report

Posted on by LpaulaX

Hello!

I'm using PowerAutomate to add rows to a dataset everyday, but, I'm getting the same information over and over again everytime the script runs.

I want to delete the actual rows before adding the ones with the new information, is there a way to do it?

Maybe another step before "Add rows to a dataset" will work, but which one?

Thanks

Categories:

General topics

All responses (6)

Answers (0)

Sort by

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @LpaulaX

did you meant to delete all datasets before adding new ones ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@LpaulaX

There is no action that will allow you to delete a row in a data set. I suggest using Power Query to delete the unwanted rows - possibly remove duplicates.
LpaulaX 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@ScottShearer Thats exactly what I need, remove duplicates.
How do I use power query to do it? And can I do it via flow?
LpaulaX 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Nived_Nambiar no. I'm getting duplicates everytime my flow runs, and I want to remove them.
LpaulaX 8 on at

Like
a
(0)

Report
Copy link

Link copied!

My only idea was to do using "Run a query against a dataset" is this possible? there is another way?
ScottShearer 25,331 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@LpaulaX

You don't use Power Query in Flow - it is part of Power BI Desktop.

In Power BI Desktop, click on Transform Data on the Home ribbon to launch Power Query.

Here is a blog post that explains how to remove duplicates in Power Query.