How to get more than 5,000 rows from a SharePoint list into a PowerApp with Microsoft Power Automate

How to exceed the SharePoint 5,000 item limit in PowerApps by using Microsoft Flow to grab the data from SharePoint and return it to your App. Check out the blog post for full technical details and links to the exported flows.

I've done another video which shows an even easier method of doing this:

#PowerApps #PowerAutomate #SharePoint #MicrosoftFlow

[naioption]

I love your solution, A lot of thanks !!!

[upputurianjamma]

Tqu for giving such solution
Sir you have any viedo or any blog which discuss in detail way of using rest api flow

[ambarish]

Thanks a lot @paulie, this is what I was asked in my interview. 👌
If any videos to pull that array output to Powerapps and show, pls lemme know

[shaunvanhuyssteen]

You absolute legend! Thank you so much for this break down.

[जयभारती-पच]

Really appreciate this video, Kindly guide me in my situation I have a Project list and Task list Each Project have several tasks, I have to display the Project and Task value in the Combo box on the PowerApps form, How I can achieve my goal, Your support is really good

[sreekanth]

Its very helpful, Could you Please share me the Flow

[DMK]

Hi Paul, This is an excellent video and the explanation of the same task I was interested in learning. I was able to download and run your version 1 (Sequential) flow and it works fine. But when I have created my own flow without using Power App (just a trigger manually), and also I excluded response action in it as well. So my flow works only on the first set (5000) and then stops it. in other words the Do Until breaks. So I decided to add "response" action similar to yours. But I don't have the premium license and I was not able to do so. If I am not using Power App portion, do I still need the response action? if not which other action could be used in my flow to continue with rest of the items (about 3000) ? Any advice and recommendations would be really appreciated.
Thanks so much in advance.

[dinoatcharterdotnet]

If I create multiple document libraries in a sharepoint site, will I have sync all of them to my desktop? and if so, will they be in all different folders? is it easy to edit files (Like InDesign files) cross-document libraries?

[JohnHegs]

Great way to solve the problem. Is there any limit on the number of parallel jobs is can run ?

[diegoendo]

Excellent video. One question, since the "response action" is PREMIUM how can I replace this actions and get my data to powerapps

[pliwireframe]

How do I connect the flow with PowerApps?

[jamesmorrison]

Really appreciate this video. Question: If my SharePoint list is greater than 5000 rows, but my http QUERRY request returns less than a 100 rows, do I know need to loop http request? I.e. is the 5000 limit based of the number of rows returned or is it based on the number of rows queried?

[amtvideos]

Can this powerautomate technique be used without powerapp user access directly to the sharepoint list?

[ulises]

Hello, I already made the flow and everything is correct, how can I bring the results obtained to my PowerApps application. I understand that I have to add the PowerAutomate action but I have not been able to get the destro results from the App. Thanks in advance.

[pauladams]

Very useful - thank you so much for sharing! I'm working with adapting Version 6 for use with a PowerApp for a school. I'm almost there, but I'm stuck on the final step! After the union of the four arrays, the JSON code is displaying values from your SharePoint list (email, Furloughed etc). When I try and update the JSON, it gives me the error: 
The schema definition for action with status code '200' is not valid. The schema definitions for actions with same status code must match.
Can you give me a clue how to update the JSON to correspond to my SharePoint list? Best wishes.

[fibonacci]

Hi, need help please, I was able to replicate this and its running fine on my end, however its not working for other users of the app. I made sure they have permissions on the sharepoint list so im not sure what the problem is.

[upputurianjamma]

Sir please provide the link step by step of api method to get the record
I am new to flows I try to implement the api flow by I am getting errorrs

Please sir provide the link of Ali method in detail