lookup function on combobox not working

(0) Share

Report

Posted on by MJ84

263

Hi all,

I have a combobox that I am using to select AD usernames to then patch to a sharepoint list.

The Items property is set to Distinct(Office365Users.SearchUser({searchTerm:ComboBox2_2.SearchText}).DisplayName,DisplayName)

The on change property is set to Patch('SPLIST',ThisItem,{Item1:ComboBox2_2.Selected.Result})

The above are working fine but on the default property I want the combobox to return the value that is written in the SP list. I've done a lookup but I think there might be an issue with the combobox expecting a table value?

Any help is welcome currently the default property has the following in this is working in a label which makes me think that the issue is unique to combobox:

LookUp('SPLIST',Text(Date,ShortDate)=Text(DatePickerCathedral_2.SelectedDate,ShortDate),Item1)

thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

JR-BejeweledOne 5,836 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
Try wrapping your lookup in [], like this:

[ LookUp('SPLIST',Text(Date,ShortDate)=Text(DatePickerCathedral_2.SelectedDate,ShortDate),Item1) ]

You may have to modify your lookup as well

[ LookUp('SPLIST',Text(Date,ShortDate)=Text(DatePickerCathedral_2.SelectedDate,ShortDate),Item1).SPColumnName ]

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately this does not work... I'm guessing because the lookup is returning an item and the combobox is looking for a table?

Maybe it isn't possible... ?

Was this reply helpful? Yes No
JR-BejeweledOne 5,836 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

Make sure you are putting this in the DefaultSelectedItems property.

Was this reply helpful? Yes No
MJ84 263 on at

Like
a
(0)

Report
Copy link

Link copied!

Excellent thank you I had it in the Default property 😀

Was this reply helpful? Yes No