Answered

Search Gallery in both String and numberic fields

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am trying to search a gallery in two fields, a string and numeric. While I can search in the string field, I am unable to add the numeric fields. (I am trying to search on the ID column).

My Gallery Itmes is like:

SortByColumns(
 Search(
Filter(.............)

 ),
 TextInput1.Text,
 "Client"
 ),
 "Case_x0020_Id",
 Descending
)

I tried "Client",Text(ID) but I got an error.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@Anonymous

You can only search text fields, so you might want to change your formula to the following:

SortByColumns( Search(
AddColumns(Filter(.............), "IDtxt", Text(ID)), TextInput1.Text, "Client",
"IDtxt" ), "Case_x0020_Id", Descending )

I am not sure if you meant you were wanting to search "Case_x0020_Id" or ID as you mentioned in the question.

If it's ID, then this will work for you. If it is "Case Id", then just substitute "Case_x0020_Id" for ID in the formula.

I hope this helps you.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

@RandyHayes Thank you for that solution. That worked with the gallery but it broke other items like forms with item as: Gallery1.selected and a few Patch formulas.
The error is: Invalid Formula. Expected a value compatible with 'Datasource'.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

Yes, this would be the case. The reason is, when you change your Items property of a Gallery (or collection) to include new columns (or remove them), any forms will have an issue with the Item that they use from that source - because (in this case) there is now a new column.

The workaround for that is to Drop the extra column on your Item property of the Form - similiar to recent posting here.

Basically you will need this formula for your Item property on the Form:

First(DropColumns(Table(yourGalleryName.Selected), "IDtxt"))

That will drop the extra column you use and will give the Form the correct signature it is looking for.

Hope that helps out.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Thank you @RandyHayes . That worked like a charm!

Was this reply helpful? Yes No