Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Powerapps to connect sharepoint with webapi and flow

Hi Team,


I am new to powerapps need help to seach with api.


I have huge record of 20000 to search from sharepoint, But its very slow to search and fetch.


How to use Restful to seach against a Name/ID and call all the related files to powerapps.


I have an textbox with search button


In Textbox we can search with Both ID & Name


In sharepoint


ID              Name         Education                Salary            D0B

Ser123       Mohan         Graduation           250000        15/11/90

Ser456         Raju             Post-Gra              350000        12/11/86

Ser879         Apple           Post-Gra              750000         15/08/83     

Ser875          Ram                Graduatin          600000           01/05/85 


So from powerapps when i type with ID/Name from same textbox(Seach box), Through RestAPI i want to fetch all the related details  and display in gallery


Any help will be thankful 🙂




Continued Contributor
Continued Contributor

Re: Powerapps to connect sharepoint with webapi and flow

Well, you're taking this through Flow, so note that some of that is non-real-time.  Flow is on-demand so can be slower than direct PowerApps queries to data sources.

Not that you should be querying that large of a dataset w/ PowerApps either.

Any chance you can do the optimized query at the source of the data and call it from PowerApps so that the data is sorted/filtered before you to it at the desktop?

Frequent Visitor

Re: Powerapps to connect sharepoint with webapi and flow

Hi @jhall

Thanks for providing the reply,
Can we able to call restApi without flow, if flow will also cause the slowness or performance issue.

Please provide any alternative solution, I hope restAPI will be fast compared to others.

Helpful resources

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Watch Now

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,778)