Showing results for 
Search instead for 
Did you mean: 
Resolver I
Resolver I

Relate Function - Any idea what I'm doing wrong?

I'm trying to update this PullSheet gallery with Related Inventory Items.  Any idea what I'm doing wrong?  No errors, but nothing is showing in the galleries.  


I'm using the Northwind Traders Sample as a guide:


Screen Shot 2020-01-12 at 9.43.15 PM.pngScreen Shot 2020-01-12 at 9.44.21 PM.pngScreen Shot 2020-01-12 at 9.44.28 PM.pngScreen Shot 2020-01-12 at 9.44.31 PM.png





Is your second parameter of Relate:




returning type Record and, is that Record non-blank?


Relate( Entity1RelatedTable, Entity2Record )

  • Entity1RelatedTable - Required. For a record of Entity1, the table of Entity2 records related through a one-to-many or many-to-many relationship.
  • Entity2Record - Required. The Entity2 record to add to the relationship.



And also, if you remove the Reset on the InventorySearch that is immediately following the Relate, does it help?

(you can put it back in after troubleshooting)


Finally, the Relate + Reset - is that being done OnVisible?


If so, make another blank screen, put nothing in it, and switch back and forth between the screens in the editor, and see if it helps to trigger the OnVisible.

I think the second part of the function is the issue.  It needs to refer to a record in the Inventory entity.  However, I get the error below when trying that.


Also, the Reset has no affect on this error - and this function is OnSelect.


Screen Shot 2020-01-13 at 10.28.22 AM.png

I've tried this, but I get an error after using the select:

Screen Shot 2020-01-13 at 11.32.54 AM.png


Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,945)