Showing results for 
Search instead for 
Did you mean: 
Helper V
Helper V

Default Values using CDS and model driven apps

I have been building canvas apps the past year and have become used to the flexibility of being able to set default values with a varieity of options provided.  Within a model driven app that uses the CDS it's not clear to me what all the methods are or best practice.


For example, I have a lookup field within the CDS entity to a Dynamics Talent entity named worker.  The lookup uses the employee's worker ID and I woudl like to set the default value to the currentl user running the form. 

This worker entity has a variety of additional columns to help drive defaults such as employee email.  Within a canvas app you could simply grab the current users email and match it with the employee email within the worker column to default the correct worker ID.


Within a model app I am using the Business rules to set the default value however these don't seem to use formulas or not able to select additional fields, seems to be more simplisitic.  

Is it not possible to walk to other fields within the entity like we can in Canvas apps?

LookUp(Workers, 'Primary Email Address' = 'Created By'.'Primary Email', 'Worker Number')


I can create calculated column (Text)  such as employee's email and populate using createdby.internalemailaddress however this does not seem possible on a lookup column.


So am I missing something here?  Is there a way to default a lookup column with a dynamic value?



Helper V
Helper V

Re: Default Values using CDS and model driven apps

I am beginning to think much of this flexibility we have in canvas apps simply does not exist in model however using embedded canvas apps could be a solution.


After testing out the embedded apps it seems like these are designed more for displaying related data rather than capturing data upstream and interacting with on a new record.  Guess this is not an option for my scenario either.

Community Support
Community Support

Re: Default Values using CDS and model driven apps

Hi @Dudditz ,

Do you want to filter values of a lookup field?

Firstly, canvas app and model-driven app has many differences.

Canvas apps have more flexibility. While model-driven apps could deal with complex business logic.

You could  filter values of a lookup field by turning on "Only show records where".

When this is enabled, the records that display when users search for a record will have additional filtering applied. This helps provide more relevant searches when setting the value of the lookup.

Here's a doc anout it in details for your reference:



Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (8,604)