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.

Power automate tips 768x460 v2.png

Restore a Deleted Flow

Did you know that you could restore a deleted flow? Check out this helpful article.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,162)