Categories: Microsoft Power Apps

Quickly edit data in your Common Data Service

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.

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.

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.

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.

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.

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

Recent Posts

8 top reasons to use Dataverse or SharePoint lists in the Power Platform

Why would you use Dataverse, if SharePoint lists gives you the option to avoid premium…

6 days ago

Filter by calculated fields in SharePoint using Power Automate

When you read items from a SharePoint list and you want to filter by calculated…

1 week ago

Expected String but got Null, when calling a flow from a Model Driven app

A few weeks ago I looked at calling flows from model driven apps. And for…

1 week ago

Get all your broken connections using Power Automate

To get all your broken connections in the Power Platform can be a challenge. In…

2 weeks ago

Customer Voice a.k.a. Forms Pro the database behind the magic

If you call Customer Voice still Forms Pro or not, have you ever looked into…

2 weeks ago

Many running flows in Power Automate

Recently I noticed that some of my flows end up with many running flows. Types…

3 weeks ago