I need a dropdown to populate different values based on a radio button selection

(0) Share

Report

Posted on by ChrisSullivan

101

I have radio button Yes, No, Partial

I have 2 data cards that are visible when you select Yes, or Partial.

DataCard1 = text input

DataCard2 = (SharePoint Choice column) dropdown (Choice1, Choice2, Unknown)

When "No" is selected I want to have the Text Datacard1 populate as "" and DataCard2 to Populate to "Unknown"

The code I have for the Default of DataCard1 works great

If(
 rdoHardCopy.Selected.Value = "Partial",
 ThisItem.'Provide location',
 If(
 rdoHardCopy.Selected.Value = "Yes",
 ThisItem.'Provide location',
 ""
 )
)

But I cant seem to figure out how to do the same with the dropdown in DataCard2

Screenshot 2021-05-14 173801.png

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ChrisSullivan Replace the string "Unkown" with LookUp(Choices([@yourSPListName].yourChoicesColumnName), Value="Unknown")
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ChrisSullivan,

Do you want to set the default value of the DataCard2 as "Unknown" based on Radio selected value?

Could you please tell me that if the DataCard2 has a Combo Box or a Dropdown?

If it is a Combo Box, set the DefaultSelectedItems property as below:

If( rdoHardCopy.Selected.Value = "No", {Value: "Unknown"}, ThisItem.'Provide location' )

If it is a Dropdown, set the Default property as below:

If( rdoHardCopy.Selected.Value = "No", "Unknown",ThisItem.'Provide location'.Value )

Hope it could help you.

Regards,

Qi
ChrisSullivan 101 on at

Like
a
(0)

Report
Copy link

Link copied!
If( rdoHardCopy.SelectedText.Value = "No", LookUp( Choices([@'INITIAL QUESTIONNAIRE_1'].'Provide Data type'), Value = "Unknown" ), Parent.Default )
This worked! Thanks CNT
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@ChrisSullivan Glad to help! 😊

Please remember to give a 👍 and accept the solution as it will be help others in the future.