Forum Discussion
Linking of sharepoint lists cross-referenced
fietstasss I suggest doing this with Power Apps.
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)
Thanks!
fietstasss because you can have multiple data sources - the 2 SharePoint lists in your scenario. Then with a gallery or data table you can select the item from the first list and filter the second list by your selection. Much like Access used to do.
Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)Thanks for your reply.
I get your point, but the issue is that we need some kind of 3rd data/info to be stored.
At the 'crossing point' between a Vendor and Product, we want to store info like the Vendor-specific retail-id/purchase number, and perhaps also the price and URL they use for this product.
This means that 1 product can have multiple vendors, with each their own price, retail-id and URL/weblink.
Plain said, i should make a new list for each product which then lists all combinations applicable for that product, containing the available vendors with each their own dataset (containing retail-id, price, URL).
Another option would be to add a fixed number of columns to each product in the 'ProductList' to make it possible to list each vendor and their dataset, but this would result in a limited number of vendors per product.
Both don't seem a valid option, so there's the gap i'm looking for to fill in.
Hope this makes the option a bit clearer, any help is appreciated!