Unanswered

Need some help with Lookup Dropdown Selected

(0) Share

Report

Posted on by greddin

112

I've got a dropdown combo box in my Power App called "Location". On an edit screen I would like to set this dropdown default to the users current OfficeLocation value from the Office365USers connector.

I have a variable which contains the user's OfficeLocation value that is returned from the Office365Users connector.

varSelectedPersonValue.OfficeLocation contains the value text.

But the dropdown box is expecting a table. How can I do a lookup to set the default value to whatever the varSelectedPersonValue.OfficeLocation is?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

You haven't said what the Items property of this combo box is, so can't give any specific advice, but the long and short of it is you'll need to construct an object with the same schema as the table you're using as the combo box's Items property and use that in the Default property, or convert to a single item array in DefaultSelectedItems (depending on whether you have SelectMultiple set to false or true)

Was this reply helpful? Yes No
greddin 112 on at

Like (1)

Report

I ended up resolving my issue with the following formula:

LookUp(Choices('List Name'.ColumnName),Value="choice value here")

Thanks

Was this reply helpful? Yes No
WillPage 2,307 Super User 2025 Season 2 on at

Like (0)

Report

Perfect.

Was this reply helpful? Yes No