Result dropdown box is input in textbox

[Rogier45]

Hello

Im just starting to work with Power apps, so the knowledge is not so good. Im learning to build an power app.

Ive made already starting screen with 5 drop down boxes and these boxes are connected with the share point database.

Everything is working and all the information is working. The result dropbox 1 is input for the next box.

The formula is: Distinct(Filter(Input_database, Naam = DDleadoperator.Selected.Result), Ploeg) because you have to fill in five boxes

Only i want to make this automatically, so the result of dropbox 1 is input for the other 4 boxes.

[Prabhakar_S]

Hi @Rogier45 ,

If you want to create a Dropdown value dependent on the other dropdown, then try using the Cascading dropdown method. 

Please refer to this article:

PowerApps Cascading Dropdown (Detailed tutorial) - SPGuides

Create Cascading (Dependent) Dropdowns In Power Apps (matthewdevaney.com)

How to create Cascading (Dependent) Dropdowns in Power Apps - YouTube

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.

[Rogier45]

Hi @Prahhakar_S

Thanx for the help, but i have allready this in my power apps working. Im looking for different solution.

I  have a sharepoint data list with 5 columns,

Name: Person 1

Team: A

Line: 2

Cluster: BOW

Sub cluster:  Sub 3.

I want to fill in dropdown box "Name" the name of the person and automatic fill in the other boxes "Team:, Line:, Cluster:, Sub cluster:" Hope you wil help me a little bit further.

Rogier

[Prabhakar_S]

Hi @Rogier45 ,

You can achieve this by creating relationships between the dropdowns and using formulas to filter the options based on the selected values. 

• First Dropdown (Name):
  - Set the Items property of the first dropdown to the unique values from the "Name" column in your SharePoint list.

SharePointListName.'Name'

• Remaining Dropdowns:
  - For each of the remaining dropdowns (Team, Line, Cluster, Sub Cluster), set their Items property to filter the SharePoint list based on the selected value in the previous dropdown.

For example, Items property of the "Team" dropdown:

Filter(SharePointListName, Name = Dropdown1.Selected.Value).'Team'

Repeat this process for each subsequent dropdown, adjusting the column names accordingly.

Adjust the column names and SharePoint list references based on your actual data structure. This approach ensures that each dropdown is populated based on the selection in the previous dropdown, creating a cascading effect.

Thanks!!!

Please consider marking my response as the accepted solution if it successfully resolves your concern. If you found the information beneficial in other aspects, kindly express your appreciation by giving it a thumbs-up.