As reviewed in my post that provides a Comprehensive Guide To Modern Advanced Find & View Management, the ability to actually search across a table using the latest Advanced Find functionality is only possible if if it exists within the app being used. I had a few questions asking how to add tables to the app even if you don’t want to have them in the navigation. Let’s take a quick look at how to achieve this.
I’ve got a custom app with just a few tables in it. I might want to allow users to search for Leads and Quotes for example, but might not want them on the navigation.
To do this, go to https://make.powerapps.com (assuming you are a System Administrator) and make sure you are in the correct environment (displayed at the top right of the screen once logged in). From the left hand navigation, click on Apps, then find the App you want to make changes to. Click on the ellipsis (3 dots) to get the menu, then click on Edit.
It might seem like an oddly worded option but we now need to click on Add page from the top of the screen.
The page type we need is a table based view and form. That’s selected by default, so just click on the Next button to continue.
Now search for the table you want to add to advanced find then click on it to select it. At the bottom, make sure to de-select the option that states ‘Show in navigation’. Click Add.
We can now see that Lead is one of the pages in the app, but it does not appear in the navigation of the app.
After saving and publishing the changes, open up the model-driven app (refresh a few times or clear the cache) and click in the Search box at the top of the app. Click the link for advanced filters.
Now the Leads option is available as a table in which we can do our advanced search through. Pretty simple when you know how!