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 🙂




jhall 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

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.


New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,723)