Category: Dataverse

Dataverse - How to set yes no values with checkbox- Walkthrough

This post walks through how to set a Dataverse yes/no field with a checkbox rather than a dropdown.

Dataverse - Add image column missing when creating table - how to fix

If you can't find the option to add image columns to a new Dataverse table, here's the first thing to try.

Data - How to view the progress and status of a Dataverse CSV/Excel Import

When users import Excel data from a model-driven app table, where can we find the import results? This post describes where to look.

Error - Diagnosing the error "Network error when using the Patch function" when saving data with a form

A confusing error that can occur is the error "Network error when using Patch" when attempting to save a record by calling the SubmitForm function. This post explains a possible cause of this error.

Dataverse - How to work around the error "multiple levels of many-to-one relationship expansion aren't supported"

Have you encountered the error "multiple levels of many-to-one relationship expansion aren't supported" when attempting to write some formula? If so, this post clarifies the meaning of this error and describes how to work around the issue.

Dataverse - The easiest way to modify Dataverse data outside of Dataverse and Power Apps

If you need an easy way to add, edit, and delete the records in Dataverse, this post describes a simple method that you can use.

Dataverse - How to use a checkbox control a set a yes/no field in Dataverse

For users new to Dataverse, a common difficulty is how to build a form that sets Dataverse Yes/No Boolean fields with a checkbox or toggle control. This post describes how to configure such a form.

Dataverse - How to create Entity Relationship diagrams

Entity relationship diagrams can help us visualise and better understand the schema of a database. In this post, we look at how to create an ER diagram for a set of Dataverse tables.

Dataverse - How you can more quickly bulk update data using the SQL language

If you need to want to update records in a Dataverse database using SQL commands, one way to carry this out is to use XrmToolBox and the SQL4CDS plugin. This post provides a summary of how this works.

Dataverse - How to fix the bug in the 'Business Rules' editor that prevents numeric values from saving

When there is a mismatch between the language of Dataverse and the language of the editor, business rules can fail to save with an error that looks like this - 'Enter a value from -922,337,203,685,477.00 through 922.337,203,685,477.00'. This post describes a workaround for this issue.

Dataverse - What are the benefits, and how to create formula columns

Yesterday, Microsoft announced the preview release of formula columns for Dataverse. This post summarises the benefits of formula columns and walks through the steps of how to define a formula column.

Dataverse - How to sort the available choice items from a choice column

With Dataverse choice columns, there's often the need to sort dropdowns in alphabetical or custom sequences. This post describes how to carry out this task.

Error - Unable to modify Dataverse tables with error message, Language id should not be null

Au unusal problem you may encounter is the inability to modify Dataverse tables. During any attempt to modify or to save a table, the designer shows the error 'Language ID should not be null'. Here's what to do if you experience this problem.

Dataverse - How to retrieve FetchXML or SQL for Dataverse views

With, Dataverse It's possible to define views. Dataverse stores view definitions in a system table called 'Views'. We can interrogate this table to retrieve the SQL or the FetchXML for a table and this post examines this setup in more detail.

Data - Why is Dataverse so fast?

One reason why Datavese performs so quickly, compared to other data sources (such as SQL Server, SharePoint, and Excel), is because Power Apps can connect to Dataverse in a more direct way. This post describes this behaviour in more detail.