Search on Both Integer & String at a time on Gallery

(0) Share

Report

Posted on by nejhade

Hello Fav People,

I have one gallery item has value : below where just Request Id is integer and rest are string.

My concern is. there is only one textInput where user enter value for search i.e either on Requester_ID(str), Request_status(str),

First_approver_id(str), Second_approver_id(str). With above code I am able achieve this user entering text value , code is able to search all text value.

Now I want in the same text box user enter request_ID= 45 (int) it should sort gallery on request_id too. The way it is doing it for others field.

Is this possible with the same code above?

I don't want to create separate texbox for Request_ID. if created also what to write on Gallery?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

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

Like (0)

Report

Hi,

Your code seems ok, Is it giving you any trouble? Lets say you have a record ID 45 and you have another record with ID 86 but with approver ID 45, both records will show when you enter 45 in the search box.

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report

@nejhade

I note the reference to SQL in your formula - I assume the data source of your app is SQL Server?

The issue with the Search function is that it searches against text fields only. If Requestor_ID is an int column, this explains why you're unable to search against that column.

The solution to this this to create a SQL View that casts Requestor_ID to the data type varchar (or any other string type). If you then reference the view rather than the table, you'll be able to use your formula to search against Requestor_ID.

Was this reply helpful? Yes No
nejhade 80 on at

Like (0)

Report

I can achieve this through creating collection too where I can convert request_Id to string but the log table where I need to apply search is too big. I can't affort to create collection every time of that big table. Same with View.
suggest me this : If I create one more text box where it will take integer value. i.e REquest Id how will I modify the code of gallery to change on both the textbox.
1st textbox: Accept integer
2nd box : Accept str
Gallery should apply search from both the boxes.
how to write that code.

Was this reply helpful? Yes No
timl 36,415 Super User 2025 Season 2 on at

Like (0)

Report
@nejhade

A SQL view is the best way and most efficient way to do this. Because it is server based, it does not have the same performance impact as a local collection.

If you want to implement 2 textboxes, you would modify the filter part of your original formula like so:

Filter('YourTable', SERVICE_TYPE="SQL" && (REQUESTOR_ID = Value(textBoxRequestor.text) || IsBlank(textBoxRequestor.text) ) )

Was this reply helpful? Yes No