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?
