When a new entry is added to a column for a part number, I would like to use the lookup function on multiple lists (they are big lists and SharePoint has a limit of 20,000 rows) and output/return the correct correlating box qty associated with that part number into a single column, "Box Qty". Is this a series of IF statements that can be combined with the lookup function? How could I use power automate to automate this process so that when "part number" is entered, a search is done across multiple lists to return the correct qty for that part number to a new column "Box Qty".
Thank you.
