Microsoft 365 Excel in Action flow - After creating a table in an action flow, how do I name the columns? When I create a table, the columns are named Column1, Column2, Column3 etc.

Microsoft 365 Excel in Action flow - After creating a table in an action flow, how do I name the columns? When I create a table, the columns are named Column1, Column2, Column3 etc. I am able to fill the rows with data from the Celonis Query but it would be great to name the columns. "Update Worksheet row" does not work for the first row, where the headers are and even if I select Table has no header. Add worksheet row requires a table on the sheet, so it does not allow me to change the top row. What can I do?

Page 1 / 1

Celonis Excel On the picture you see that updating worksheet rows is only possible from row 2, so not possible to update the header.

Hi,

I do not know if this idea is the best and the simplest way but it works. Hopefully it will be useful for you as well. The idea is that you need to first add values to first row and then create table using first row as your header:

You 'Add/Update a Worksheet Row' and in first row add headers you would like to see in your final table
Create Table using ''Add Table' and as address define rage of your headers. Additionally in 'Has Headers' make sure that Yes is chosen.
Using 'Update a table' you will be able to add new content to your table.

Regards,

Marcin

Thank you very much for your comment! In the module that I have, Add a worksheet row only works if there already is a table on the worksheet. With this module it's not possible to add a worksheet row on an empty worksheet. Do you have any idea, how I could get the (Advanced) module that you have? If yours works on an empty sheet, then that would solve the problem.