News and Announcements icon

Power Platform CommunityForums Power Automate - Building Flows Add new column to excel

Power Automate - Building Flows

Unanswered

Add new column to excel

(0) Share

Report

Report

Posted on by 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

All responses Img

All responses (3)

Answers Img

Answers (0)

Sutherland on at

Like (0)

Report

Re: Add new column to excel

Hello Cbgbala,

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

Johnny
cbgbala on at

Like (0)

Report
Re: Add new column to excel

Hi Johnnyg, Thanks your reply. I have tried the above steps but it's failing. Thanks, Balakrishna
Sutherland on at

Like (0)

Report

Re: Add new column to excel

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:

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Leaderboard > Power Automate

#1

Michael E. Gernaey 497 Super User 2025 Season 1

#2

David_MA 436 Super User 2025 Season 1

#3

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans