Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Error Handling
Unanswered

Invalid argument type (Text). Expecting a Table value instead.

(0) ShareShare
ReportReport
Posted on by
Hello,
 
I am creating new buttons on the Command bar in a Model Driven app. that will clone Dataverse records from within the app.  This has worked well on four out of the six tables in the app.  The two tables that are failing are called 'Product' and 'Contract Option'.
 
This is what a successful button looks like on one of the tables -
 
 
This is the error on the 'Product' table.  The display name of the 'Primary name column' is also 'Product' but the logical name is cre8f_Name.   So, it seems to me that the argument is getting the name (value?) of the table.
 
 
This is the error on the 'Options' table - the 'Option No.' field is the display name for the 'Primary name column' and 'cre8f_newcolumn' is the logical name and it is a Text field.
 
 
I have tried different display names but the changes are not visible or accepted when writing the function.
 
I'm new to PowerFx and have been working this problem for a week.  Any help will be greatly appreciated.
  • ronaldwalcott Profile Picture
    3,810 on at
    Invalid argument type (Text). Expecting a Table value instead.
    Please note that you should avoid using column names that are the same as the table name,
  • BhargavPatel Profile Picture
    658 Super User 2025 Season 1 on at
    Invalid argument type (Text). Expecting a Table value instead.
    @phairdinkm please verify you are using the plural name of each table, and try to patch value to a text column (such as Name) instead of patching a value to GUID or Auto Number columns. 
     
    For example:
    ForAll(Self.Selected.AllItems,Patch(Products,Defaults(Products),{Name:ThisRecord.Name}));
     

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

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics