One to Many relationship excel table linking to PowerApps

[shoebwk]

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.

[dyee4614]

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

[eka24 · Accepted solution]

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.

[shoebwk]

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)?

[dyee4614]

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