Unanswered

Nested Dropdowns in a Canvas App

(0) Share

Report

Posted on by Jjagerson

I feel like I'm missing something very simple.

I have built a model driven app, and am using the same data fields to build user-friendly forms in Canvas Apps.

All I want to do, is place one drop down that identifies locations, then another drop down that only lists associates assigned to that location.

Dropdown 1: 'Which PP Branch DD'
Table: 'Company Locations'
Item formula: Filter('Company Locations', 'Company Locations (Views)'.'Performance Personnel Locations')

Dropdown 2: 'Which Associate DD'
Table: 'Associate Info'
Item formula: Filter('Associate Info','PP Branch Assigned'= 'Which PP Branch DD'.Selected.Value)

What is the correct approach?

On a side note: I tried to assign the Associate Info table to the 'Which Associate DD' drop down in the Canvas Spp, but when I use the Depends On function, the key field I need, 'PP Branch Assigned' doesn't appear. I think it's because it is a lookup field and the other lookup fields in that table don't appear as an option either.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Bcoussens01 10 on at

Like (0)

Report

There are many ways to achieve the same outcome in a Canvas or Custom Page (in a MDA) this is the approach I use: which is very flexible and really is just like any other filter... When you select the first Option set a variable or attribute with he value. the second lookup should use an if statement that checks if this value is set, if its not... the Lookup is disabled, if true, then the value is used to filter the items returned in the second lookup. this model work well for me.

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (0)

Report
Hello,

I don't have exactly your business model. I used as an example 2 tables from Dataverse - Business Units and Users. So when in Dropdown1 I select a particular business unit the second dropdown should show only users that belong to the selected business unit. Here is the "Items" formula I used:

Filter( Users, 'Business Unit'.'Business Unit' = Dropdown1.Selected.'Business Unit' )

Was this reply helpful? Yes No
Bcoussens01 10 on at

Like (0)

Report

To confirm you filter works first use the same filter on a simple gallery to confirm the correct records are returned, if that works then apply the filter to the dropdown and If the issue persists then its not the filter its how you are implementing it on the dropdown, you can also tell the dropdown to use the gallery as the source so you can follow the steps along the way, much easier way to learn too.

Was this reply helpful? Yes No