Answered

Filter ComboBox based on another table with a lookup to a third table... with multiple values

(0) Share

Report

Posted on by grantreid

186

The syntax for this is doing my head in. I've been going through the forums, but haven't been able to find an example which fits this scenario.

A form has a card with a combo box - Choices([@'Exemption Details'].Approver). The goal is to filter this based on the chosen exemption A or B from another combobox - DataCardValue1.Selected.Value.

Exemption Details.Approver is a lookup to Approvers.
Approvers looks like:

The Type column is a lookup to another table with the two types A or B. There are a few cases where an approver can approve bother type A and B.

Every attempt I've made with filter just returns issues with comparing Table to text. I've had a go at using 'AsType' but can't get it right.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@grantreid

Do not force the type on the formula, this will lead to issues.

What are some of the formulas you have tried that seemed obvious in your mind, yet did not work?

In general, you will be filtering the Approvers list, not the Choices from the Exemption List.

In other words, you will want to filter the Approvers list to get the Types and then work your way back to using that to filter the other list.

I hope this is helpful for you.

Was this reply helpful? Yes No
Verified answer

grantreid 186 on at

Like
a
(0)

Report
Copy link

Link copied!

Finally figured it out:

Filter(Choices([@'Exemption Details_1'].Approver), Value in Filter([@Approvers_1], DataCardValue13.Selected.Value in Division.Value And DataCardValue1.Selected.Value in Type.Value And Active=true).Title)

Was this reply helpful? Yes No