Auto populate text field based on dropdown selection

(0) Share

Report

Posted on by pinball2

Hi,

I have a dropdown with Choices type column in SharePoint list: represents the code for each center.

Then I have a text field where the center's manager name should be in.

I don't store any data of center's managers in the sharepoint list.

What I want to do is if user choose the code for Center A at the dropdown, I want to auto-populate Center A's manager name in the text field.

I was wondering if I have to store any data of the managers' names in the sharepoint list or whether it can be done much simple.

Any input will be appreciated, thank you s

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @pinball2 ,

If you have a few centre managers, you could easily manage this in the app. For example, apply the below to the Text property of a Label:

Switch( Dropdown1.Selected.Value, "Centre A", "Centre Manager Name A", "Centre B", "Centre Manager Name B" )

If you are expecting to have a more than a few dozen centre managers, it would be easier to develop and maintain this by storing the Centre Manager's in a separate list and then performing a Lookup.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
pinball2 80 on at

Like (0)

Report
Copy link

Link copied!

Hi, thank you so much!

I don't have text property -- the text box is in the form so maybe that's why?

Can I do that on 'Default' property?

Was this reply helpful? Yes No
Verified answer

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@pinball2 yes you can apply the same principle to the Default property of the Data Card Value.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No