Category Table Missing from Dataverse ?

[Chris1969]

The online documentation article Use the Category entity covers a Category table which could presumably be very useful for tagging / labeling records with user-defined labels (e.g., Red, Green, Blue .... Happy, Neutral, Sad ....).

However, as shown by the attached screen shot, such a table does not appear in the unfiltered, full list of tables in Dataverse.

Could someone please help me understand where to find the Category table ?

[ChrisPiasecki]

Hi @Chris1969,

Not all Tables will be displayable in the PowerApps maker UI, I believe Category is one of those special ones. It's used for Categorized Search (also called multi-table Quick Find) . You configure the categories in Settings > Administration > System Settings.

Note that you can only have either Relevance Search or Categorized search at the same time, not both. Relevance Search is the more modern powerful search mechanism, so it's recommended to use that over Categorized Search.

More details around search at the references below :

https://docs.microsoft.com/en-us/powerapps/user/search

https://docs.microsoft.com/en-us/powerapps/user/quick-find#multiple-table-quick-find-categorized-sea...

https://docs.microsoft.com/en-us/power-platform/admin/configure-relevance-search-organization

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Chris1969]

@ChrisPiasecki,

Thank you very much. Regarding ...

"You configure the categories in Settings > Administration > System Settings"

... since many screens have a Settings option, could you please confirm from which starting point you began (I have been unable to find the System Settings).

For example, starting from the Power Platform Admin Center (Environments > [environment name] > Settings), doesn't appear correct, but I'm not sure where to look?

[ChrisPiasecki · Accepted solution]

Hi @Chris1969,

Sorry about that. Here's the navigation steps:

• From the Power Apps Maker portal, select your environment
• Select the gear icon top right > Advanced Settings. This opens up a new tab to the legacy Dynamics 365 UI. 
• In the top navigation bar, click the down arrow next to Settings. Under System, select Administration.
• On the Administration page, click System Settings. This pops up a dialog.
• Under the General tab, scroll down until you see a Set up Search section. Finally, Select Entities for Categorized Search.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

[Chris1969]

@ChrisPiasecki, that's perfect & very clear, thank you very much !