How to search data from sharepoint

[sindhureddy]

Hi ,

I have a SharePoint list name "Certification" which has more than 5,00,000 data in this list. When I enter the input in textbox(Textinput5 as shown in image) and click on the "search" button then the flow has to trigger and the data which I am searching should display in the Gallery from SharePoint list using search/REST API in power automate.

So, how can I search the data from large list in PowerApps using Rest API calls in the flow.

I have tried as the below but I can only filter for first column Like If I change the column name in the formula from ReqID to some other column its not giving the result _api/web/lists/getbytitle('Certification Data')/items?$filter=ReqID eq. 
And when returning back to powerapps its showing in json How to display in proper format in gallery?

Thanks in Advance

[Shujaath_Khan · Accepted solution]

Hi @sindhureddy 

• Did you checked if you flow is working?
• If it's working, instead of responding with Respond to PowerApp connector can you try to return with HTTP Response connector.
• And from PowerApp you can try to save the response as a collection which can be glued to Gallery.
  • for ex : ClearCollect(colFlowResp, flow.Run())

Thanks

Please click Accept as solution if my post helped you solve your issue. If the content was useful in other ways, please consider giving it Thumbs Up.