Add new column to excel

[cbgbala]

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

[Johnnyg]

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:

[cbgbala]

Hi Johnnyg,

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

Thanks,
Balakrishna 

[Johnnyg]

Hello Cbgbala,

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

Johnny