Forum Discussion
Conditional field as per option selected
Riz_K375 Person or group columns are not supported in list validation formulas.
Also, currently there is no other SharePoint out of the box way for your requirements. So, you will have to customize the list form using Power Apps to achieve your requirements.
Check below documentations/links for more information:
- Customize a Microsoft Lists or SharePoint form by using Power Apps
- Customize a form for a SharePoint list
- Make a field required based on another 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.
Thank you Ganesh and apologies for the long delay.
Ok so we know that we cannot use Person field for validation. I am thinking for using the text field instead which can fill Person.
Is it possible if a user name filled in text box can fill the Person field. It is just to make sure user name is filled correctly so the flow can trigger for approval?
In another scenario if Person field is filled it can fill the text field?
- ganeshsanapJul 07, 2023MVP
Riz_K375 You can fill email address in list instead of user name.
Then when flow runs on the list after item creation, you can use Office 365 users connector to get all the details of user based on email address in the list.
Then you can use those details to send emails / approvals and fill person field in the list.
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.