Trust This add in

When you use the Common Data Service as a data source it can be quite cumbersome to edit data.

Most of the times I used to just create a form in a Canvas App and then editing data is easy.

Creating some quick edit forms is okay, however if you just want to edit some data if feels like a development task that you could do without.

Edit Data related to an entity

There is an easier way to edit data.

Edit In Excel option

The Edit data in Excel gives you the easy option to open the data in an excel table.

New Office Add-in

First you will get the New Office Add-in dialogue.

Trust This add in

You could just quickly click on the Trust this add-in or if you are a bit more paranoia then have a look at the Details.

Sign In

Now you will have to sign in.

Sign In Common Data Services

The nice thing is that your environment used will be recognised so there is no need to worry about that.

Publish your data

Now Excel will open the data for you and you can save the Excel spreadsheet when you are done.

Connected to Common Data Services

Now you will find that the data in your apps using the data is not updated yet!

You will need to hit the Publish option shown above and your data is now updated in the Common Data Service.

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using

Leave a Reply

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

%d bloggers like this: