You’re offline. This is a read only version of the page.
9
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,
CY
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]
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
Share
Report
All responses (
Answers (
ThisItem.Customer.Namewill 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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
