I have a list on sharepoint with manager's personal number (string) with 17 records
I need to filter a csv file with 25000 records, to get the ones that have managers with the list personal number(string).
I made the CSV map and turned it into JSON .
I did a get on the list and got the records
I have a loop in the list(personal number) and Filter Array inside the loop but Filter array exceeded the maximum value '209715200' bytes allowed
I'm trying to use Filter Array because a loop inside a loop runs forever
Is it possible to make this filter using power automate?
Go to Solution.
If I have understood, you are attemping an Except or Left Join? I have written an article here https://www.damobird365.com/efficien-union-except-and-intersect-great-method/ on how to do this with just a filter action. Please let me know if this helps?
Please consider accepting my answer as a solution if it helps to solve your problem.CheersDamienPlease take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts, or take a look at my website. Thanks
View solution in original post
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.