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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,238)