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

Notifications

Announcements

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

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 463 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 427 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard