Showing results for 
Search instead for 
Did you mean: 
Post Prodigy
Post Prodigy

Add column to excel table

Hi All


I have a flow which creates an excel file in SharePoint in turn it then creates a table within that file which is all working as expected. However I need to add an element to the flow which creates a new column to that table based off one of the other columns currently within the table. The column I want to base to base it off of is a postcode column and what I also require it to do is split it at the first space.


Has anyone achieved this or know a way how to?

Super User
Super User


There is no Power Automate action that adds a column to a table (other than a key column).  You might try creating an Office Script for Excel and executing that script from Power Automate.




If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.


Helpful resources

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,303)