
Announcements
Hello all,
I hope a professional can tell me if this is possible with Power Automate. I have tried everything and have not found a solution.
I have two csv files:
1. with 100 names in 100 lines
2. with 1000 names and data in 22000 lines
I need to find the 100 names in the 22000 rows, I don't need the remaining 900. Then filter the names with the data to use this information further afterwards.
There are already some tests in progress, but they are still not completed:
I have also tried this method:
Compare two arrays, tables or lists a lot faster in Power Automate (sharepains.com)
But the problem is that I have to filter the data and therefore I have to run the loop x times:
What am I doing wrong? or can't I solve this mass of data with Power Automate?