Fill data grid on button click

I need to extract the data from external database and load on the data grid after clicking on a button. I was able to fill data grid directly calling microflow from datagrid but I need provide below functionality to user Have text field that accepts input from user Search external database using user entered data as search criteria (Button click) Fill data grid with search results I tried calling microflow on button action and associated the corresponding output entity to data grid but its showing empty rows in data grid Any ideas on how to achieve this is helpful.
1 answers

Can you define Non-persistent entity linked to Search Result. On click of search button then you can create a list of npe objects and refresh on client to view them in data grid. You can fetch all matching records from external db. And for pagination you can use the data grid's ability.