cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbgbala
Advocate I
Advocate I

Add new column to excel

Hi Team, Power automate 

I just wanted to add a column to my excel file.

Note: my excel file doesn't have any tables and excel file has headers first later rows and columns.

I have tried with add a key column but it didn't worked due to excel doesn't have table.

 

Thanks,

Balakrishna Reddy

3 REPLIES 3
Johnnyg
Community Support
Community Support

Hello cbgbala,

Yes, you must define a table range before action "Add a key column to a table". You could create one action 'create table' with hardcoded table range as below or you could access your excel file to manually insert and define the table range:

Johnnyg_0-1629622095504.png

Johnnyg_1-1629622253532.png

 

 

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Johnnyg,

Thanks your reply. I have tried the above steps but it's failing.

Thanks,
Balakrishna 
Johnnyg
Community Support
Community Support

Hello Cbgbala,

Would you share your flow definition and failling exception?
Best Regards

Johnny

Best Regards,
Johnny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

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

New Process Advisor Capabilities carousel.png

Read the blog for the latest news

Read the latest about new experiences and capabilities in the Power Automate product blog.

PA Survey Carousel Image.png

We want to hear from you!

If you are a small business ISV/Reseller, share your thoughts with our research team.

Users online (2,985)