Help Linking SharePoint Lists

Hello vfaria ,

Create a SharePoint list for the projects. The projects should be added through a Power App, that is controlled by Power Automate, with approval flow. 

The projects then get added to a controlled list that only the "Power Automate" account has access to add information to. Each project will have a unique ID (default list column). The unique ID will later be used. 

Further develop the Power App experience to showcase a dropdown or searchable column for all current projects. The user has to select a project to be able to create an initiative (to connect them).

When the user has selected a project and wants to create the initiative. Trigger a Power Automate to find the list item with the unique value "Title" and fetch the project ID. Use that ID value in another list where you store the initiatives and, in that way, they will be connected to the project. 

In the initiatives list, you will need to create a custom column for the "Project ID". Because you cannot override the ID on the initiatives. 


Yours sincerely,
Aref Halmstrand

If this was helpful, please mark as resolved 🙂
Feel free to give this message a like! 🤩