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
