Search Gallery using text and number fields

(1) Share

Report

Posted on by CU24081716-3

I am trying to set up a gallery search using text fields (Name & Age) and number field (ID which is a system column from a Sharepoint List). Age is a calculated field and has text content like this: "11 yrs 8 mos"

I have 2 search boxes, one for text (PTNameSearch) and one for number (PTIDSearch).

Here's my search logic: if PTNameSearch box is not blank, then search by Name & Age value else if PTIDSearch box is not blank then search by ID, else return all records.

If(!IsBlank(PTNameSearch.Value),
    Search(SortByColumns('EMR PT Demographics',"ID"), PTNameSearch.Value,'Patient Name', Age),
    If(!IsBlank(PTIDSearch.Value),
       Filter(SortByColumns('EMR PT Demographics',"ID"),Value(PTIDSearch.Value),ID),
    SortByColumns('EMR PT Demographics',"ID")))

The text search works fine, but the number search does not return a result.

What is wrong with my number search?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Suggested answer

MichaelFP 1,999 Moderator on at

Like (1)

Report
Copy link

Link copied!

The Search() is to find a string, that could be in any place of columns of type text. For numbers will not work. you need for that case to use Filter() to apply by Age.

Filter, Search, and LookUp functions - Power Platform | Microsoft Learn

Was this reply helpful? Yes No
CU24081716-3 on at

Like (1)

Report
Copy link

Link copied!

Thank you, Michael, for jumping in. The Age field here is Text. It is a calculated field from DOB field. Its content has this format "11 yrs 8 mos".

As shown below, searching by Age works just fine:

The problem I'm experiencing is the filter by ID: Filter(SortByColumns('EMR PT Demographics',"ID"),Value(PTIDSearch.Value),ID)

This Filter() statement isn't returning anything.

Was this reply helpful? Yes No
CU24081716-3 on at

Like (1)

Report
Copy link

Link copied!

I also removed the name search and use just the filter:

If(!IsBlank(PTIDSearch.Value),

Filter(SortByColumns('EMR PT Demographics',"ID"),Value(PTIDSearch.Value),ID),

SortByColumns('EMR PT Demographics',"ID"))

Still does not work! :-(

Was this reply helpful? Yes No
WarrenBelz 155,350 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!
Hi CU24081716-3

I thought I would throw in this idea
Search( SortByColumns( Filter( AddColumns( 'EMR PT Demographics', IDTxt, Text(ID) ), Len(PTIDSearch.Value) = 0 || PTIDSearch.Value in IDTxt ), "ID" ), PTNameSearch.Value, 'Patient Name', Age )

Was this reply helpful? Yes No
CU24081716-3 on at

Like (1)

Report
Copy link

Link copied!

Brilliant to use AddColumns, Warren! Your solution works! The only change I made is to replace the operator "in" in the Filter with "=". With the "in" operator, if I search for ID of 8, I would get records for ID = 8, 18, 28, etc. But with the "=" operator, the search is exact.

Thank you so much!

Was this reply helpful? Yes No