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

One to Many relationship excel table linking to PowerApps

Hi,

I have two excel tables Supplier & SupplierPO with SupplierID as a relation between the two tables (attached). One supplier can have more than one purchase orders(PO). In Power apps I am building a relationship Gallery. In one gallery(gallery10) the supplier table is populated and in the another gallery(Gallery11) i want to list all the POs of the selected supplier in gallery10. 

the command I am trying Filter(SupplierPO.PONumber, SupplierPO.SupplierID = Gallery10.Selected.SupplierID) is giving error.

Any help highly appreciated.

 

1 ACCEPTED SOLUTION

Accepted Solutions
eka24
Super User
Super User

One issue is what formula do you have on the Gallery10.

However try;

Filter(SupplierPO,SupplierID = Gallery10.Selected.SupplierID) 

 

If you have issues State the formula on the first Gallery

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

View solution in original post

4 REPLIES 4
dyee4614
Helper V
Helper V

Filter(SupplierPO, SupplierID = Gallery10.Selected.ID)

eka24
Super User
Super User

One issue is what formula do you have on the Gallery10.

However try;

Filter(SupplierPO,SupplierID = Gallery10.Selected.SupplierID) 

 

If you have issues State the formula on the first Gallery

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

That was a perfect solution.

 

Now how can I populate these two selected values "SupplierName" & "PONumber" in the two text boxes in a different screen(screen2)?

Just create a text box or a label or whatever you want.  In the default or text section just reference the gallery.  this is assuming both values are in that gallery.

 

Gallery10.Selected.SupplierID

Gallery10.Selected.PONumber

Helpful resources

Announcements
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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,208)