Faster Excel Reads
If you're finding the standard List rows present in table Excel action is too limited or too slow, check the method built in this template. It can read in more than 100,000 Excel rows more than 5 times faster than standard List rows actions without any premium connectors.
If you want an even faster method, here is an Excel Office Script template that pulled 50,000 rows of data from an Excel sheet in under a minute.
https://community.powerplatform.com/galleries/gallery-posts/?postid=9f7a7bcf-c88f-ef11-ac20-7c1e525bd67d
Import Instructions
Download the package at the bottom of the post.
Go to https://make.powerapps.com/
Select Solutions on the left-side menu, then Import solution, then Browse on the pop-up menu
Then find the solution package you downloaded & select to use/open it
After the package is selected, select Next twice. Then select existing or create new connections for each connection listed. Make sure to use different connections for each Excel connection input. Select Import when done.
Then wait for the import to complete. Then find the Faster Excel Read solution in the main list.
That should bring you into the Solution where you can find & select to edit the flow.
Delete the "Placeholder Delete After Import" compose action to remove the placeholder references set in each Excel action.
And input the Location, Document Library, File, & Table you want to read in the Excel action in the Do until loop.
Then go to the Apply to each Get all rows in batches loop, go to the Switch action, open every Switch case branch, go to each Excel action, go to the three dots ... and select to create a new connection on each one.
Now, all the values that would normally be in the Excel values dynamic content are in the CombinedArray dynamic content.
If you have trouble with the Power Apps Solution import, then you can also try the Power Automate Legacy Import here.
Thanks for any feedback,
Please subscribe to my YouTube channel (https://youtube.com/@tylerkolota?si=uEGKko1U8D29CJ86).
And reach out on LinkedIn (https://www.linkedin.com/in/kolota/) if you want to hire me to consult or build more custom Microsoft solutions for you.
Solution Zip Download Link: https://drive.google.com/file/d/1naBm5Hw_YBdB0fzLud5sXbYuySoZ3f9D/view?usp=sharing
