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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Filter over 22000 entr...
Power Automate
Unanswered

Filter over 22000 entries from a csv

(0) ShareShare
ReportReport
Posted on by 2

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:
2022-06-13 16_11_52-Window.png

 

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:

2022-06-13 16_16_03-Window.png

 

 

What am I doing wrong? or can't I solve this mass of data with Power Automate?


Categories:
I have the same question (0)
  • B_Dirk Profile Picture
    2 on at

    Nobody has an idea?

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 77 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 68

#3
Expiscornovus Profile Picture

Expiscornovus 56 Most Valuable Professional

Last 30 days Overall leaderboard