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.
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:
Would you share your flow definition and failling exception?
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.