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.
On approach would be to use an Access Web App.
Other approaches will require some code,
MarcDAnderson has some examples on his blog that could be helpful
Another approach would be to use the new Flow Common Data model, see https://flow.microsoft.com/en-us/blog/flow-and-common-data-model/