Forum Discussion
Help Linking SharePoint Lists
My approach is slightly to that of ArefHalmstrand; I would have 1 SharePoint list for the master list of projects and a separate list list for the initiatives/tasks. This second list would have a column for the ID column value from the master list. The front end would be a Power Apps app which makes it much easier to link the 2 lists and gives the user a better experience. The ID column of the master list of projects would be used to bind the tasks to it from the list. I'll post up some screenshots as this was exactly what I was asked to demonstrate for a lunch & learn session at my company a while back.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)
Rob_Elliott, in what way was that different? :)
You suggested creating a list for each project, I just have 1 list with details of all the projects and 1 list with details of all the task with a column that has the ID number from the 1st list. Then filtering in Power Apps. No need for Power Automate at all.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Oh lol haha thank you for noticing that. My typing was a bit off due to it being late at night. 😅
On my second section it gets a bit clearer, but I have updated the text, thanks for letting me know!