Hi everyone
What is the best way to deal with Plural Table name that is not recognized in Power Apps.
I created a Table "ProductName" in dataverse but in power apps I have "ProductNames".
Thank you
The fact that Microsoft felt the need to add a plural name and treat it differently is absurd.
Microsoft once again making things unnecessarily complicated.
When saying 'Plural' name be careful, Name and Plural Name are able to be set by and changed by you when a Table is created/altered. If you are wanting to make oData queries etc the name you are looking for is the EntitySetName - by default this may be the Plural Name but as per the doco you cannot rely on it being so (have to watch out for renamed tables and it can also be changed by code) see
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/entity-metadata#table- names
This is horrible and makes migration from SharePoint to Dataverse impossible on an existing PowerApp. Seriously, I don't understand why non-value-added layers of complexity are being added. IT IS A TABLE NAME! Every time I try to make a move to dataverse, I find yet another ridiculous roadblock.
Dataverse, import from SP online.
PowerApps, drop SP data source table / list.
Powerapps, add dataverse table. Doh, its plural (app broken).
Go to dataverse, edit plural name to remove the RIDICULOUS plural form that PowerApps defaults to! Go back to Powerapps, add table from dataverse.
This is completely irrational for an app built on dozens of tables.
Hello @eka24,
Adding to @NHelgren comments
Please find the places below where we are using Plural name
1. Odata Query
2. Web Api
3. Flows
Singular Name:
1. Display Name
2. Fetch XML
3. C# Code for Crud Operations
Please mark as Answer if it is helpful and provide Kudos
Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Blog : https://microsoftcrmtechie.blogspot.com
Hi @eka24 , the use of plural vs singular names depends on what you are doing. If you are creating/viewing/modifying a table then the singular name is used because you are taking action on one thing. If you are working on an app, flow, relationship, you are interacting with multiple rows on a table so plural is used.