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.

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:

1. You 'Add/Update a Worksheet Row' and in first row add headers you would like to see in your final table
2. Create Table using ''Add Table' and as address define rage of your headers. Additionally in 'Has Headers' make sure that Yes is chosen.
3. 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.

You might try import blueprint from Celonis Action Flow Templates and adjust it to your needs. Here you have example of such template:

Send Excel File via Mail (celonis.com)

This is the part you should be interested in:

Additionally please find below instruction how to import blueprints

How to deal with Blueprints (celonis.com)

That's the solution! Perfect! Thank you!