Manage CDS Entity Data – Microsoft PowerApps Office Add-In

Nice post on Microsoft PowerApps Office Add-In

Bansal Blogs - Dynamics 365, PowerApps, Microsoft Flows, Power BI


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…

View original post 264 more words

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Please share your thoughts

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.