display data in a form based on output from combobox

(0) Share

Report

Posted on by mrleetyler

270

hi all,

I have a ComboBox and I want the ability to display the Data in a display form based on the selected data.

The data in the combobox will only ever appear once but will ALWAYS appear in the table.

i'm trying the below on the "Items" on the form but doesn't work.

filter(LFTable, Name = ComboBox2.selected.Name)

*i don't have multiple selected on the combobox there will only ever be 1 thing selected*

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report
Hi @mrleetyler ,

Apart from the capitalization, as long as your Combo Box Items is based on the field Name (not a good title for a field as it is a Reserved Word), this should work in the Items of a gallery

Filter( LFTable, Name = ComboBox2.Selected.Name )

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.

Was this reply helpful? Yes No
mrleetyler 270 on at

Like (0)

Report

thanks WarrenBelz i have tried this and get error "Expected Record Value"

if it's revelant the data is being pulled from a static Excel datasource.

Was this reply helpful? Yes No
flugaoveltem 217 on at

Like (0)

Report

Have you try:
Filter(LFTable, Name = ComboBox2.selected.Value)

On Items propertie on LFTable

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (1)

Report
@mrleetyler ,

Yes - I noticed you mentioned form (my reference was for a gallery). You need

LookUp( LFTable, Name = ComboBox2.Selected.Name )

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.

Was this reply helpful? Yes No
mrleetyler 270 on at

Like (0)

Report

getting closer for sure!!
no red lines or errors but no results just implies it's not connected to data

Item properties from Form:
Item detail for Display Form

Datasource Properties from Form
DataSource detail for Display form

"Supplier" combobox is combobox2. has something selected but implies it's not connected to anything

combobox has data selected and doesn't reflect into form

Was this reply helpful? Yes No
WarrenBelz 153,079 Most Valuable Professional on at

Like (0)

Report

@mrleetyler ,

It appears you may have a second form below - you have shown the DataSource on the upper area as being your table (which is correct) and if you are getting no errors on the Item, then all that is left is whether the filter actually produces a matching record. The form also seems to be displaying data.

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.

Was this reply helpful? Yes No
Verified answer

mrleetyler 270 on at

Like (0)

Report

managed to resolve the problem by using a datatable and the same formulas. using a form view didn't seem compatible with an Excel or Collection. so Datatable worked fine

Was this reply helpful? Yes No