Forum Discussion
SharePoint List - Columns relationship
Hi everyone,
I have several lists in SharePoint. The main ones are: Clients, Projects and Processing Log.
Now, in Processing Log, there are few columns of interest, Client name and Project name. Both are lookup columns, related to the Title in their List (Client name from Clients list, and Project name from Projects list). There is also a status for each of the clients and projects. Both have either Active or Archived.
Like that, when creating new item in Processing Log, I can select any Project or Client.
Now, I want to achieve, when selecting particular Client name, when creating new item in Processing Log, in the Project name field, only Active projects, related to that client will be displayed.
I've been looking for the solutions, but didn't find one yet.
Any hint would be appreciated.
Thanks,
-Filip
Filip1305 If you need cascading drop down behavior for client and project names, you will have to customize the list forms using Power Apps.
Check below documentations for more information:
- Working with Cascading Lists in SharePoint and Power Apps
- Create dependent drop-down lists in a canvas app
If you don't need cascading between client & project names and only wants to show active projects (for all clients) all the time in drop down, you can use the solution I provided here: Filter lookup column value using JSON
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.
