Filter value in lookup field is not working in a sharepoint list.

[YasarKhan1892]

Hi Friends, I have a lookup field in a sharePoint list. There is lot of values in the lookup. I am trying to filter the value in the lookup but its not filtering. Its just filtering by first word. I want to put filter by contain value. Like in below lookup I want to filter all the Delhi based branches.

[v-mengmli-msft]

Hi @YasarKhan1892 ,

Do you want to put the filtering result in Combo Box? If it is a Combo Box in above picture.
Could you tell me the code about filter and the items of Combo Box?

Best regards,

Rimmon Li

[AndrewR1]

Hi @YasarKhan1892 you could try using the in operator I have created a test application to see how this would be achieved and this worked for me when filtering a gallery: 

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. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

[YasarKhan1892]

This is not a combo box. Its a lookup field from another list. I have not added any code to put filter. I have only created lookup field and when I am trying to put filter it is filtering only for first word not for entire value.

[YasarKhan1892]

Hi Andrew, Where I need to put this code. I mean which property.

[AndrewR1]

Hi @YasarKhan1892 could you show us the code you have already for this field? Then I will be able to help you with writing it out to filter this? 

Thanks
Andrew

[YasarKhan1892]

 I have not added any code to put filter. I have only created lookup field and when I am trying to search a value in the lookup it is filtering only for first word not for entire value. Power apps is not filtering from entire value in the lookup.

[v-mengmli-msft · Accepted solution]

Hi @YasarKhan1892 ,

Do you mean it comes from a lookup column in data source? Then I think the content in the screenshot is part of the content in Form, and this form is connected to the data source which has a lookup column.

Does the items of the control looks like this?

If you just want to display the value that meets this condition 'Delhi based branches' in the drop -down option, please try this:

Set the Items of the control:

Filter(Choices([@Splist].LookUpColumnName),"Delhi" in Value)

Hope this helps you!

-----------------------------------------------------------------------------------------------------------------------------------

If my answer solves your problem, please accept it as a solution to help more people stuck on the same problem find it.

Best regards,

Rimmon Li

[AndrewR1]

Hi @YasarKhan1892 you can try doing this in the Items Property of the Lookup Field: 

The Cod ei used to do this is:

Filter(Choices([@Movies].LookUp),Self.SearchText in ThisItem.Title)

This is a more generic one for you you will need to replace the SP List and the Field you want to search off you could also just use Value at the end! 

Filter(Choices([@YourSPlIST].LookUpField),Self.SearchText in ThisItem.FieldtoBeSearched)

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. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.

Thanks
Andrew

[Marshal_Jerome]

1. Check the Fileds property set correctly.

2. Check any filter applied to the Data Source