Unanswered

Search a Number Column via Search Bar/Drop Down

(0) Share

Report

Posted on by gjbannister01

185

I have a gallery that is really just a bone structure right now, but I want to be able to either search a number column or have a dropdown. I created a dropdown that displays the numerical values in that column, however, it's not working. I presume it's because it is not a choice column. I did not create the datasource, so the title of the column is three words, and in the URL it is one, but it is pulling into power apps as three words. For example:

URL: TodayIsMonday

Power Apps: 'Today Is Monday'

I tried this formula:

Search(Filter(List, IsBlank (DD.Selected) || Column.Value = DD.Selected.Value), SearchBar.Text, "TodayIsMonday")

Any suggestions?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@gjbannister01 - I think what you're trying to say is that the "Display Name" of the column and the "Logical Name" of the column are different.

image ref: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators

I assume your data source is SharePoint? Could you confirm what the field type is for that field (e.g. Single Line Text, Number).

Was this reply helpful? Yes No
gjbannister01 185 on at

Like (0)

Report

That's correct. It is a number column.

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@gjbannister01 - the Search function expects a search string.

Given your column is a number data type, you will need to use the AddColumns function to create a "virtual" copy of that column but converted as text.

You can then run your search against that virtual column instead:

Search( AddColumns( 'Your Data', "_number_column_text", Text('Your Number Column') ), DD.Selected.Value, "_number_column_text" )

For a Text Input Box, simply replace DD.Selected.Value with:

Search( AddColumns( 'Your Data', "_number_column_text", Text('Your Number Column') ), 'Your Text Input Box'.Text, "_number_column_text" )

Was this reply helpful? Yes No