CDS - Button open in Excel

[Cotymax]

Hi,

I dont know why, I canot see the buttons "Open in Excel", "Import Data", "Export data" and "Export template" on my entities. It is the same problem on custom entities and default ones.

I have tried to do it on several environments (trial environment). I have a Plan 2 Powerapps trial licence.

Does anybody know what do I have to do to be able to see these buttons to open datas in Excel?

Enclosed, screenshots of what I see on my CDS.

Thanks for your help !

[CWesener]

Hi @Cotymax - thanks for reaching out. The two screen shots are different versions of the Common Data Service. The Open in Excel and Import/Export features have not yet been released on the latest version (top screenshot).

We are in the process of finalizing these items now. When they are available - they will be in the command bar next to Add Field and Get Data.

If you're trying to import data - you can use PowerQuery by clicking "Get Data"

Thanks,

Clay.

[Cotymax]

Hi Clay,

Thank you for your answer.

Well, powerquery is powerfull to import mass datas but when we want to work on datas and do some quick modifications, it is not very practical... I am eager to use the "open in Excel" option !! 🙂 Do you know approximatively when will it be fonctionnal again ?

Regards,

Maxime.

[CWesener]

Hi @Cotymax - we are actively working on it at the moment, I hope to have it released in the coming weeks.

[Impavidus]

Any news on this feature? Thank you in advance!

[CWesener]

Open is Excel is back, enjoy! https://powerapps.microsoft.com/en-us/blog/cds-for-apps-excel-importexport/