Unanswered

Auto populate/fill text box based on another dropdown choice answer?

(0) Share

Report

Posted on by Evan_S1

341

I have a SharePoint list with a column named "Issue" formatted as a dropdown choice. If a particular "Issue" is selected I need another column named "Responsible" to autofill with who is responsible to handle the issue.

In Power Apps I have a form with both the "Issue" Dropdown and "Responsible" text box. Below gives an example of Issue choices and who is Responsible based on the Issue selected.

Issue Choices --> Responsible:

BOM Part Incorrect --> ORE

BOM Missing Part --> ORE

Missing Stock Part --> Logistics/Purchasing

Missing Job Part --> Logistics/Purchasing

Vendor Error --> Purchasing

Quality Issue --> Quality

Material Damage -->Quality

Material Missing --> Logistics

Testing Errors --> ORE

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Hi @Evan_S1

on your responsible box set its Items property to IssueDropdown.Selected
make sure to change the values to correspond to your titles

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure what the code would look like to have the "Responsible" field populate the answer based off of the selection in "Issue".

Issue Choices --> Responsible:
BOM Part Incorrect --> ORE
BOM Missing Part --> ORE
Missing Stock Part --> Logistics/Purchasing
Missing Job Part --> Logistics/Purchasing
Vendor Error --> Purchasing
Quality Issue --> Quality
Material Damage -->Quality
Material Missing --> Logistics
Testing Errors --> ORE

Was this reply helpful? Yes No
JohnM86 590 on at

Like (0)

Report
Copy link

Link copied!

So i my example, I have created a list with the columns Issues and Responsible in the responsible I have listed ORE and in issue BOM - then set the dropdown as list and value issues and in the second box which in your case would be txt

then in your text box Default set Dropdown.Selected.responsiblecolumn

Was this reply helpful? Yes No
Evan_S1 341 on at

Like (0)

Report
Copy link

Link copied!

I changed my "Responsible" Column in my SharePoint List to choices (ORE, Logistics, Quality, Purchasing, Logistics and Purchasing). This will allow the user to change the choice if needed. How would I format for Column choice "Issue" to auto fill the Column choice "Responsible" based on the Issue selection.

My drop downs are generated from a SharePoint List and have created a form within PowerApps. Would this change any of the codes/functions?

List name: 'Production Stoppage Report -DRAFT 1'
Column "Issue" choices
Column "Responsible"

Was this reply helpful? Yes No