Is there an easy way to create multiple columns in SharePoint/Microsoft lists?

Copper Contributor

I have a Microsoft list that I need to add about 100 columns to. The columns are almost identical. Example: Column _1, Column_2, and so on. I hoped someone could show me an easier way than typing them all out. I have access to power automate as well. Appreciate it!!

2 Replies

Hello @Charles665

 

it is also possible with PowerShell like this (not tested by me!): https://www.office365notes.com/2021/12/powershell-to-create-sharepoint-list.html

 

Regards, Dave 

If you only need list columns (not site columns), you can create an Excel document with your column names and then import into a list. See: https://support.microsoft.com/en-us/office/create-a-list-based-on-a-spreadsheet-380cfeb5-6e14-438e-9...