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

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
Helper V
Helper V

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

Super User III
Super User III

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

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (52,578)