How to create table in Excel through Microsoft Power Automate.
Before starting if you have your excel sheet in your local system them you have to upload it into OneDrive or SharePoint. In this blog post we will see how it will work with OneDrive.
- Now open OneDrive in your browser and click on “Add new” and then click on Excel Workbook.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_1.png)
- Now this will open a blank worksheet in a new tab. Here edit the sheet name and paste your excel data from the excel sheet which is in your local computer.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_2.png)
- Now open Power Automate in another tab and create an instant flow with the manual trigger.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_3.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_4.png)
- Add a new step just by clicking on “New step” button.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_5.png)
- Select “Excel Online” as a connector.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_6.png)
- Select “Create table” in action.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_7.png)
- Enter all the details in their respective fields, you can refer to below image. Then click on "save". Once successfully saved we’ll hit on Test button to check this flow’s working.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_8.png)
- Meanwhile you all can see currently this excel sheet is not formatted as a table.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_9.png)
- Meanwhile you all can see currently this excel sheet is not formatted as a table.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_10.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_11.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_12.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_13.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_14.png)
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_15.png)
- Once the flow runs successfully you’ll get notified.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_16.png)
- After a successful run of flow, the excel sheet will be formatted as a table.
![createexcelthroughpowerautomate](/images/blog/power automate/createexcelthroughpowerautomate/screenshot_17.png)
In this guide, we've walked you through the step-by-step process of creating tables in Excel using Microsoft Power Automate. We hope you've found this tutorial helpful in harnessing the power of automation to streamline your data management tasks.
As you dive deeper into the world of Power Automate, you'll discover that the possibilities are virtually limitless. This is just the beginning of what you can achieve with this robust tool. From data collection and processing to report generation and task automation, Power Automate can be your trusted ally in simplifying and enhancing various aspects of your business operations.
As you continue your automation journey, keep an eye on new features and updates from Microsoft, as Power Automate evolves to offer even more capabilities and integrations.
Happy automating!
If you have any doubts or questions related to this blog, you can Contact us by Email: info@voxtus.com
Abhishek Kumar
Power Apps Consultant
Power Automate Related Posts
![PowerAutomate](/images/logo/PowerAutomate.png)