cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

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

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

 
 
1 REPLY 1
Community Support
Community Support

Hi @srizvi ,

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,

 

 

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

Power Apps Community Call

Power Apps Community Call- January

Mark your calendars and join us for the next Power Apps Community Call on January 20th, 8a PST

PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

Top Solution Authors
Top Kudoed Authors
Users online (6,826)