Forum Discussion
Solved
Linking 3 lists to show one column's value, possible?
We have 3 lists: - Teams - columns: Title. - Services - columns: Title, Team (lookup, one value). - Customers - columns: Customer name, Services (lookup, multiple values). The relationships ar...
This is the solution we came up with:
1. We identified the scope within which the current page is.
2. For that scope we retrieve the necessary data using javascript and store them in localstorage for later usage with an expiration time of 10 hours.
3. Each page that an end-user access then presents the data needed by taking it from the localstorage.
You could always use PowerQuery in Excel to do the relationship, save the Excel file then embed that document within the site with Slicers. Alternatively, you could do the same in PowerBi and Expose the report through the embed code.