Answered

Filter dropdown value comparing two columns in same SP list

(0) Share

Report

Posted on by PowerTegga

Hi.

I'm trying to filter Items in a dropdown:

I want to show all the items where ID is not present in Hovedkategori-ID. In this case I don't want items with ID 1 and 2 to show.

How do I do this? I thought maybe this would work, but obviously not (i also tried with "=" instead for "in":

Filter(Kategori, Not(ThisItem.ID in 'Hovedkategori-ID')

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!
@PowerTegga
I think your answer was very close to solving it. Here's my solution.

Filter(Kategori, !(ID in Kategori.'Hovedkategori-ID'))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
PowerTegga 77 on at

Like (0)

Report
Copy link

Link copied!

Ahh, so close 😆

It works now. Thank you, @mdevaney

Was this reply helpful? Yes No
diyeralexander 7 on at

Like (0)

Report
Copy link

Link copied!

please help me i need something similar

I have the following formula:
Filter(Parqueaderos; ! ('N. Parqueadero' in Distinct(Filter(Reservas;FechaReserva=DataCardValue10.SelectedDate);'N Parqueadero'));'N. Parqueadero')

from the following data source

I need to obtain the list of all the parking spaces except what is in the record of the other table by date, apparently the formula that I put works but it does not show me the label, what can it be?

Was this reply helpful? Yes No