cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Yemata
Level: Powered On

Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

I am customizing SharePoint form and when the form opens in PowerApps it opens with errors on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead." I cant figure it out.

 

 

 PowerAppsError.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

@Yemata 

Have you done any other customizations to anything in the form?

If not, you might consider deleting the form and then adding it back in, setting your datasource and then use that sae formula for the Item property.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

@Yemata 

Most likely an issue with the DataSource and/or the Item properties of the Form.

I would have a look at those and see if they are set properly.

The DataSource should be your list/datasource

The Item property should return a record from that datasource.

 

Any variations on those are going to cause you errors like this.

 

I hope this helps lead to a solution for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Yemata
Level: Powered On

Re: Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

@RandyHayes  

Thank you so much for the quick responce. 

That is what i thought too since the whole form has an issues, but couldnt figure out what is set wrong. You mentioned two things 

The Data source is My list ( colored green ) 

Here is what is on the Item   "If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('Status'),SharePointIntegration.Selected) 

 

I have noticed that the on the MaxLength property my data source/ the list name is not colored green but black .  DataSourceInfo('Status', DataSourceInfo.MaxLength, "Title") 

Super User
Super User

Re: Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

@Yemata 

Have you done any other customizations to anything in the form?

If not, you might consider deleting the form and then adding it back in, setting your datasource and then use that sae formula for the Item property.

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Yemata
Level: Powered On

Re: Customizing SharePoint form loads in PowerApps with Error on all fields " The function has some invalid arguments " and "Invalid argument type(Record). Expecting a table value instead."

@RandyHayes 

Awesome , thank you so mcuh for the solution . It worked.

 

Thank you again. 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,681)