cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DavidW_c5
New Member

Filter using 'Choices' Dataverse column

Hello,

 

I've added a few filters to my entity list using the "Metadata Filter" functionality, which has worked great (attached). However, I have a column that does not appear as an attribute for selection in a dynamic picklist set or attribute filter set. I believe this is because it is a 'Choices' column, and not a 'Choice' column like the others.

 

I'm wondering if there's any way to add a filter that uses a Choices column to the Metadata Filter list? I see there is an option to use a FetchXML filter, but I have not been able to find documentation on how to pull a list of choices with FetchXML.

 

Thanks,

3 REPLIES 3
OOlashyn
Super User
Super User

Hi @DavidW_c5 ,

Yes, you are correct it is because of a Choices column (previously Multiselect OptionSet). I think fetchxml filter should work just fine as it allows for more complex statements and shouldn't be restricted. You cannot dynamically pull the list of choices you would need to write them all in your fetchxml statement. You would need to write each option in separate condition which should allow the portal to render it as an option (check the image on the old Adx Community forum on how it usually look for fetchxml filter). You can use Advance find or FetchXmlBuilder from XmlToolBox to build your query.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.

Hi @OOlashyn ,

 

Thanks for your reply, that link was helpful, and while I was able to get the example they posted (filtering for text in name) up and running, I cannot get the multi-select xml output to work. Using the FetchXML code:

<filter type="or">
  <condition attribute="cre06_category" operator="contain-values" uiname="option">
    <value>364060011</value>
  </condition>
</filter>

 

causes the entire filter box to show up blank. After some more research, I'm not confident this is supported.

Well, it might be that multi-select isn't supported in the entity list at all. This type of field is also not supported on the entity forms.

----------------------------------------------------
If you find this post helpful consider marking it as a solution to help others find it.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel News & Announcements 768460.png

What's New in the Community?

Check out the latest News & Events in the community!

MPP IDEAS updated 768x460.png

Ideas

Discover ideas and concepts from users like you for how to use Power Pages and take your work to the next level.

Users online (3,588)