Tuesday, October 4, 2022
More

    Latest Posts

    Adding Tables To Model-driven Power Apps For Using In Advanced Find

    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.

    Click to view in detail

    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.

    Click to view in detail

    It might seem like an oddly worded option but we now need to click on Add page from the top of the screen.

    Click to view in detail

    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.

    Click to view in detail

    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.

    Click to view in detail

    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.

    Click to view in detail

    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.

    Click to view in detail

    Now the Leads option is available as a table in which we can do our advanced search through. Pretty simple when you know how!

    Click to view in detail

    Latest Posts

    Don't Miss

    Stay in touch

    To be updated with all the latest news, offers and special announcements.