Answered

Filtering gallery on view and choice at the same time

(0) Share

Report

Posted on by kranis

174

Filtering my gallery items based on a view works perfectly fine. But I also want, at the same time, filter the gallery on a particular choice value in Dataverse. This is how far I come now, but I´m getting an error here.

ClearCollect(
OpportunitiesHomeScreen,
Filter(Opportunities, 'Opportunities (Views)'.'My Latest Opportunities', If([@'Completed Stages'].'Completed')

);

Super thankful for help here!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kran ,

I did a test for you.

Add a dropdown control and set its Items property to:

Choices(TestL12.My_Choice)

Add a gallery control and set its Items property to:

Filter(TestL12, 'TestL12 (Views)'.'Active TestL12',My_Choice=Dropdown1.Selected.Value)

Or you could add a button control ,set its Onselect property to:

ClearCollect(OpportunitiesHomeScreen,Filter(TestL12,'TestL12 (Views)'.'Active TestL12',My_Choice=Dropdown1.Selected.Value))

Best Regards,

Wearsky

Was this reply helpful? Yes No
kranis 174 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xiaochen-msftBig thank you for your reply!!

Great! However, in my case, there is no dropdown for the user. I would prefer if there is an approach where I can filter My_Choice to a hard coded value. In your example "My_Choice ="a_c". But i´m getting an error here....

Ps. Sorry for my late reply - I had a busy week 😀

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Kran,

You could use text() function to hard code.

Filter(TestL12, 'TestL12 (Views)'.'Active TestL12', Text(My_Choice)="a_c")

Best Regards,

Wearsky

Was this reply helpful? Yes No