Unanswered

Cascading Dropdowns

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi all,

Relatively new to Powerapps. I have created a connection in the Common Data Service with numerous tables, complete with relationships and default lookups set to the appropriate fields I want to return.

What I want to complete in Powerapps is a cascading dropdown from Table1 that the restricts the choices in Table2 as per Table1 selection and in turn Table3 is restricted by the choices in Table2. Each of the tables has a column titled Active so that not active records can be omitted.

I cannot seem to get the cascading dropdown to work with the choices function (only 2 display fields appear to be allowed) and also remove all inactive records.

Any help greatly appreciated - many thanks in advance!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Shanescows 2,218 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Anonymous I have a video on using Cascading Dropdowns in PowerApps. Is that what you are looking for? A getting started guide or do you have challenges with just a certain scenario?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Shanescows - I reviewed you video which was helpful however I believe the issue lies more with the Common Data Service whereas you are importing from Excel. Within the CDS I have built relationships with Foreign Keys etc. The CDS seems to only allow me to bring back a couple of fields from tables with the relationshipp which is causing the issue. It may be more of an issue with the CDS than anything else. I am struggling to understand what benefit the relationships are within CDS as you almost define each relationship anyway within Powerapps. This could just be my understanding as I have not used the CDS before, however there seem additional limitations to the data that is returned.

Was this reply helpful? Yes No
Shanescows 2,218 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Gotcha. I haven't played with CDS enough to be helpful it is behaving differently than other data sources. 😞 Sorry.

Was this reply helpful? Yes No
Madelman 4 on at

Like
a
(0)

Report
Copy link

Link copied!

I'm not sure about CDS but using an MSSQL Server i found the following to fix the issue of passing Forgien Keys.

https://powerusers.microsoft.com/t5/General-Discussion/Populate-dropdown-in-a-card-depending-on-the-data-in-the/td-p/25337/highlight/false/page/2

Also Thanks Shane for your videos. Definitely been a great learning tool, keep them up!

Was this reply helpful? Yes No