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 B, etc) and their purchase request.
for their office, this list needs to be viewable to that office. For their purchase, it needs to route for approval to their supervisor.
are these conditional statements available for list? And are list able to reference lookup tables and other data?
- 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.
6 Replies
not_a_pro Did you try the solutions given in my above response? Let me know if you still need any help with this.
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.
- I believe so, I cannot use power apps at my organization. Only power automate.
not_a_pro The suggestions provided in above response are using Power automate only.
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 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
