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
a
(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
a
(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
a
(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
a
(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