Unanswered

Entities/Tables relationship design/setup question

(0) Share

Report

Posted on by ChenYung

Hi,
The CDS entities designed as below:

Table	Custom field	Relationship	E.g.
Users (Default)	GroupPolicy as Text
GroupPolicy			A, B, C, D, E, F
Request	RequestType as Lookup	N-1(RequestType)
RequestType	Workflow as Lookup	1-N (Workflow)
Workflow	Reviewer as Lookup Approver as Lookup	N-N (GroupPolicy) N-N (GroupPolicy)	B,C,D E,F

Questions
1. Is it possible to store 'Record' for the field/column of Lookup type?
2. If (1) is do-able, please advise how to set a collection (in Canvas) for 'Request' that will join the related entities, RequestType > Workflow to get the both Reviewer and Approver (as GroupPolicy)?

Regards,

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Joel CustomerEffective 3,224 on at

Like (0)

Report
So if I understand, you want to store both the lookup value as well as the text value of the selected record in a lookup. Is there a reason you need to do this?

If I have a lookup to another entity table, I can use dot notation to get the text value of the lookup record. For example

ThisItem.Customer.Name

will get the name field from a customer lookup on order table.

For working with N:N related records, you could use Power Automate flow to get the records, or see @nickdoelman blog post https://readyxrm.blog/2020/09/04/how-to-implement-a-common-data-service-many-to-many-field-on-canvas-power-apps/

If you need to do this for some other reason, you could patch the value to a text field when a record is created from a canvas app, or what I like to do is use a real time workflow that runs on update of the lookup field and updates a text field.

Was this reply helpful? Yes No
ChenYung 9 on at

Like (0)

Report

Hi, Good day.
I understand you said about the dot notation to get the text value. My question about the Reviewer field (same with Approver field) which is a lookup field to "GroupPolicy" Table. Is it possible to store a record of Lookup (multiple looup values)? Example Reviewer consists of GroupPolicy B, GroupPolicy C, GroupPolicy D and Approver has [GroupPolicy E, GroupPolicy F]

Was this reply helpful? Yes No