Add column to dynamic excel

[eddybo]

Hello,

I have exported a dynamic excel from my view, I add some macro to this excel, but I need more data who exists in my entity, can I add column to my dynamic excel for get this data and how add this column for this.

Exemple :

I have a column "First Name" in my entity, but the first time I exported my dynamic file I didn't add this column to the excel, I want to add this column now without re-export my excel, I want to keep my macro and sheet modification, the data actualisation work fine in my excel.

Thanks.

[mdevaney]

@eddybo 
What is a dynamic excel file and where are you trying to add a column?

[eddybo]

https://docs.microsoft.com/en-us/powerapps/user/export-excel-dynamic-worksheet 

I just want to add a column in my excel file who corresponding a fields in my entity (CDS), in my case I want to add the field "First Name" and "Last Name"

[pre]

Hello @eddybo 

Check the below link, it should give you some inputs on your requirement::

https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/