Answered

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."

(0) Share

Report

Posted on by DaynaBee

309

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.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.
DaynaBee 309 on at

Like
a
(0)

Report
Copy link

Link copied!

@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")
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@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.
DaynaBee 309 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Thank you again.