Answered

Filter sintax with multiple conditions

(0) Share

Report

Posted on by matteodurini

Hi, i'm approaching powerapp, i'm quiet new 😉

I'm trying to edit a sharepoint list edit screen to add some logic. I have a lookup field and i was able to filter it with the following code

Filter(
Choices([@Associations].AssociatedTo),
Value in Filter(
Objects,
Active
).'Display Name'
)

These are the lists "involved" in the next filter criteria that i would like to introduce

Locations
Objects (list of users with the refence of the location)
DDI (list of DDIs with the reference of the location)
Associations (list of phone numbers with the reference of DDI and Objects)

I would like to show only the users based on the same location of the DDI related to the phone number. how can i do it? thank you in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Sort by

Verified answer

JohnM86 590 on at

Like
a
(1)

Report
Copy link

Link copied!

To show only the users based on the same location of the DDI related to the phone number in the SharePoint list edit screen, you can use the following formula to filter the Objects list based on the selected DDI value:

Filter( Objects, Location.Value = LookUp(DDI, ID = Association_DDI.Value).Location.Value )

Here, Location and Association_DDI are the names of the lookup columns in the Objects and Associations lists respectively, that reference the Locations and DDI lists.
The formula uses the LookUp function to find the DDI record that matches the selected Association_DDI value in the Associations list, and then retrieves its Location value. The Filter function then uses this value to filter the Objects list and show only the records that have a matching Location value.
You can replace the existing formula in the Choices function for the lookup field with the new formula above, like this:

Filter( Choices([@Associations].AssociatedTo), Value in Filter( Objects, Location.Value = LookUp(DDI, ID = Association_DDI.Value).Location.Value ).'Display Name' )

This should filter the AssociatedTo lookup field to show only the Objects records that have the same Location value as the selected DDI value in the Associations list.
I hope this helps! Let me know if you have any further questions.

Was this reply helpful? Yes No
Verified answer

matteodurini 12 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JohnM86 , thank you for your suggestion

this is the code that worked at the end 😉

Filter(
Choices([@Associations].AssociatedTo),
Value in Filter(
Objects,
Active,
Location.Value = LookUp(DDI,
ID = DataCardValue2.Selected.Id
).Location.Value
).'Display Name'
)

Was this reply helpful? Yes No