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)

Sort by

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

Like
a
(1)

Report
Copy link

Link copied!
@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
a
(1)

Report
Copy link

Link copied!

@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,687 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!
@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
a
(1)

Report
Copy link

Link copied!

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,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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
a
(1)

Report
Copy link

Link copied!

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,687 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@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