Filter CDS with related fields in Canwas app gallery

(0) Share

Report

Posted on by TrulsB

144

I have two tables in CDS. Projects and tasks. There is a relation between Projects:Projectname and Tasks:Project.

I have one gallery in my Canvas app for "Projects"(ProjectGallery) and one gallery for "Tasks"(TaskGallery). When i select a project (Thisitem.IsSelected) i like to filter the Tasks gallery, so i only see thasks that is related to the acutal project in the task table, without getting delegation warning.

In "Tasks" the Project field is a lookup field. In "Projects" is the primary name (text). Any idea how the correct: Filter(Tasks;.....) should be like to select related fields without delegation warning.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @TrulsB,

Would it be possible to share your current filtering expression? The project's primary name is text but that's just what is displayed instead of the displaying the primary key. Behind the scenes, the Project record primary ID/key (GUID) is saved on Tasks so you'll have to filter with that. Here's an example:

TaskGallery.Items = Filter(Tasks, Project.PrimaryId = ProjectGallery.Selected.PrimaryId)

Hope this helps!

Was this reply helpful? Yes No
TrulsB 144 on at

Like (0)

Report
Copy link

Link copied!

Hi,
my filter is
With this filter it do now show the records in TaskGallery i, and i also get an delegation warning.

Without filter it looks like this:

With filter it looks like this:

My database tables look like this. Norwegian "Oppslag" in Tasks, = Lookup 🙂

It must be somthing im missing here?

Was this reply helpful? Yes No
TrulsB 144 on at

Like (0)

Report
Copy link

Link copied!

I have problem With reply to you, please look into the case

Was this reply helpful? Yes No