web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Delete Excel Rows that...
Power Automate
Unanswered

Delete Excel Rows that appear in another Excel File with the same data strucutre

(0) ShareShare
ReportReport
Posted on by

Hello everybody,

 

I am currently trying to build a flow, where data rows in excel are going to be deleted if they appear in another excel file.

The data is organized in tables with the same data structure. You can imagine it like there is one "master" list with a lot of entries and another list (in another excel file) with the data/rows that should be deleted from the master file. 

For example the master list has 1000 entries and the other file contains 100 that are already part of the master list but should be deleted with my flow.

 

In order to do that i would have to read the data of both files into my Power Automate Workflow and work with the dynamic values of both. Because they both have the same data structure, it would be sufficient to check one column (each row has one unique value row).

 

Thanks in advance

Lennard

Categories:
I have the same question (0)
  • ChristianAbata Profile Picture
    8,951 Most Valuable Professional on at
    Re: Delete Excel Rows that appear in another Excel File with the same data strucutre

    hi @Anonymous  if you have a Unique idenfier you can read that ID from first excel and then use that ID to delete the row in the other excel

  • Community Power Platform Member Profile Picture
    on at
    Re: Delete Excel Rows that appear in another Excel File with the same data strucutre

    Alright, thank you Christian.

    There were other upcoming solutions regarding the environment around the workflow, but when i get to it, i'll give feedback. Thanks a lot for the input though!

  • Confidential Profile Picture
    2 on at
    Re: Delete Excel Rows that appear in another Excel File with the same data strucutre

    I'm running into this same problem, how do you do this?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard