Forum Discussion

Filip1305's avatar
Filip1305
Copper Contributor
Aug 11, 2023

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....
admin
Lists
microsoft lists
SharePoint Online
Sites
ganeshsanap's avatar
ganeshsanap
MVP
Aug 11, 2023

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:

  1. Working with Cascading Lists in SharePoint and Power Apps 
  2. 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.

Resources