how to write combobox's defaultselectitem

(0) Share

Report

Posted on by Bingqiling

321

table name	maintable	subtable
column name	product_name (choice type)	asset_name (product_name's search type)
column name	ID	ID
column name	serial_no

I have two tables in sp, product_name and asset_name connected. And I need to find serial_no of mainable.
The common column of the two tables is product_name, but there are many data with the same record. So, I use the combo box to add to the item attribute
'Filter(maintable, product_name = Gallery.Selected.asset_name.Value )'

I put in. The result was 9 records with the same product_name in the mainable. And among these, I have to return the record with the same id again. That item attribute value contains all the columns and data in the mainable, so I think I can find serial_no. I don't know how. Help me

Categories:

Building Power Apps

All responses (1)

Answers (0)

Bingqiling 321 on at

Like
a
(0)

Report
Copy link

Link copied!
Writing this code returns the first record... I need an id value or serial_no linked to that asset_name.
And I don't use form.
LookUp( maintable, ID = LookUp(maintable, product_name = Gallery.Selected.asset_name.Value).ID )