web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter table by anothe...

Power Apps

Unanswered

Filter table by another table

(0) Share

Report

Report

Posted on by kathy659

Hello,

I am currently filtering my main data source with a Share Point list, and it is filtering however there are some values in the main data source that have N/A and i don't want the filter to show the user those. How can i achieve that?

Filter looks like this:

Filter(DataSource, code in Options.Option)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@kathy659

I assume that code is the column that would have the N/A in it. If so, please consider changing your Formula to the following:

Filter(DataSource, code in Options.Option && !(code="N/A))

I hope this is helpful for you.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi@kathy659,

Based on the issue that you mentioned, do you want to filter your main data source based on some values within your SP list?

Could you please tell me that if "N/A" exists in a certain column?

Generally, we could only filter out records that do have some certain values in a single column because these functions like Filter() or LookUP expects a column to lock range.

So, I assume that "N/A" exists in a certain column, please try the formula as below.

Filter(DataSource, code in Options.Option && !("N/A" in ColumnName))

Hope it could help.

Regards,

Qi

Was this reply helpful? Yes No

Join the conversation