CDM Lookups and PowerApps filters

(0) Share

Report

Posted on by arnonel

138

Have created a new Entiry, which has a lookup to another table, eg: Client

When I create an app/screen, it wont let me do a Filter for Client. If I try Filter by Client.ClientName, I also get an error.

Is there a workaround for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Steelman70 873 on at

Like (0)

Report

Hi, I couldn't even get lookups to work. Were you able to edit the lookup column in Excel?

Was this reply helpful? Yes No
arnonel 138 on at

Like (0)

Report
No - havent tried in Excel.

Tried what I would expect is a simple user journey.
Create Entity eg: "Company"
Create Entiry eg: "Person"
Person has lookup to "Company"
Create a Powerapp
Create a Company Gallery - button to view People in company
Create a Person Gallery - filter by Company

Filtering in this way does not work as you cannot compare 2 "Objects" (Company). And you cannot compare Company.CompanyName as it also has error

Was this reply helpful? Yes No
Steelman70 873 on at

Like (0)

Report

I couldn't get it to work in PowerApps either, frankly I am disappointed by data structure in CDM so far. Seems like SharePoint lists by another name. But I have ranted about that in other posts...

Was this reply helpful? Yes No
Vijeta on at

Like (0)

Report

Hello
Thank you for your feedback. Can you please share the lookup field name on the custom Person entity and the title field name on the custom Company entity? Can you also share the filter expression you tried on the Person gallery?

Was this reply helpful? Yes No
Lucas 32 on at

Like (0)

Report

I have a similar issue, I have 2 entities in my CDS, the entity 1 has lookups on the entity 2. In my app I insert the gallery and I use the entity 1 as my data source, I want to show the information in those lookups, but I can't see them. I can show any type of entry (Address, DateTime, Picklist...) but lookups.

Was this reply helpful? Yes No