Answered

Multiple levels of many-to-one relationship expansion in the app where thera is only one level.

(1) Share

Report

Posted on by awar1978

Hi!

In my powerapp just today started to get errors of multiple levels relationships where before I didn't get the errors. It's really strange... It's only one level relationship but I get the error. It is happening in some fields that I didn't get any error...

I was testing using a lookup instead but I get the error anyway!!.

This was working until today....

I have a copy of the app for testing and I don't get the error there.... 😞

Please, some help!!

Thank you.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (1)

MS-21101203-0 2 on at

Like (0)

Report
Copy link

Link copied!

i am experiencing also the same issue. I checked my code multiple hours, if there is somewhere a multilevel relationship called, but no.

what "fixes" the issue for me: If i remove all code from the app where the dataverse table is called and add the same code again, i dont get any errors.

But as soon as i add any type of code which references this table, all errors reappear.

Was this reply helpful? Yes No
J_CF 6 on at

Like (0)

Report
Copy link

Link copied!

Hi! I'm experiencing the same issue. Have you found a solution?

Was this reply helpful? Yes No
wheatbarley36 14 on at

Like (0)

Report
Copy link

Link copied!

I found a solution. I'm not sure what levels your trying to go through but here was my problem - I needed to locate the logo of a company for each material being listed in a certain 'bill of materials'. This required me to go down three entities.

Original formula that resulted in error:
ThisItem.'Required Material 1'.Vendor.'Vendor Logo'

Solution that worked:
LookUp('Raw Materials', Name = ThisItem.'Required Material 1'.Name).Vendor.'Vendor Logo'

Where
'Raw Materials' is the source of the search,
'Name' is the column to match with the 'Required Material' column as a condition to evaluate rows,
'Vendor' searches the related table,
'Vendor Logo' gets me the final record I need. Hope this helps!

Was this reply helpful? Yes No
HFG 518 on at

Like (0)

Report
Copy link

Link copied!

Hi @c-hermus @awar1978

Did you ever get a solution to this ? My application which has been working fine for weeks is suddenly throwing this error on places where it is clearly not a multi level lookup. I can't even use the LookUp function because it won't retreive the value I need from the LookUp coumn to be able to use it in the function.

Help !

Thanks

Was this reply helpful? Yes No
Verified answer

c-hermus 9 on at

Like (1)

Report
Copy link

Link copied!

I thought it was me, have the same issue. Yesterday I had no problems with the same formula.

Was this reply helpful? Yes No