cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Connor55
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:

https://powerapps.microsoft.com/en-us/blog/one-to-many-relationships-for-canvas-apps/

 

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

3 REPLIES 3

@Connor55 

 

 

Is your second parameter of Relate:

 

InventorySearch.Selected.PullSheet_LU

 

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

 

 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate

 

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

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

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