cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SoSoDef276
Helper I
Helper I

Filter Gallary by Datacard

Hello, 

 

Looking for assistance on how to get the filter working in Dataverse. I could not adapt what I used in the Standard powerapp.

 

Here are the formulas I used; 

 

Filter(PRS,DataCardValue4.value= "No")

Filter('Resolved (PRS)'.value= "No")

Filter(PRS,'Resolved (PRS)'.value= "No")

 

SoSoDef276_0-1612701382328.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
dpoggemann
Super User
Super User

HI @SoSoDef276 ,

 

I just performed a test on the Account entity with the Send Marketing Materials.  Please see the Items formula for the Gallery on the right side with the filter.  This worked as expected and filtered with "Send" and "Do Not Send" .  This is defined as a "Yes/No" column in the Dataverse.

 

Screen Shot 2021-02-07 at 7.29.36 AM.pngScreen Shot 2021-02-07 at 7.28.47 AM.png

 

Hope this helps.

 

Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

6 REPLIES 6
dpoggemann
Super User
Super User

Hi @SoSoDef276 ,

 

Please see the following post as it provides you the details of what you are trying to do here.

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Filter-with-two-options-as-a-data-type/td-p/... 

 

Hope this helps!

 

Thanks,


Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Same issue unfortunately ; 

 

SoSoDef276_0-1612703101633.png

 

 

 

dpoggemann
Super User
Super User

Is this a "Yes/No" field or a "Choice" field in the Dataverse?

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew
dpoggemann
Super User
Super User

HI @SoSoDef276 ,

 

I just performed a test on the Account entity with the Send Marketing Materials.  Please see the Items formula for the Gallery on the right side with the filter.  This worked as expected and filtered with "Send" and "Do Not Send" .  This is defined as a "Yes/No" column in the Dataverse.

 

Screen Shot 2021-02-07 at 7.29.36 AM.pngScreen Shot 2021-02-07 at 7.28.47 AM.png

 

Hope this helps.

 

Thanks,

 

Drew

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

(PRS, Resolved = 'Resolved (PRS)'.No)

 

Thank you so much !!!

How can I go about using the formula you provided and adapting into a Radio Button, like in your example ?

Helpful resources

Announcements
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,651)