web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to get gallery to ...

Power Apps

Answered

How to get gallery to show data based on 2 dropdown choices

(0) Share

Report

Report

Posted on by kbell3

7

Hi,

I am trying to make a simple PowerApp which shows filtered content from a SharePoint list.

The App has 2 dropdowns where users can select data from 2 choice columns in SharePoint (this is working).

The app should then return filtered data based on the choices that have been selected in the dropdowns i.e return all list items which contain both dropdown selections. (I don't know how to do this bit but I assume I need the correct code for the Gallery 'Items' element.)

Can anyone offer any advice?

The

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @kbell3

Please try this:

Filter('SP list',<Choice1columnname>.Value = ComboBox1.Selected.Value , <Choice2columnname>.Value = ComboBox2.Selected.Value)

just replace <Choicecolumnname> to column name of two choices columns.
Best regards,
Sik
If this post helps, then please click on “Accept as Solution” to help the other members find it more quickly.

Was this reply helpful? Yes No

Join the conversation