Apply conditional formatting to list column

Copper Contributor

Hi there guys, I've been assigned a task to design a approval workflow where users can submit their requests onto Sharepoint List. I'm trying to find a way to categorise items in the lookup column that is the project titles ( see below) whereby it only appears in the dropdown on the form where its collection title is selected. For example, say a user selects Collection Analyzer and its respective Project APA_OF, Bakken and BEBOP only appears in the form to be chosen from. Additionally, its corresponding project admin details are pulled from its source list. Any help is greatly appreciated as I'm still fairly new to sharepoint :D





1 Reply

@mabel9915 This is not possible using SharePoint out of the box functionalities.


You will have to customize the list forms using Power Apps and then filter the drop down items using formulas.


Check below links for more information: 

  1. Customize a Microsoft Lists or SharePoint form by using Power Apps 
  2. Customize a form for a SharePoint list 
  3. Create dependent drop-down lists in a canvas app 
  4. Filtering a drop down from a Lookup table 
  5. Drop down filter from lookup field 

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.