Skip to main content

Notifications

Power Platform Community / Forums / Microsoft Dataverse / Multiple levels of man...
Microsoft Dataverse
Answered

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

Posted on by 7

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!!.

 

awar1978_0-1675768944401.png

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:
  • Multiple levels of many-to-one relationship expansion in the app where thera is only one level.
    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. 
  • J_CF Profile Picture
    J_CF 6 on at
    Multiple levels of many-to-one relationship expansion in the app where thera is only one level.
    Hi! I'm experiencing the same issue. Have you found a solution?
  • wheatbarley36 Profile Picture
    wheatbarley36 14 on at
    Re: Multiple levels of many-to-one relationship expansion in the app where thera is only one level.

    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!

  • HFG Profile Picture
    HFG 481 on at
    Re: Multiple levels of many-to-one relationship expansion in the app where thera is only one level.

    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

  • Verified answer
    c-hermus Profile Picture
    c-hermus 9 on at
    Re: Multiple levels of many-to-one relationship expansion in the app where thera is only one level.

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

September 2024 Newsletter…

September 2024 Community Newsletter…

Community Update Sept 16…

Power Platform Community Update…

Tuesday Tip #2 Global Search…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,008

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,531

Leaderboard

Featured topics