cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Black_Magic100 Helper I
Helper I

Invalid argument type (GUID). Expecting a table value instead.

I seriously can not figure out how to fix this error.  My google search is filled with purple links because I have checked every single article imaginable and yet I still can not fix this problem.  I have absolutely no idea why this is not working.  

1 ACCEPTED SOLUTION

Accepted Solutions
aorphan Resolver I
Resolver I

Re: Invalid argument type (GUID). Expecting a table value instead.

@Anonymous has the solution, but he didn't explain it. Let me give you the whole solution and explanation on how to fix this. I was also experiencing this problem and it was annoying the heck out of me and I couldn't find a solution so I had to solve it myself.

screenshot1.png

This error occurs because of the way Powerapps auto-generates code for Data Cards’ MaxLength property. Notice the generated property value here:
screenshot2.png

Well, evidently there is an issue with the reference to my entity name ‘FCO Technicians’. Specifically, the reference is ambiguous because the Entity name conflicts with the system-generated Unique Identifier (aka primary key):
screenshot3.png
The fix is to use the disambiguation operator like this (requires unlocking the Data Card):
screenshot4.png

More on the disambiguation operator here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators#disambiguation-operator

Be wary of this problem and be careful naming your entities going forward. Ultimately, this is a bug with Powerapps auto-generating bad code and should be fixed by Microsoft at some point.

If this solved your problem, kindly mark it as the solution and vote it up! 

View solution in original post

10 REPLIES 10
Super User
Super User

Re: Invalid argument type (GUID). Expecting a table value instead.

Hi @Black_Magic100 

Where are you seeing this error? What formula are you using? Can you post a screenshot?

Black_Magic100 Helper I
Helper I

Re: Invalid argument type (GUID). Expecting a table value instead.

I'm not using any formula. Just pulling from a very simple entity I created and every single **bleep** time I get this error. It's just a text/string attribute
Highlighted
Thierry11
New Member

Re: Invalid argument type (GUID). Expecting a table value instead.

I'm having a similar issue.
guidinvalid.PNG

When I hover over the X, the error tells me: Invalid argument type (GUID). Expecting a table varibale instead.
When I hover over the DataSourceInfo, the error tells me: the Function DataSourceInfo has some invalid arguments. I've followed the DataSourceInfo documentation step by step, I'm not sure what is going one. 

Thank you

Anonymous
Not applicable

Re: Invalid argument type (GUID). Expecting a table value instead.

Hi Thierry,

Just replace 'Feedback' with '[@Feedback]'. That should solve the problem.

Black_Magic100 Helper I
Helper I

Re: Invalid argument type (GUID). Expecting a table value instead.

I fixed this issue 2 months back by simply changing something in the settings, but I accidentally had to get rid of my app and republish it and it messed up again.  This fix does not work though.  It gives another error "The function 'DataSourceInfo' has some invalid arguments.

 

 

aorphan Resolver I
Resolver I

Re: Invalid argument type (GUID). Expecting a table value instead.

@Anonymous has the solution, but he didn't explain it. Let me give you the whole solution and explanation on how to fix this. I was also experiencing this problem and it was annoying the heck out of me and I couldn't find a solution so I had to solve it myself.

screenshot1.png

This error occurs because of the way Powerapps auto-generates code for Data Cards’ MaxLength property. Notice the generated property value here:
screenshot2.png

Well, evidently there is an issue with the reference to my entity name ‘FCO Technicians’. Specifically, the reference is ambiguous because the Entity name conflicts with the system-generated Unique Identifier (aka primary key):
screenshot3.png
The fix is to use the disambiguation operator like this (requires unlocking the Data Card):
screenshot4.png

More on the disambiguation operator here: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/operators#disambiguation-operator

Be wary of this problem and be careful naming your entities going forward. Ultimately, this is a bug with Powerapps auto-generating bad code and should be fixed by Microsoft at some point.

If this solved your problem, kindly mark it as the solution and vote it up! 

View solution in original post

Black_Magic100 Helper I
Helper I

Re: Invalid argument type (GUID). Expecting a table value instead.

ahhh okay so in my case I did not need the single quotations, which was what was causing the second error that was populating.  Thanks!!

Black_Magic100 Helper I
Helper I

Re: Invalid argument type (GUID). Expecting a table value instead.

Okay I actually spoke slightly to soon.... how do you fix the issue for dropdowns in edit forms?

 

The exact same erorr is now populating in the "AllowedValues" property as there is no MaxLength property.

 

Here is my code inside:

 

DataSourceInfo([@LineItems], DataSourceInfo.AllowedValues, "cre88_category")

 

"The code above fixed the GUID table error, but then I get the "The function 'datasourceinfo' has some invalid arguments"

AzureLearner
Frequent Visitor

Re: Invalid argument type (GUID). Expecting a table value instead.

Hello,

 

I am facing same error for MaxLength .

I have changed it to - DataSourceInfo([@Table1],MaxLength,"Id") , still I can see same error.

Is there any other way to fix it?

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (7,271)