cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cbgbala
Frequent Visitor

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.
cbgbala
Frequent Visitor

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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,560)