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
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (4,064)