Answered

Error: multiple levels of many to one relationship expansion aren't supported

(0) Share

Report

Posted on by Edirin

Hi everyone, not new to PowerApps but fairly new to working with dataverse and i've run into a bit of a snag. i have 3 tables...

Employee list

First name
Surname
Email

Country list

Country
CEO (lookup column to employee list)

Other table

Country (lookup to country list)

I have 'Other table' shown in a gallery, but doing ThisItem.Country.CEO.'First name' throws this error - multiple levels of many to one relationship expansion aren't supported. How do i get the CEO's first name?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @Edirin, multiple levels of many to one relationship is not possible when using Dataverse as your Data source in PowerApps. You will have to utilize the LookUp function:

FirstNameLable= LookUp(Employee list, First Name =LookUp(Country list, Country=ThisItem.Country).CEO).FirstName

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Edirin 38 on at

Like (0)

Report

Thanks @AhmedSalih , but now i'm getting errors on both equals signs - Incompatible types for comparison. These types can't be compared: Text, Record

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report

@Edirin can you please share some screenshots with errors?

Was this reply helpful? Yes No
Verified answer

Edirin 38 on at

Like (0)

Report

@AhmedSalih , after some tweaking, here's what worked...
LookUp(Employee list, Email = LookUp(Country list, Country= ThisItem.Country.Country Name).CEO.Email).Name

Thanks for the tip though

Was this reply helpful? Yes No