How to add additional drop downs and functions based on a drop down selection?

[dblw]

Hello.

I am making an app in which the user selects possible accidents in the labour he is about to perform. Now there are 9 possible accidents selections and for each accident the user has to choose the severity of danger and the possibility of occurrence. Both of these have three different values you can select. I also have a text box in which the user explains how he is going to prevent accidents. I want this to work in following manner: User selects a possible accident in his labour and that selection opens up additional drop downs for severity and possibility with three options as well as a text box. Now the problem with this is that there are multiple accidents the user should be able to select and for each one of these selections there should be different severity and possibility levels as well as prevention. So i do not know how can I implement this into my app, because I am fairly new to power apps. Maybe with a multiple selection drop down? So is there a way to display these additional selections based on the values he selects in the accident box?

All help will be appreciated. 

[v-mengmli-msft · Accepted solution]

Hi @dblw ,

Can you provide me with more details about your requirement, such as your data source type, tables, and columns? It would be better if you could add some images.

I'm assuming that the data types you mentioned above all come from a SP list, and if you want to filter the values of drop-down option according to another drop-down, you can do this:

1) My table:

My Combo Box:

2)

//For the Items of Combo Box accident:
test08188.accident
//For the Items of Combo Box seriousness:
Filter(test08188,accident = ComboBox1.Selected.accident).seriousness
//For the Items of Combo Box possibility:
Filter(test08188,accident = ComboBox1.Selected.accident && seriousness =ComboBox2.Selected.seriousness ).possibility
//For the Visible of Combo Box seriousness:
!IsBlank(ComboBox1.Selected)
//For the Visible of Combo Box seriousness:
!IsBlank(ComboBox2.Selected)

Best regards,

Rimmon Li

[v-mengmli-msft]

Hi @dblw ,

How is the situation? Have you solved your problem? If my answer solves your problem, you can accept it as a solution to help more people trapped in this problem.

Best regards,

Rimmon Li