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

(0) Share

Report

Posted on by Community Power Pla...

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:

Business Process Flows

I have the same question (0)

All responses (3)

Answers (0)

ChristianAbata 8,949 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Confidential 2 on at

Like (0)

Report

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?

Was this reply helpful? Yes No