Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Ternary relationship in CDS



I am currently implementing an application for timesheet based on the following "diagram":


WhatsApp Image 2019-11-04 at 18.52.19.jpeg


I'm having issues implementing the main screen to feed the central table "Temps".


I am not able to feed the lookup combobox with the right data (task assigned in the entity "Mission").


Could you please help me or give me a hint in order to achieve what I want ?


Kind regards,



Super User II
Super User II

Hi @mmp974 

There is no such thing as a ternary relationship in PowerApps.  There can only be One-to-one, One-to-Many or Many-to-Many.  The latter is really two One-to-Many relationships.  It may help to review my series in the News and Annoucements part of the forum.  It starts at and the most pertinent one is .  I hope that this helps with your design issues. 

Frequent Visitor

@Drrickryp ,


Thank for you reply and the link was useful.


I think the ternary relationship is just modelling (the main table "temps" has Many-to-One relationship with other entity), the problem that I have is to populate the entity "temps".


I don't know how to proceed to populate and filter dropdown combo box, everything I tried didn't work in order to fill the form correctly.




Frequent Visitor

I'll add some details to clarify.


The following field circled in red are the lookup fields I need to pre fill with informations I gave in other screens before.

(ie. the actions assigned to the mission, and the used assigned to the project)


Capture d’écran 2019-11-07 à 13.59.29.png


Kind regards,




Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Top Kudoed Authors
Users online (33,207)