cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Kmayes
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?

1 REPLY 1
ScottShearer
Super User
Super User

@Kmayes 

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.

image.png

 

 

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

Scott

Helpful resources

Announcements
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)