Dropdown default property - Expected Record Value error

(1) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

hi ,

I am trying to set a default in a dropdown based on another data card.

I am getting an error on this -

If(DataCardValue18.Text = "Louis" , "Pass", "Fail")

Why am I getting this error? The DataCard18 value is a lookup formula, not sure if that would affect it.

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

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

Like (1)

Report
@wonka1234 -

What is your data source (SharePoint, Dataverse, SQL etc)

Is that actually a Dropdown control, or a ComboBox control?

Could you share the LookUp formula used in DataCardValue18 (assume this is a TextInput control)

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (1)

Report

@Amik

Data Source is Sharepoint List.

The data im trying to populate actually is in a combo box!

Formula is -

LookUp([@'MASTER LIST'],'Job Title' = DataCardValue32_1.Selected.Value,'Team Name').

Which does populate the word "Louis" in Datacardvalue18.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (2)

Report
@wonka1234 - and what do you have in the Items property of that ComboBox? I assume its:

["Pass","Fail"]

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (1)

Report

The items property is actually -

Choices([@'List Two'].'Senior Managers'). Which is a sharepoint list dropdown of email addresses.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report

@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?

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (1)

Report

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, "")

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (1)

Report
@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: "" } )

Was this reply helpful? Yes No