Searching a lookup field in Gallery using the Search Text Box

(0) Share

Report

Posted on by Lasherza

356

Hi Pro's

Been struggling to be able to use the search function on a gallery which references a lookup field.

@RandyHayes you basically solved this for me in terms of searching the whole string of text elsewhere in the app using :

ForAll(Choices(yourList.yourLookupColumn), {Id: Id, Value: Value})

I hope you can provide close to the solution in terms of searching on the gallery ? I placed that above in the gallery ITEMS field but the output was not what i expected although it took it..it returned some wierdness.

Ultimately again i need to search with the site name to return the gallery item related to the site name.

Items property of the gallery was OOB and works in returning data but i suspect not correct for my purpose.

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

The formula for the Items property is like this: Search ( YourTable, SearchTextInput.Text, "column_logicalname" )

Was this reply helpful? Yes No
Lasherza 356 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks but not exactly what im trying to achieve... Sorry i think i may have moved the goalposts here..
I've now added a ComboBox - using the Search functionality within from @RandyHayes ..
ForAll(Choices(yourList.yourLookupColumn), {Id: Id, Value: Value})
Im now trying to use this tied to my gallery to filter...

Currently in Items property on Gallery i have:
Filter('Vandalism and Insurance List','Submitted to Finance'.Value=Dropdown2.SelectedText.Value || Dropdown2.Selected.Value=Blank() && Site.Value=ComboBox2.Selected.Value)
Combo Box not Filtering though.....

Hope i haven't confused this too much....
Thanks.

Was this reply helpful? Yes No
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Check your combobox to see if it allows for multiple selections. If it does, you cannot use Selected.Value.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Lasherza

The problem is that your formula is not providing the level of precedence for your AND's and OR's.

You need to provide a clearer separation so that the formula works as intended.

Please consider changing your Formula to the following:

Filter('Vandalism and Insurance List', ('Submitted to Finance'.Value=Dropdown2.Selected.Value || IsBlank(Dropdown2.Selected.Value)) && Site.Value=ComboBox2.Selected.Value )

This will ensure that the OR is between the two conditions first, and then it is all AND'ed with the next result.

Also, you had SelectedText in your formula...avoid using that property as it is listed as deprecated.

I hope this is helpful for you.

Was this reply helpful? Yes No
Lasherza 356 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @RandyHayes that pretty much is it.. Just one issue ... When the Site ComboBox filter is "empty" it should bring back all sites where = to the second filter of Submitted to finance? Which it is not doing..

Was this reply helpful? Yes No