Power Platform Community Forum Thread Details

Multiple dataset PCF filtering

Hello everyone,

I need help or at least some advice on the issue i'm facing on right now.

Just a bit of context for you to understand 🙂

I'm working on a project for a client of my company. The client is a house builder that manage the whole selling process in Dynamics CRM. They recently wanted to manage the "building" process too. To do so, I've created a few tables including Chantier (which means construction), Etape de chantier (construction step) and Appel de fond (call for fund).

So, one Chantier owns multiple Etapes de chantier and multiple Appel de fond.

The client wanted a tool to quickly manipulate the data in the three entities simultaneously.

For example, here is the actual PCF

The green square contains informations of the Chantier, the first row contains all the Etapes de chantier and the second row all the Appels de fond.

The table Etape de chantier contains an attribute that indicate a progression value (from 0 to 100). The user can update this value of any Etape by right clicking and select a new value

The component work as I wish and it's pretty smooth.

The problem is :

To retrieve all the data from all the tables, i'm using multiple dataset in manifest file

On the init method of the component, I add all the columns that I need in the datasets

On a typical usage scenario, I want to apply a new filter to exclude, for example, all the Chantier that were created before a date

When doing this I get a lot of issues because I cannot get Etapes or Appels records anymore (their record count is zero).

I'm looking at network on chrome so I can see what's wrong. I found this :

All the highlighted attributes are not part of the Chantier table. And I don't understand how and why the generated fetch includes those attributes since the only part of the code I mention these, it's in the init function.

Do you know what could be the reason of this ? And (if i'm lucky 😅🤞) how can I correct it ?

Many thanks, have a nice day 😃

Anthony Ferry

Categories:

Power Apps component framework

Quick Links

Leaderboard > Power Apps - Power Apps Pro Dev & ISV