Power Platform Community Forum Thread Details

Hi,

I have 2 SharePoint lists linked together with a lookup column.

The lookup column is of a calculated field thats concatenating 2 text fields and a choice field e.g. '[Customer]&[Name]&[ID]'.

The sharepoint list with the lookup column is using an integrated PowerApp. The field is working fine for the most part but if i paste the reference I'm looking for e.g. 'TescoDave123' into the field in the powerapp it won't find it in the drop down even though TescoDave123 is in the list.

But if i don't copy and paste and start typing 'TescoDave' a drop down list of all the values appears including the 'TescoDave123'. I then click it and it all works fine. While this seems like a trivial issue, if there are over 100 unique TescoDave...s then you have to scroll from TescoDave1 all the way to TescoDave123.

Other scenarios:

- Even when i type 'TescoDave12' nothing appears in the drop down to pick from

- sometimes, if i'm looking for 'AsdaScott100' i start typing 'Asda' and the list shows me all values containing this but as soon as i reach 'AsdaS' the dropdown list disappears.

- For some entries, it inexplicably just works normal if you paste the full 'AldiMatt150' it will find that single entry and appear in the dropdown.

Its very strange and frustrating for many users as they just want to paste the unique reference and pick it from the lookup dropdown list.

When I first encountered, I thought there were some hidden characters between the concatenated fields but this wasn't the case when checking them individually.

Anyone encountered any similar glitches in dropdown columns that are lookup columns of a live SharePoint list field within a power App?

Any help is appreciated.

Categories:

Building Power Apps