Add column to excel table

Like (0) Share

Report

Posted on 25 Aug 2021 09:03:29 by Kmayes

786

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?

All responses (1)

Answers (0)

ScottShearer 25,236 Most Valuable Professional on 25 Aug 2021 at 16:11:58

Like (1)

Report

Re: Add column to excel table

@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.