hi ,
I am trying to set a default in a dropdown based on another data card.
I am getting an error on this -
@wonka1234 - assuming you're not actually trying to return gmail accounts, on the DefaultSelectedItems property of that ComboBox, use:
With(
{
_get_email: Switch(
DataCardValue18.Text,
"Louis",
"Louis.Stevens@yourcompany.com",
"Red",
"Ren.Stevens@yourcompany.com"
)
},
{
Claims: "i:0#.f|membership|" & _get_email,
Department: "",
DisplayName: "",
Email: _get_email,
JobTitle: "",
Picture: ""
}
)
Sorry I made a mistake,
I want the if statement like so -
If(DataCardValue18.Text = "Louis" , "Louis.Stevens@gmail.com", If(DataCardValue18.Text = "Ren", "Ren.Stevens@gmail.com, "")
@wonka1234 - sorry I am no longer following what you're trying to do.
As I understand it, you want the ComboBox to default to "pass" or "fail", but you have set up the Items property of that ComboBox to return different values?
The items property is actually -
@wonka1234 - and what do you have in the Items property of that ComboBox? I assume its:
["Pass","Fail"]
Data Source is Sharepoint List.
The data im trying to populate actually is in a combo box!
Formula is -
WarrenBelz
146,658
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,999
Most Valuable Professional