web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add multiple lookups i...

Power Apps

Answered

Add multiple lookups in filter condition

(0) Share

Report

Report

Posted on by subodhkant

126

Hi Community,

I am using a filter to records. The formula is below is:

Filter('Equipment Maintenance Task','Equipment Maintenance'.fvi_equipmentmaintenanceid=Gallery1.Selected.fvi_equipmentmaintenanceid&&

'Frequency Interval'.'Equipment Maintenance Frequency' = Gallery2.Selected.'Equipment Maintenance Frequency')

I want to pass multiple values to 'Frequency Interval'.'Equipment Maintenance Frequency' which is a lookup column.

As per images i want to filter 3rd gallery basesd on multiple selections from gallery 2 and single selection from gallery 1.

@WarrenBelz @RandyHayes

Screen Shot 2021-08-16 at 11.11.21 AM.png

Categories:

Building Power Apps

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@subodhkant

Please consider changing your Formula to the following:

Filter('Equipment Maintenance Task', 'Equipment Maintenance'.fvi_equipmentmaintenanceid = Gallery1.Selected.fvi_equipmentmaintenanceid && 'Frequency Interval'.'Equipment Maintenance Frequency' in Filter(Gallery2.AllItems, yourCheckBox.Value).'Equipment Maintenance Frequency' )

I hope this is helpful for you.
subodhkant 126 on at

Like
a
(1)

Report
Copy link

Link copied!

@RandyHayes Thanks for your help. You are a Hero.

Join the conversation