Answered

2nd Level Lookup Retrieval

(0) Share

Report

Posted on by roguetomato

How do you retrieve a data if it's in the 2nd level lookup like the example below?

Company Entity
 '-----> Employee Lookup
 '-----> Health Record Lookup
 '------> Last Checkup Date

So, basically, I want to retrieve the Last Checkup Date of the employees of the Company.

I tried this but it gives me an error saying "Multiple levels of many-to-one relationship expansion aren't supported."

ClearCollect(CompanyHealthRecord, Filter(Company, Employee.HealthRecord.LastCheckupDate < Now()));

Any workaround for this?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @roguetomato ,

For the time being, PowerApps doesn't support to look up a lookup field yet.
If you want this feature, please submit an idea to PowerApps Ideas Forum:https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,
Sik

Was this reply helpful? Yes No
Romsteck 83 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft,

Is there a workaround to do this 2nd level lookup ?

Thanks in advance ! 😉

Bests Regards.

Was this reply helpful? Yes No
majuarezg 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you find any solution to this ??

Was this reply helpful? Yes No
ViswaMullapudi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
I found some work around to get the value for 2nd Level Lookup.
Try your query as below, considering EmployeeID is your unique identifier in Employee entity and have used ThisItem considering you are using value from Gallery.
ClearCollect(CompanyHealthRecord, Filter(LookUp(Employee, EmployeeID = ThisItem.Employee.Employee,HealthRecord).LastCheckupDate));

I tried something for filtering dropdown list and it worked for me.

If(LookUp(Employee, EmployeeID = ThisItem.EmployeeID.EmployeeID, HealthRecord).Name = "XXXX", Filter(Choices(HealthRecord.Optionset'), Text(Value) in ["aaaa"]),
LookUp(Employee, EmployeeID = ThisItem.EmployeeID.EmployeeID, HealthRecord).Name = "ZZZZ", Filter(Choices(HealthRecord.Optionset'), Text(Value) in ["bbbb"]),
Filter(Choices(HealthRecord.Optionset'), Text(Value) in ["ccccc", "ddddd", "eeeee"]));

Cheers 🙂

Was this reply helpful? Yes No