Can I (and should I) link two lists together?

%3CLINGO-SUB%20id%3D%22lingo-sub-2162148%22%20slang%3D%22en-US%22%3ECan%20I%20(and%20should%20I)%20link%20two%20lists%20together%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2162148%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20list%20showing%20various%20risk%20topics.%20For%20each%20risk%2C%20the%20user%20should%20be%20able%20to%20add%20one%20or%20several%20actions%2Ftasks%20to%20be%20followed%20up.%20Can%20I%20create%20two%20separate%20lists%2C%20and%20link%20them%20dynamically%20together%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAlternative%201%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EKeep%20everything%20in%20the%20same%20list%3A%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2233.333333333333336%25%22%3ERisk%201%3C%2FTD%3E%3CTD%20width%3D%2233.333333333333336%25%22%3ETask%201%3C%2FTD%3E%3CTD%20width%3D%2216.666666666666668%25%22%3EAssigned%20to%3C%2FTD%3E%3CTD%20width%3D%2216.666666666666668%25%22%3EDue%20date%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3ECons%3A%20the%20list%20may%20become%20quite%20cluttered%20with%20many%20columns.%20And%20it's%20only%20possible%20to%20add%20one%20task%20per%20topic%2Frow.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAlternative%202%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3ECreate%20two%20separate%20lists%3B%20one%20for%20the%20risk%20topics%2C%20and%20one%20for%20all%20tasks.%20I%20think%20this%20would%20be%20the%20best%20option%20for%20my%20purpose%2C%20but%3A%3C%2FP%3E%3CUL%3E%3CLI%3ECan%20I%20somehow%20link%20these%20two%20lists%20together%3F%3C%2FLI%3E%3CLI%3ECan%20I%20create%20a%20%22Add%20new%20task%22%20column%20with%20a%20button%20link%20(similiar%20to%20the%20buttons%20you%20can%20create%20for%20running%20a%20flow)%3C%2FLI%3E%3CLI%3ECan%20I%20create%20a%20column%20that%20shows%20all%20tasks%20connected%20to%20each%20topic%20(and%20vica%20versa)%3C%2FLI%3E%3C%2FUL%3E%3CP%3EI%20guess%20what%20I'm%20really%20trying%20to%20do%20is%20create%20a%20sort%20of%20relationship%20link%20between%20the%20two%20lists%2C%20similiar%20to%20what%20you%20can%20do%20with%20Microsoft%20Access%20and%20Power%20BI.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2162148%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2461054%22%20slang%3D%22en-US%22%3ERe%3A%20Can%20I%20(and%20should%20I)%20link%20two%20lists%20together%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2461054%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F115731%22%20target%3D%22_blank%22%3E%40Tormod%20Solem%20Slupphaug%3C%2FA%3E%26nbsp%3Bthis%20is%20actually%20a%20great%20question%20with%20interesting%20examples.%20I%20am%20looking%20for%20the%20same%20answer%20for%20a%20big%20project%20that%20I%20have%20been%20assigned.%20A%20response%20from%20a%20community%20member%20or%20a%20Microsoft%20representative%20would%20be%20highly%20valued!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

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 1Task 1Assigned toDue 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.

1 Reply

@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!