lookup +conditional formatting

[happy2023]

Hello, 

Could you do me a favor?

In the B list, Department and Job Title are lookup.

If Department is Finance, can the Job Title only display the jobs that are only related to Finance?

Sale – only jobs are related to Sale will be displayed

IT department – only jobs are related to Sale will be displayed

Is that possible?

[#2]

@happy2023 This is not possible using SharePoint out of the box functionalities of lookup columns.

You can achieve this by customizing list forms for List B using Power Apps and using custom formula/logic for filtering Job Title drop down items based on selection in Department drop down.

Check below Microsoft official documentations for same:

1. Customize a Microsoft Lists or SharePoint form by using Power Apps 
2. Create a dependent drop-down list in a canvas app 
3. Working with Cascading Lists in SharePoint and Power Apps 

---

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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs