Answered

How to set field default value based on another value

(0) Share

Report

Posted on by kyon84

Hi,

trying to set field default value based on another field value.

Got 2 sharepoint columns. Both choice. And I want if I choose in field (column A) value "USZ", then in another field (column B) will pop out "US01"

Thanks.

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

joeinmay 205 on at

Like
a
(1)

Report
Copy link

Link copied!

Workaround:
Insert a Button
Button -> OnSelect ->
ClearCollect(SPlist,{ChoiceA: "USZ",ChoiceB: "US01"},{ChoiceA: "USX",ChoiceB: "US02"},{ChoiceA: "USY",ChoiceB: "US03"})

Insert Dropdown "DP1"
DP1 -> Items -> SPlist.ChoiceA

Insert Dropdown "DP2"
DP2 -> Items -> SPlist.ChoiceB
DP2 -> Default -> LookUp(SPlist,ChoiceA=DP1.Selected.ChoiceA,ChoiceB)
Verified answer

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @kyon84 ,

Do you want to display a choice field value based on selection of another choice field?
Could you tell me:

1)what controls do you use to display these two fields?

2)whether these two choice columns allow multiple selections?

I assume that: you use drop down to display these two fields, these two choice field not allow multiple selections.

If so, you could set like this:

1)drop down1's Items:

Choices(list1.column A)

drop down1's OnSelect:

Reset(dropdown2)

2)drop down2's Items:

Choices(list1.column B)

drop down2's Default:

If( dropdown1.Selected.Value="USZ", "US01" )

Best regards,
rmodi 6 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,
How can we do this if dropdown 2 allows multiple selections and i want to set multiple values as default?
Thanks
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-yutliu-msft ,
I have the same issue but in model driven power app.
I would like to show a location based on selected postcode.
Could you please provide me with your solution?

Cheers,
mthompson 43 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, I have one choice column User Type and a managed metadata column Distro List, if
User Type = Employee then I want default value of Distro List to equal All Employees
User Type = External then I want default value of Distro List to equal External User
User Type = Guest then I want default value of Distro List to equal External User
Items for Distro List is Choices([@'User Account Request Form'].'Distro List')
Items for User Type is Choices([@'User Account Request Form'].'User Type')