Forum Discussion
Make fields required in the new list form, but not the list.
I want to have 2 different forms feed into my list. Each form has different required fields. As far as I can see I can hide required fields in the form and submit the form fine, but when I view the list it highlights a lot of errors asking for required fields. Some fields are relevant to one request and not the other request submitted via the form.
It would be great if we could make the fields only required in the form and not in the list. I'm probably going to have to go back to using MS Forms for this project.
It's really irritating that any attached flows also need to deal with the required fields in the list and update them each time. All I want to do is update the approval status, but I also have to update 5 fields.
3 Replies
jellybeancooper As Rob mentioned, you can't do this using the Standard SharePoint List Forms, but you could convert your List forms to Power Apps and add some logic in there to manage the required fields.
Unlike the standalone Microsoft Forms, a list form field is inextricably linked to the SharePoint column it is based on. So if you set the column to be required from the list it will be required in the form and vice versa. If you set the column in the list form to be required it will make it required in the list column. You can't separate the two.
Re your comment on the flows needing to have the required fields updated instead of just the column you want to update, it has always been that and I don't see any evidence that it will change soon.
Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)Thanks for confirming. Glad it's not just me making a mess of the forms. Oh well, I'll just use MS Forms for this project. The team are used to using them anyway.
