web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Mmultiple levels of ma...
Power Apps
Answered

Mmultiple levels of many-to-one relationship expansion aren't supported

(0) ShareShare
ReportReport
Posted on by 79

Hi,

 

Recently I start getting this message in filters that were build before, in my case I'm trying to load the Price List Items of a selected price list, but the error will show

 ClearCollect(
 SelectedPriceListItems,
 Filter(
 [@'Price List Items'],
 'Price List'.'Price List' = PriceListId
 )
 );

image.png

last week the app was working perfectly, but suddenly this issue started

I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @aboodhamwi ,

    Could you please share a bit more about the 'Price List' column in your 'Price List Items' Entity? Is it the LookUp type column (generated by Many-to-One relationship)?

     

    Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:1.JPG

     

    2.JPG

    The 'Normal Contact' column is a LookUp field in my TaskLists Entity, which references records from Contacts Entity. Add a Gallery within my app, set the Items property to following:

    Filter(TaskLists, 'Normal Contact'.Contact = ComboBox1.Selected.Contact)

    the records displayed well in my Gallery as above.

     

    Please check if the result the PriceListId variable returns is the 'Unique Identifier' column value in your 'Price List' Entity. On your side, you could consider add a ComboBox in your app, set the Items property to following:

    'Price List' /* <-- Type your 'Price List' Entity data source here */

    set the SelectMultiple property of the ComboBox to false.

    then add a Button in your app, set the OnSelect property to following formula:

    ClearCollect(
     SelectedPriceListItems,
     Filter(
     [@'Price List Items'],
     'Price List'.'Price List' = ComboBox1.Selected.'Price List'
     )
    )

    Note: I assume that the 'Price List' is the 'Unique Identifier' column in your 'Price List' Entity.

    Please press above button, then check if the SelectedPriceListItems collection is populated with proper records.

     

    If the issue still exists, please consider re-generate an app based on your 'Price List Items' Entity, then try above solution again, check if the issue is fixed.

     

    Best regards,

  • Verified answer
    aboodhamwi Profile Picture
    79 on at

    Hi,

     

    The Price list consider a parent for the price list item and the relation is one-to-many, but as what I was saying the app was working perfectly, and suddenly this issue shows up, I was using PowerApps studio inside chrome browser, once I open the app in Edge the issue disappeared totaly, and I was able to publish my app without changing anything and it did work fine

  • v-xida-msft Profile Picture
    Microsoft Employee on at

    Hi @aboodhamwi ,

    Have you solved your problem?

     

    If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

     

    Best regards,

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard