cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Dudditz
Level 8

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?

 

 

2 REPLIES 2
Dudditz
Level 8

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 Team
Community Support Team

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:

https://docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/special-field-properties-legacy

 

 

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

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,663)