Find/Filter a value from 70k row spreadsheet

[leungly875]

With the limitation of importing 20k rows from Excel to a Microsoft List, I've been able to convert the file to CSV and use Parse JSON to create an array hoping to leverage the 'Filter Array" action but no luck - Returns null value.

Curious if anyone else has a better idea to find/filter or return a row of data from a 70k row data set based on a single value.

I've based my workaround on this: https://www.damobird365.com/parse-a-csv-to-json-array-quickly/

[lbendlin]

Have you considered running an ODATA query?

[leungly875]

Thanks for suggesting that. I haven't provided a very good explanation of what I've done so far.

The SKUFile is a text version of 70k rows. The following actions then turn it into something I can use the Parse JSON Action. (The Sample data action gives me the schema).

So far the output of the Parse JSON looks good but I'm not able to use the Filter Array.

Where would could I insert an ODATA Query?

[lbendlin]

Ah, your post title says spreadsheet so I was assuming an Excel source - my bad.  As far as i know you can't do ODATA queries against text files.