search numeric field

[oria]

Hello,

I'm trying to filter my view using the facility_id but everytime i use the filter function, it doesnt work when i try to search for a facility id in the play screen. Here is the function i'm using:

Filter('[dbo].[Spectulative]',Value(TextSearchBox1.Text)=FACILITY_ID)

Am i supposed to be changing something elsewhere? Please help

[v-yuxima-msft]

Hi @oria,

What is your data source? Is it sql table?

Do you set FACILITY_ID int type or not?

I test as your formula expression and there is no issue here:

Filter('[dbo].[Spectulative]', Value(TextInput1.Text) = FACILITY_ID)

If that is not ok on your side you can create one new to test and change the formula to this to test:

Filter('[dbo].[Spectulative]', TextInput1.Text in FACILITY_ID)

I test as next:

Data Source(sql server):

App Test1:

Gallery.Items: Filter('[dbo].[Spectulative]', Value(TextInput1.Text) = FACILITY_ID)

Result:

App Test2:

Gallery.Items:Filter('[dbo].[Spectulative]', TextInput1.Text in FACILITY_ID)

Result test:

Hope this can be helpful.

Best Regards.

Yumia