Forum Discussion
Tormod Solem Slupphaug
Feb 24, 2021Iron Contributor
Can I (and should I) link two lists together?
I have a list showing various risk topics. For each risk, the user should be able to add one or several actions/tasks to be followed up. Can I create two separate lists, and link them dynamically together?
Alternative 1:
Keep everything in the same list:
Risk 1 | Task 1 | Assigned to | Due date |
Cons: the list may become quite cluttered with many columns. And it's only possible to add one task per topic/row.
Alternative 2:
Create two separate lists; one for the risk topics, and one for all tasks. I think this would be the best option for my purpose, but:
- Can I somehow link these two lists together?
- Can I create a "Add new task" column with a button link (similiar to the buttons you can create for running a flow)
- Can I create a column that shows all tasks connected to each topic (and vica versa)
I guess what I'm really trying to do is create a sort of relationship link between the two lists, similiar to what you can do with Microsoft Access and Power BI.
- hoyanosoyoCopper Contributor
Tormod Solem Slupphaug this is actually a great question with interesting examples. I am looking for the same answer for a big project that I have been assigned. A response from a community member or a Microsoft representative would be highly valued!