Unanswered

cascading dropdown based on many variables

(0) Share

Report

Posted on by fomenter

Hello,

I am trying to create an app for my engineering economy students. There will be 4 drop downs. The first one will indicate the percentage (from 0.5% to 50%). The second dropbox will have 8 different economic choices. The third one will look at the "number of years" (25 different choices). Based on all these different variables, I want app to extract/populate/give me the precalculated figure. (Please see attachment)

I had a chance to build a few very basic apps, but this one seems to be out of my scope. Can somebody guide me?

Appendix_C_CITabl...

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

PeterDonohue 162 on at

Like
a
(0)

Report
Copy link

Link copied!

You 'could' put all those values into code creating large tables within your app, or you could store those in sharepoint lists / database and then reference them.

Once you have your data stored somewhere that is accessible, it should be as simple as using a filter/lookup combination to populate the dropdowns dynamically

Was this reply helpful? Yes No
fomenter 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I guess the point that I am having a problem with is the last dropdown box. How would I connect from a dropdown list to a text box which would give me the answer (based on my selection of economic expression to the final value)?

I attached two files for you to view the files. Thank you for your help

Was this reply helpful? Yes No
PeterDonohue 162 on at

Like
a
(0)

Report
Copy link

Link copied!
It will be something like:

Lookup( PowerAppList, year = Dropdown1.Selected.Value && interest = Dropdown2.Selected.Value && econ =. Dropdown3.Selected.Value, finalvalue )

After selected there is an attribute Value - this will depend on the data type, it may be text etc

Was this reply helpful? Yes No