Service | Customer Service, Contact Center, Fie...

get parent of parent id - look up field value in a calculated field

(0) Share

Report

Posted on by SivaR

I have a classification entity (similar to the product catalog ) that includes parent classification id.

using this classification entity, i can create a product sector, product subsector, and product records.

Product is a child of product subsector. The product subsector is a child of the product sector.

I try to rename the Colum tile of a view (image 1) using a calculated field following the instruction from the link, https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Renaming-column-headers-in-an-entity-view/m-p/668202#M7018

I was able to create a calculated field to display Product sub sector (image 1). However, any suggestion on how can I get the Product Sector name (parent.parent.name).

Thank you, Siva

image 1

image 2

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hi SivaR,

As you mentioned, “Product is a child of product subsector. The product subsector is a child of the product sector.”

Maybe you can create a new 1:N relationship between Product and product sector, so one new product sector lookup field can be added into product entity.

Then you can copy original product sector lookup field value from product subsector to new product sector lookup field of product automatically.

Finally, you can create another new calculated field to display Product sector just like your previous operation for Product sub sector.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No
SivaR 69 on at

Like (0)

Report

Thank you for the response.

Based on the current database structure, i am able to create a view to display product sub sector (classification.parentclassification as per image 1) and Product sector (parentclassification(classification).parentclassification as per image 2 ). However, the system doesn't allow me to create calculated field to select parentclassification(classification).parentclassification. Why it is working in view and not in the calculated field?

image 1

image 2

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi SivaR,

You can refer following link for calculated fields considerations:

https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields?view=op-9-1#calculated-fields-considerations

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.

Was this reply helpful? Yes No