Nice post on 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…
View original post 264 more words