Unanswered

Show lookup column in combobox and filter

(0) Share

Report

Posted on by Lars1990

Hi all,

I have two tables: Products and Delistings where Delistings contains a lookup column Product to table Products.

I would like to only show all products in a combobox which are in the Delisting table. This is possible using Choices like below. However I would like to further filter de products on DelistStatus. I cannot mannage to get it to work.

The data is from dataverse and it is build in PowerApps in Teams.

KR,

Lars

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

daruom 71 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

In view of the syntax, "DelistStatus" from the "Delisting" table is an "Options" type field?
If so, can you give the name of the option.

And if I understand correctly, you also have a "DelistStatus" field in the "Product" table?
If so, what is the type of this last field?
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Lars1990 ,

Please try below:

Filter(Choices(Delistings.Product), DelistStatus = 'DelistStatus(Product)'.In progress)

You are actually filtering the Product table, so the status column value should evaluate with the option-set that in Product table.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Lars1990 97 on at

Like
a
(0)

Report
Copy link

Link copied!

In view of the syntax, "DelistStatus" from the "Delisting" table is an "Options" type field?
If so, can you give the name of the option. Correct

And if I understand correctly, you also have a "DelistStatus" field in the "Product" table?
If so, what is the type of this last field? No, the field DelistStatus only exists in the Delistings table.
Lars1990 97 on at

Like
a
(0)

Report
Copy link

Link copied!

It does not work because I think it was not clear that the table product does not contain a column with DelistStatus only the Delistings table contains a column DelistStatus which is indeed an option set. Both tables however contain a column Product where the Product column in the Delistings table is a lookup from the Products table.