cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
leungly875
Frequent Visitor

Find/Filter a value from 70k row spreadsheet

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/

3 REPLIES 3
lbendlin
Power Participant
Power Participant

Have you considered running an ODATA query?

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?

 

Text-to-ParseJSON.png

lbendlin
Power Participant
Power Participant

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. 

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (4,409)