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?