How to search numeric numbers

[Icha1288]

how do i change my code so i can seach number as "SN" on my text input? i can search name (text) but when i change the "{Name}" to SN, i cant find it and if i type "{SN}" it becomes error. 

SortByColumns(
Search(
Filter('database technician competence',
ddLoc.Selected.Value="All" || LOCATION=ddLoc.Selected.Value,
ddGrade.Selected.Value="All" || GRADE=ddGrade.Selected.Value
),
txtnama.Text,"{Name}"
),
"{Name}",
SortOrder.Ascending
)

[WarrenBelz]

Hi @Icha1288 ,

Something like this

SortByColumns(
   Search(
      AddColumns(
         Filter(
            'database technician competence',
            ddLoc.Selected.Value="All" || LOCATION=ddLoc.Selected.Value,
            ddGrade.Selected.Value="All" || GRADE=ddGrade.Selected.Value
         ),
         "SNText",
         Text(SN)
      )
      txtnama.Text,
      "SNText"
   ),
   "{Name}",
   SortOrder.Ascending
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications)   Visit my blog Practical Power Apps

[Icha1288]

sorry i mean, i have data of (SN) serial number and in my apps i need to be able to search by number, but all i can do now i search by name. but the number is already in my back end, and people dont need to input new number, just search by the SN

[WarrenBelz]

@Icha1288 ,

Sorry a bit lost here (and I also noticed SN is Text, so you do not need AddColumns). What exactly is '{Name}' as I cannot see it in your field list.

[Icha1288]

I'm sorry, english is not my primary language. 

So, i try to build this app that can update the checkbox according to their name and their SN (every name has their own SN - serial number) and with the code that i already have it can only search for their name, but not the SN (so it will be easier for the user to search the person number rather than the name). and another people tell me that search function can only be use to search text, but when i see my database which is sharepoint list, the SN is already single line of text. so, is there maybe another function i can use instead of "search"? or maybe a function so the box can search both name and SN.

[Icha1288]

oh sorry, the data is alrady full but i need to censor it because it's a real data, not a dummy. but all the data below is full of name, SN, etc. i just need to be able to search for number (SN). 

[Icha1288]

inside this app is a vertical gallery where i can filter and search for name. but i want to search for number too (everyone has their own number), so rather than search by alphabet, it's more easier to search by their own number. but the problem is, the search function can only use for text. so i cant seem to find the column number (the column number is "SN"). 

i know search function can only be use for text, but my "SN" is already "single line of text". so i dont know why i cant seem to find "SN"  (like the name on my database - i use sharepoint list). 

-------------------------------------

-------------------------------------

------------------------------------

is there any way to search for numerical numbers? or why i cant seem to find "SN" on search function?

[WarrenBelz]

@Icha1288 ,

What is the original column name ?

[NelsonYan · Accepted solution]

Hi @Icha1288 ,

Do you mean you can't find the column name of SN in powerapps Search expression?

Did you ever rename the column to SN? Powerapps only accepct its orginal column name.

If so, the original name can't found at the end of url of column setting in SharePoint list setting.

Thanks,

Nelson

[Icha1288]

omg yes, turns out it's name is "field_0". i thought i need to change the search function. Thank you so much