Adding Missing Tables to Modern Advanced Find Experience (Model-Driven Power Apps)

With the recent introduction of the new modern advanced find experience, we’ve seen a major step forward in modernising a key piece of functionality tied to the “classic” experience. And, to be fair to Microsoft, this feature has pretty good parity with what we’re used to in the old experience. Not only can we use the modern experience to find the data we want, but it also supports the creation of personal views, and, for our developer friends, we can download the underlying FetchXML query. Change can often be a rocky road in today’s cloud world, but with this, I think we have an example of how to do it correctly. 😀
Despite this, I have ONE gripe and slightly annoying thing that came up recently on a project. Whereas the old Advanced Find experience allows us to search for all possible tables in the Dataverse environment, we observed that the new experience did not follow this expectation. Indeed, key tables we knew to be present wouldn’t appear on the list when we searched for them. Frustrating, but on closer inspection, there’s a pretty good explanation - and solution - for this.
Let’s start by looking at an example. Below, I have an expertly built model-driven app that is surfacing out just the Account table:
Note as part of this that I have:
- Added the Account table to the Sitemap
- The Account table is present within the In your app area of the app configuration
When we hit the play button and attempt to use the new Advanced Find experience, we observe that only the Account table is visible:
As it turns out, the crucial element here is that list of tables that appear within the In your app section mentioned above. For those more familiar with the classic experience, the list of tables we see below also indicates this:
Indeed, the classic experience becomes crucial for this current problem, as it appears that this is the only route that allows us to add/remove tables to this list:
With the Contact table added and after re-publishing the app, we can see that this is now present on the list of options:
The only other option could be to add the tables into the new modern app designer via the New Page option, but doing this includes them in the sitemap, which may not be your desired outcome.
It perhaps makes sense why the new experience behaves in this fashion, and why we would have to go through this extra step to surface any tables we may be missing. In most situations, it is preferable to include them as part of the sitemap instead. This step has the benefit of indirectly including the table in the In your app list while making it easier for users to find. However, hopefully, this post is useful if all you care about is the modern Advanced Find experience. As a final tip, also ensure you include the appropriate forms/views for the table. 😉
Published on:
Learn moreRelated posts
Boost Reusability and Performance in Power Apps Controls Framework with Dependent Libraries
In this blog, we’ll explore how using dependent libraries can significantly improve maintainability, reusability, and performance in Power App...
Debunking: Dynamics CRM Destination – How Text Lookup Works
When we want to push data to Dataverse/Dynamics CRM using SSIS – KingswaySoft, usually there are relationships (lookup) that we need to ...
Understanding Activity Party Types in Dynamics 365 CE
Dynamics 365 Customer Engagement features 11 unique activity party types, identified by specific integer values in the ActivityParty.Participa...
Does Copilot help us write good expressions in Power Apps?
It is Friday and I thought to get the weekend started I try-out Copilot to generate an expression for me. When using Copilot it is so easy to ...
How to use the Azure AI Foundry connector in Power Apps
Yesterday I looked at how to use the Azure AI Foundry connector in Power Automate today I'm doing the same within Power Apps, creating a Q...
Power Apps – Edit new and existing tables in Plan designer
We are announcing the ability to edit new and existing tables in Plan designer, ensuring a seamless integration between the Plan designer and ...
The refresh token has expired due to inactivity when connecting to Power Pages using Power Apps CLI – Quick Fix
Hi Folks, This post is about a quick fix for an error occurred with Power Apps CLI. I was trying to connect to my organization using CLI and t...
Reimagining human-agent collaboration for a new era of app development with Microsoft Power Apps
Today, we’re announcing three major updates that bring the Microsoft Power Apps vision to life. The post Reimagining human-agent collaboration...
Power Apps – Makers can select from existing apps when using the plan designer
We are announcing the ability to select from existing apps when using the plan designer in Power Apps. This feature will reach general availab...