Creating SharePoint columns manually can be a tedious task, but it can be automated using Power Automate flow. To create a new column, you can extract its XML schema from an existing column using an HTTP request. Once you have the schema, you can use it in another HTTP request to create the column in SharePoint. If you need to create multiple columns, you can extract the schema for each column and store them in an array variable. Then, you can loop through the array and create the columns one by one. This approach not only makes it easier to create new lists/libraries, but it also allows you to copy/set any configuration on these columns. Additionally, you can use an HTTP request to add the column to a view.
Login now to access my digest by 365.Training