For some occasions you need to use the logical names of Dataverse fields and the set name of Dataverse tables.
For example, in Fetch XML Queries and OData filters, you need to use the logical name of the fields you want to filter on. You can always use other tools such as advanced find or the XRM toolbox, to generate your queries but from time to time you need to know the logical name of the field.
Same goes for the tables. From time to time, you need the set name for example in Power Automate to update lookup fields in your data. Normally, you can just append an 's' to the name of your table if you used the best practice of creating every table in English and with a single name. In this case, and in the case you did not change anything while creating the table, the Microsoft standard is to use the plural name of the table.
E.g. table name: publisher_order -> set name: publisher_orders
However, more often enough the best practice is not applied and you don't want to guess the set name of the table.
Luckily, Microsoft added some nice features not thaaaat long ago.
Let's start with the field. To get the logical name of a field, you need to open the table it exists in, click on the three dots of the field, select Advanced, select Tools, select Copy logical name:
That's it! Easy huh? Of course, you could have just read the the logical name 'tppd_orderstatus' in the Name column but you know as good as I do that we humans make spelling mistakes and sometimes the names are longer as the columns are wide.
Sadly, we cannot just select the name in the column and copy and paste it but I am very happy with the solution Microsoft offers.
For tables, it's similar.
To get the set name of a table, you need to open the solution it exists in, click on the three dots of the table, select Advanced, select Tools, select Copy set name:
Summary
Have the best practice in mind when you create tables that their names should always be in English and singular. And if you want to get the logical name of fields or the set name of tables, you can do this by clicking on the three dots and follow the pictures above.
Comments