cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RockyRocks
Level: Powered On

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 Smiley Happy

 

 

 

2 REPLIES 2
jhall
Level 8

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?

RockyRocks
Level: Powered On

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

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

Follow PowerApps on Twitter

Stay Up-to-Date by following PowerApps on Twitter

Top Community Contributors for July 2019

Top Community Contributors for July 2019

Let's thank our top community contributors

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

FifthImage

Dynamics 365 and Power Platform April 2019 Release notes

Features releasing from April 2019 through September 2019!

Users Online
Currently online: 66 members 3,932 guests
Please welcome our newest community members: