Forum Discussion
Changing multiple SharePoint list columns required property
I'm working on a PowerApps app connected to multiple lists. One of these lists has 120 columns whose fields have been configured as required. Without having to manually change each of them, I would like to change this setting so that they are no longer required. If I understand correctly, you can use PowerAutomate for this, but I have no experience with this tool. I would be very grateful if you could suggest a solution.
3 Replies
Merchandise @Go to the SharePoint site containing the list for which you want to modify columns.
- Navigate to the list and click on the gear icon (Settings) and then click on "List settings".
- Under the "Columns" section, click on the column name you want to modify.
- In the column settings page, find the "Require that this column contains information" option and toggle it on or off based on your requirement.
- Click "OK" to save the changes.
- Repeat the process for each column you want to modify.
OP (bdawidowski) don't want to do this manually for all 100+ fields, text from original question:
Without having to manually change each of them, I would like to change this setting so that they are no longer required.
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.
Did you make these columns required from SharePoint list or from Power Apps (using formula)?
If you have made those required from list, you can use PowerShell to make those non-required (loop on all required list fields and update the settings). Check: How to Make a Field Required in SharePoint List using PowerShell?
If you have to make the changes from Power Apps, you can select multiple "data cards" within form control and set it's "Required" property to false. You can use Ctrl + click to select multiple data cards.
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.
