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
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,758)