Answered

Issues with default selected items on combo box

(0) Share

Report

Posted on by FGRODRIGUEZ

129

So, I have a main table, in this main table called tasks, in this main table I have a column named Employee, that is a LookUp type column, doing a lookup to a table called Employees, in this table I store, EmployeeName and other information on the employee.

Now, I have a combo box that im looking to do a patch with, this combo box need to be able to set its default selected item, based on a label, so for example if the label says "John Doe", I need the combo box to select the record for John Doe, I currently have this on the combo box

Items: Choices([@tasks].Employee)

DisplayFields: Value

DefaultSelectedItems: LookUp(employees, lblEmployee.Text = EmployeeName)

But it does not seem to select anything for its default, is there a way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

WarrenBelz 154,791 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @FGRODRIGUEZ ,

Your DefaultSelectedItems should be

{Value: lblEmployee.Text}

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps

1 people found this reply helpful.

Was this reply helpful? Yes No
QQY on at

Like (0)

Report
Copy link

Link copied!

hi @FGRODRIGUEZ

Try this

First(LookUp(employees, lblEmployee.Text = EmployeeName))

Was this reply helpful? Yes No
FGRODRIGUEZ 129 on at

Like (0)

Report
Copy link

Link copied!

This one gives the appearance of working, as it shows the correct name on the box, but when you actually complete the patch, the record is created with that column as blank instead of including the record for the employee

Was this reply helpful? Yes No
FGRODRIGUEZ 129 on at

Like (0)

Report
Copy link

Link copied!

This one indicates that the formula has some errors and says the data type is record.

Was this reply helpful? Yes No
WarrenBelz 154,791 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@FGRODRIGUEZ ,

What type of field are you writing back to ?

Was this reply helpful? Yes No
Verified answer

FGRODRIGUEZ 129 on at

Like (0)

Report
Copy link

Link copied!

I found the solution, in this case you need to setup the defaultselectitems as

Filter(Choices([@mainTable].Employee), Value = lblEmployee.Text)

and the items property of the combo box to Choices([@mainTable].Employee)

Was this reply helpful? Yes No