Unanswered

Seach doesnt like "Dates", "Name Look Ups" and "Dropdown" box values in DataTable

(0) Share

Report

Posted on by StuartSmith

225

I have a canvas with a data table with "Date", "First Name", "Second Name", "Company", "Host" and "Visiting Site". I also have a "Text Input" box working as a "Search" Criteria box. The Search works great for the "Single Line Values" such as "First Name", "Second Name" & "Company", but as soon as I add "Date", "Host (name lookup)" or "Visiting Site (dropdown value)", the search wont work.

The code for the DataTables items value is: Search('Visitor Details',SearchBox.Text, "Company","First_x0020_Name","Second_x0020_Name","Car_x0020_Reg")

Why wont the search work with data, host and visiting site? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@StuartSmith
There's a pretty good post by @Jeff_Thorpe which explains why searching dates and lookups is not the best approach. Sharepoint date and lookup columns are not delegable so after 500 records (or 2000 records if you've changed the advanced setting) the search will end and you'll be missing results.

Suggest your read the post first and decide whether the other options Jeff explains will work better for you:
https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/SharePoint-Lists-Powerapps-won-t-search-quot-Choice-quot-Field/td-p/104473

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @StuartSmith

The Search function only works with Simple data types
Complex data types - lookups, choice, etc. will not work

Replace the Search function with Filter function
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-filter-lookup

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
StuartSmith 225 on at

Like (0)

Report
Copy link

Link copied!

Thanks, whilst I am trying to figure out getting "Dates", "Name LookUps" and "DropDown" Values filtered, is there an "And Or" feature as would like to search on either a single or multiple values such either "First Name" or "Second Name" or even "First Name" & "Second Name".

I currently have: Filter('Visitor Details', StartsWith('First Name', Search_First_Name.Text), 'Second Name'in Search_Second_Name.Text)

But it will only display results if both values in "Search_First_Name.Text" & "Search_Second_Name.Text" are met, but would be nice if i could have something like...

Filter('Visitor Details', StartsWith('First Name', Search_First_Name.Text) AND/OR ('Second Name'in Search_Second_Name.Text)

Is this possible?

Was this reply helpful? Yes No