Power Platform Community Forum Thread Details

Background: I have three data sources. One is a SQL master dataset with a bunch of part information and part numbers, but no formal part name. The other is a basic Part details list with each individual part name, a picture and the category & subcategory that part belongs to. This list is tied to the gallery as seen below. The third list is a Part numbers list, this list has two fields Part number and a lookup Part name field that pulls from the Part details list. What I need to do is somehow connect all three so that when someone clicks the image on the gallery selection it will go to another screen that pre filters the SQL data source for the matching part name selected based on the part number. the Part number field is text on sharepoint and also text in SQL. The Part name is text on the SP part details data source but on the third SP Part Numbers data source the Part name is a lookup column pointing to the part name in the SP part details data source.

So TLDR: Need to pre filter a data table for the selected part name based on matching part numbers. One Part can have up to 500 Part numbers because of varying dimensions etc.

I was trying to do something like this:

ForAll('Part Numbers',If('Part Number' in '[dbo].[970_item_format_item_mast]'.item_id,Collect(testCollect,LookUp('[dbo].[970_item_format_item_mast]',item_id = 'Part Numbers'.'Part Number'))

The idea was to loop through all the part numbers where it matched the part number in SQL and put those into a collection, but then I confused myself and am lost now.