Unanswered

Simple Gallery has me stumped.

(0) Share

Report

Posted on by seanc1842

So have a table I'm wanting to search with a combobox. or text input if you can tell me how to get it to start showing close results in a drop down with startswith.

what i have in on my test screen.

a gallery, combobox, and a text label inside gallery.

I'm needing so that when I search for an ID number in the combox the app displays the corresponding info of that row in the gallery text label.

I've been messing with this, and I keep getting these errors.

Name isnt valid 'Value' is not recognized.

and

The function 'Value' has some invalid arguments.

In the combobox I have under Items = t_ID_AST.IDNumber

In the gallery I have under Items = Filter(t_ID_AST, IDNumber = Value(ComboBoxsearch.Selected.Value))

lastly, for the Text Label I have under Text = ThisItem.IDDate

thank you in advance for any help you can give.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi, try this:

Filter(t_ID_AST,
Or(
IsBlank(ComboBoxsearch.SelectedItems),
IsEmpty(ComboBoxsearch.SelectedItems),
IDNumber in ComboBoxsearch.SelectedItems
)
)

Was this reply helpful? Yes No
seanc1842 4 on at

Like (0)

Report
Copy link

Link copied!

the gallery control is not letting me assign a column with number data, is there a way around this

Was this reply helpful? Yes No
elseb 774 Moderator on at

Like (0)

Report
Copy link

Link copied!

you have number column in your sharepoint and you want to display it in gallery?

Was this reply helpful? Yes No
seanc1842 4 on at

Like (0)

Report
Copy link

Link copied!

im wanting to search a particular IDnumber and return those results in a gallery using text tags.

the app is connected to a sql database using table t_ID_AST
combobox is named ComboBoxsearch
the column name is IDnumber

Was this reply helpful? Yes No