Forum Discussion
Solved
If Statements for SharePoint list
I have a list that requires 1) purchase approval (route for approval) 2) internal list based on selection for the office internal customer selects what office they are in (Office A, Office...
- For approval: You can create and use Power automate approvals
- For connecting two list data, you can Create list relationships by using lookup columns
- If you want to restrict viewing internal list items based on office selection, consider approach given in my answer at: View/edit rows in SharePoint List that only relevant to the specific team
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.
You can customise your list new form with Power Apps to achieve this customisation.
Reference: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/customize-list-form