Create SharePoint List and Columns From Excel Using Power Automate

This Power Automate solution automatically creates a SharePoint Online list and its columns from an Excel file. The flow dynamically builds your list structure, manages re-creation when needed, logs every step, and alerts you if something goes wrong — all without any Premium connectors.

Features

• Automatic List Creation: Builds a new SharePoint list from an Excel file containing column details.
• Smart Re-Creation: If a list with the same name already exists, it’s automatically deleted and recreated.
• Dynamic Column Setup: Supports all major SharePoint column types, including Person and DateTime columns.
• Error Notifications: Sends an email notification to the provided address if any step fails.
• Execution Log: Generates a detailed text log file in your default SharePoint document library after completion.
• Parameter-Driven: When triggered, the flow asks for essential details like:
  • SharePoint Site Address
  • List Display Name
  • Internal Name
  • One Person’s Email Address (for testing or assignment columns)
  • DateTime Column (if applicable)
  • Excel file with column information

What Does the Flow Do

1. Checks if the SharePoint list already exists.
2. Deletes the existing list (if found).
3. Creates a new list with the given name.
4. Adds all columns as defined in the provided Excel file.
5. Generates a log file capturing every step of the process.
6. Sends an email notification if any action in the flow fails.

Package Contents

When you download the complete solution, you’ll receive three items:

1. Excel File – Contains the SharePoint column definitions.
2. README File – Step-by-step setup and usage guide.
3. Flow Solution (.zip) – Importable Power Automate flow to deploy in your environment.

Setup & Usage

Just import the flow into your Power Automate environment, upload your Excel file, and provide the required parameters when running the flow. The rest happens automatically; your SharePoint list, columns, and logs are all created seamlessly.