cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
srizvi
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
v-yutliu-msft
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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,131)