web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery Filter Where D...

Power Apps

Unanswered

Gallery Filter Where DropDown Option Doesn't Match SharePoint List Value

(1) Share

Report

Report

Posted on by s_tanswell84 Microsoft Employee

Hi!

I have a SharePoint List called "Customers". In it there is a Choice column called "Licenses". The options are "AC" or "BD".

I have a PowerApp with a Gallery connected to the SharePoint list. I also have a Dropdown box with the following options"

- All Records

- AC Licenses

When "AC Licenses" are selected in the Dropdown Box, I want the Gallery to Filter to only show those records with AC in the Licenses column. I have tried the below code in the Items property but PowerApps doesn't like the = in "Licenses = "AC".

Can anyone help?

If(

Dropdown1.Selected.Value = "AB Licenses",

Filter('Customers', License = "AB"),

'Law Firm Customers'

)

TIA!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Ami K 15,689 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@s_tanswell84 - assuming the "Licenses" Choice field has been configured to single-select in your list, try:

Filter( Customers, Dropdown1.Selected.Value <> "AC Licenses" || Licenses.Value = "AB" )

Was this reply helpful? Yes No

Join the conversation