Manage CDS Entity Data – Microsoft PowerApps Office Add-In

Microsoft PowerApps Office Add-In enables user to read, modify and insert data in CDS environment. Add-In is available for download here for free, or you will be prompted to install Add-In for first time when you open entity data in excel from PowerApps portal. Add-In establishes connection to PowerApps OData service.

Note: Add-In is compatible with Office 2016 or later versions only.

Using Microsoft PowerApps Office Add-In in excel you can create, update and delete rows. Let’s explore this Add-In.

• Login to PowerApps web portal. Click on Entities under Data tab on left side menu.
• Select any entity. In my case its “Company Products”.
• Click on Open in Excel option on top menu which will export selected entity’s data in excel. Excel will ask you to install Add-In if you are using it for first time or will load Add-In for you.

• Create Rows – To create new rows, click…