Filter Lookup

(0) Share

Report

Posted on by Dorinda

1,512

I have this formula and it works great except I need to to filter for the year 2022

If(IsEmpty(ComboBox2.Selected.Title), 
 Blank(), 
 LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName , ChairPerson.DisplayName )
)

I tried to add && 'Service Year'=2022 but that didnt work and I am not sure how to get this to work.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

fatjosh35 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try adding ".Value" after service year:

&& 'Service Year'.Value = 2022

What data type is the Service Year field?

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes and it gave me "False" as the return value not a name I was expecting.

Was this reply helpful? Yes No
fatjosh35 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Is service year a date field? a text field? or a number field?

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

Text

Was this reply helpful? Yes No
fatjosh35 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Try wrapping 2022 in double quotes then.

&& 'Service Year' = "2022"

Otherwise it would give you that false value since it's trying to compare a string (or text) to a number, which doesnt work.

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!
Yeah tried that and still got the false
If(IsEmpty(ComboBox2.Selected.Title), Blank(), LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName , ChairPerson.DisplayName && 'Service Year' = "2022" ))

Was this reply helpful? Yes No
fatjosh35 59 on at

Like
a
(0)

Report
Copy link

Link copied!
Try moving it into the second parameter of the LookUp() function. That's where the filter logic goes.
If(IsEmpty(ComboBox2.Selected.Title), Blank(), LookUp(ChairSurvey_1, 'Meeting Group'= ComboBox2.Selected.MeetingName && 'Service Year' = "2022", ChairPerson.DisplayName ))

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

Now I just get a "Blank" as the response.

Was this reply helpful? Yes No
fatjosh35 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Is ComboBox2 empty?

Was this reply helpful? Yes No
Dorinda 1,512 on at

Like
a
(0)

Report
Copy link

Link copied!

No, it has last years name in it that is why I need to filter it to this years name

Was this reply helpful? Yes No