web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter lookup and titl...

Power Apps

Answered

Filter lookup and title column

(0) Share

Report

Report

Posted on by mikomarzado

5

I want to filter my list using lookup and title column. Below is the filter function that I created and working but I want to join them together. In order to check if there is an item that have an equal Title and Type of Job. By the way my lookup column has a multiple values.

!IsEmpty(
Filter(Choices('Job Type Questions'.'Type of Job'), Value = selectedJobTypeRecord)
)

!IsEmpty(
Filter('Job Type Questions', Title = "Walls")
)

I already tried this filter but if gives me a warning on the `=`
!IsEmpty(
Filter('Job Type Questions', Title = "Walls" && selectedJobTypeRecord = 'Type of Job'.Value)
)

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @mikomarzado :

Could you tell me :

What is selectedJobTypeRecord?Is it a string?

Does'Type of Job' allow multiple selections?

I assume selectedJobTypeRecord is a string and'Type of Job' allow mutiple selelctions.

The point is to use 'in' instead of '='.Please try this fromula:

!IsEmpty( Filter('Job Type Questions', Title = "Walls" && selectedJobTypeRecord in 'Type of Job'.Value) )

Best Regards,

Bof
mikomarzado 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying, I already fixed it the using the same formula. Also I manage to resolve the warning by saving the data into collection.

Join the conversation