web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Multiple dataset PCF f...
Power Apps
Unanswered

Multiple dataset PCF filtering

(0) ShareShare
ReportReport
Posted on by 4

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).

 

AnthonyFerry_0-1682002246425.png

 

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 

AnthonyFerry_1-1682002687768.png

 

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

 

AnthonyFerry_2-1682002950209.png  AnthonyFerry_3-1682002952825.png

 

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 

AnthonyFerry_4-1682003168724.png

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

AnthonyFerry_5-1682004150869.png

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

AnthonyFerry_6-1682004382189.png

 

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 :

AnthonyFerry_7-1682004512958.png

AnthonyFerry_8-1682004717718.png

AnthonyFerry_9-1682004853988.png

 

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

 

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard