ShowColumns with a lookup column

(0) Share

Report

Posted on by nick9one1

297

I'm trying to improve the speed of an app. I want to use "showcolumns" as most of the tables only have a few relevant columns that I need.

I cant seem to filter on a relationship column? Is there a solution for this?

ClearCollect(col_PMMS_Site_Items,Filter(ShowColumns(PMMS_Site_Items,"cr20b_site","cr20b_PMMS_Sites"),PMMS_Sites.ID = selectedSite));

Categories:

Microsoft Dataverse

I have the same question (0)

All responses (1)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Re: ShowColumns with a lookup column

Hello, @nick9one1, I am assuming that your issue is the Lookup column. Lookup columns should be constructed as below when used in a formula:

TableWhereYouHaveTheLookupColumn.LookupColumnName.ColumnInTheRelatedTable

Now, to help you with your Formula:

Is PMMS_Sites the table name that has the Lookup Column?
What is the Column name in the Related table that should have the selectedSite values?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com