Skip to main content

Notifications

Community site session details

Community site session details

Session Id : W0nHTJGVJbURyj/KPFOi6N
Power Apps - Microsoft Dataverse
Unanswered

Plural Name

Like (0) ShareShare
ReportReport
Posted on 10 Nov 2021 05:03:28 by 20,921

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

  • singularTable Profile Picture
    6 on 14 Jul 2023 at 19:15:19
    Re: Plural Name

    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.

  • Fubar Profile Picture
    7,852 Super User 2025 Season 1 on 24 Feb 2023 at 03:20:43
    Re: Plural Name

    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

     

  • JeffC1 Profile Picture
    27 on 23 Feb 2023 at 23:00:00
    Re: Plural Name

    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. 

  • Ram Prakash Profile Picture
    5,166 Super User 2025 Season 1 on 10 Nov 2021 at 19:19:11
    Re: Plural Name

    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

  • Nhelgren Profile Picture
    on 10 Nov 2021 at 18:16:24
    Re: Plural Name

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Microsoft Dataverse

#1
SadFox Profile Picture

SadFox 2

Overall leaderboard

Featured topics

Loading started