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.
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.
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.
Dataverse views enable us to define queries and filters in a way that is re-usable across multiple canvas apps and model driven apps. This post describes how to display data from Dataverse views in canvas apps, and how to refer to those views in formula.
With Dataverse, the syntax to filter a table based on a choice column may not be entirely intuitive. This post describes the methods we can use to filter tables based on choice values.
If a Power Platform update breaks features in the Dataverse designer (such as the table or view designers), and the option to open the classic designer is missing, it may be possible to carry on working by accessing the classic designer directly by web address.
When we build Power Apps to extend Dynamics 365, it's important to be aware of 'restricted tables'. These are tables that are fully accessible with a Dynamics 365 license only. This post provides an introduction to this topic.
A great feature with canvas apps is that we can offer users the ability to make audio recordings using the microphone control. It may not be obvious how to save and retrieve recordings so in this post, we'll walk through how to carry out this task against a Dataverse database
From a canvas app, we can connect to Dataverse databases that are hosted in different environments. This post describes how to accomplish this.
With Dataverse, the syntax to patch certain data types can look very complicated. In this post, we'll summarise the syntax to patch lookup, single choice, multi-choice, yes/no, single person/group, and multi person/group columns.
- Error - Unable to modify Dataverse tables with error message, Language id should not be null
- Formula - Transposing/converting rows to columns- an almost impossible task?
- Charts - How to create donut charts
- Settings - The easiest way to find environment id and other settings
- Admin - How to quarantine or block all users from running a specific app
- Learning - Learn Power Apps through the free Microsoft Virtual Training Day events (and receive a free exam)
- Formula - How to round times to the nearest x minutes
- Formulas - Review of how to write formulas using natural language
- Licensing - Microsoft 365 licensing price set to increase in March 2022
- SharePoint - Filtering lists by User() is now delegable
- Dates - How to get the start date from week number
- Data - How to remove/delete a field from a record
- Numbers - 10 examples of how to round numbers
- Dates - How to check if a year is a leap year
- Dates - How to get the week number for a given date
- Dates - How to get the nth weekday for a month
- Dates - How to get the last weekday for a month
- Forms - How to calculate values (eg sums and products) and store the results in SharePoint or other datasource