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 / One-to-Many Relationsh...
Power Apps
Unanswered

One-to-Many Relationships for Canvas apps - Not working

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

My app is no longer able to traverse related entities to retrieve field values.

I.E.
If the data model is:

  • Account has many Contacts

The objective is to retrieve the account name for all Contacts. 

 

I would create a gallery with the items property equal to Contacts and create a text field within the gallery which has the following query for the text property:


ThisItem.Account.name

 

The above query was working and was part of the release in One-to-Many Relationships for Canvas apps (https://powerapps.microsoft.com/en-us/blog/one-to-many-relationships-for-canvas-apps/).  

 

This is currently working in the published app, but in while in build mode, the values are null.

 

I need to release a new version of the app, but cannot because of this issue.

 

Other things to note:

1.) I am working with custom entities created in Dynamics 365.

2.) I am able to query for ThisItem.Contact, but can no longer retrieve any values from the Contact table.

 

Please Advise,

 

Thanks

 
 
PowerApps_1toMany_PublishedVersion.PNG
PowerApps_1toMany_NotWorking.PNG
Categories:
I have the same question (0)
  • v-yutliu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

    Do you mean that you can not search value in Contact entity when the app is in edit mode?

    I've made a similar test but not met the same problem like your description.

    My lookup field could display value in edit mode.

    Firstly, you need to connect this app with Account entity and Contact entity.

    Then, using the same step like your description.

    11155.PNG

    So your formula should have no error. 

    Here's my PowerApps version: 3.19111.28

    I suggest you clear your browser's cache , update it to the latest version and try again.

    If the problem still exists, I suggest you ask for help here:

    https://powerapps.microsoft.com/en-us/support/pro/ticket/

     

     

    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!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 536

#2
WarrenBelz Profile Picture

WarrenBelz 426 Most Valuable Professional

#3
Haque Profile Picture

Haque 305

Last 30 days Overall leaderboard