Unanswered

Mind blow Error in Filter Gallery... 2 Lists 1 Lookup column

(0) Share

Report

Posted on by ImMitso

Hello everyone this error is haunting me and I’m not getting over it, is it possible? Can anyone help?

I have 2 lists: LugaresDisponiveis and Reservas

On LugaresDisponiveis i have a column ID_LUGAR Type Number
On Reservas i have Lugar_Reservado Type LookUp pointed to ID_LUGAR

I want to make a filter in the gallery in which only show the slots that are free on that selected date in the datepicker.

I Will upload some prints to show what i have and if someone find my error...

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ImMitso ,

Firstly can you please remember to post code also in Text - saves re-typing and spelling errors this end. Lookup columns (which are better not used with Power Apps anyway) return a Text value, so try this

Filter( LugaresDisponiveis, ID_LUGAR <> Value( LookUp( Réservas, Data_Reserva = DatePickerl.SelectedDate && Disponivel = "1” ).Lugar_Reservado.Value ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps
ImMitso 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @WarrenBelz
First of all sorry for the code situation, I’ll be more careful for the next!
I tried your code, but still the result is the same...

Filter( LugaresDisponiveis, ID_LUGAR <> Value( LookUp( Reservas, Data_Reserva = DatePicker1.SelectedDate && Disponivel = "1" ).Lugar_Reservado.Value ) )

In Sharepoint has the "Lugar_Reservado = 2 " should not appear in the gallery as the "Lugar_Reservado = 1 "
WarrenBelz 156,526 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@ImMitso ,

There are no errors shown in that code - I also do not understand your reference "1" and "2".