Plural Name

(0) Share

Report

Posted on by eka24

20,923

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Nhelgren on at

Like (1)

Report

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.

Was this reply helpful? Yes No
Ram Prakash Duraisamy 5,593 Super User 2025 Season 2 on at

Like (3)

Report

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

Was this reply helpful? Yes No
JeffC1 27 on at

Like (2)

Report

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.

Was this reply helpful? Yes No
Fubar 8,338 Super User 2025 Season 2 on at

Like (0)

Report

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
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/web-api-service-documents#entity-set-name

Was this reply helpful? Yes No
singularTable 8 on at

Like (3)

Report

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.

Was this reply helpful? Yes No