Answered

SharePoint List Custom Form - Multiple Errors

(0) Share

Report

Posted on by Cbeene

PA Community, I need your HELP. I have a SharePoint list that I am attempting to build a custom form for. For some reason every card has an error message. In test runs the People Picker and Choice fields don't work, leading me to believe the issue is not at the card level but the overall form level. In the image attached you can see that the Choice field I am hovered over is stating the Choice field "Has some invalid arguments". Looking at the "Items" entry on the right shows where the field should be pointed to (Choices('Production Disposition Process'.Reason_x0020_For_x0020_Submissio)). This is the correct format but doesn't work here.

To test, I have exported this list as a template and created several versions of it. In some cases, the PowerApps form looks like this and doesn't work, in other cases there is no error and it works fine.

Categories:

Building Power Apps

All responses (24)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cbeene

You are most likely having an issue at the form level, not the individual columns.

1) What is the DataSource property on the form set to? It should be the name of the SharePoint List.

2) What is your Item property on the form set to? It should be set to SharePointIntegration.Selected

Also, view your data sources to make sure you are not experiencing any errors there.

I hope this is helpful and leads to a solution or another clue.
Cbeene 74 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes - Thanks for the reply. The DateSource properites appear to be correct. How do I check the Item Properties for the form itself?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cbeene

Click on the Form (easiest in the tree list on the left), then choose the Item property in the property dropdown in the formula bar.
Cbeene 74 on at

Like
a
(0)

Report
Copy link

Link copied!

In both versions of my test forms (one works, one doesn't) and in my actual form the Item and DataSource properties match and/or are correct. Thanks though.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cbeene

A couple other options to try:

1) Create a new screen and add a new EditForm there with the datasource and Item properties the same. If you still have errors at that point on the new form, then there is an issue with the DataSource and/or Connection in the App itself.

2) If there are no errors on the new screen and new form, then go back to the other screen and select the form, then ctrl-x is (cut), then ctrl-z (undo). Many times removing a control from PowerApps that has errors and then forcing it back in with an undo, will reinitialize the form and clear up all the issues.
Cbeene 74 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes - The new form has the same errors so I would assume it is the Datasource and/or connection in the App. Any Idea how to trouble shoot that?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cbeene

Let's just recap here a bit in a check list to make sure you've covered all the bases:

Working from the tree list -

- SharePointIntegration

   1) DataSource property is set to your SharePoint List?

- On your form screen and the SharePointForm

   1) DataSource property is set to your SharePoint List?

   2) Item property has a formula in it that refers to SharePointIntegration.Selected?

- In your DataSources (View-Data sources),

   1) You see your data source listed there and there do not appear to be issues with it (errors, warning icons, etc.)?

   2) You can choose the ... menu next to the datasource and click refresh and all is successful to do a refresh?

Check all of the above and let me know if any are not happening or displaying information as noted.

Also, hover over one of the red X's (preferably the very top one) and let me know what the error is that is reported.
Cbeene 74 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Doubled checked and I am a yes on all 5 items.
As far as error messages -
On a Single Line text box I see:

On a Choice field I get:
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Cbeene

Hmmm...going for the bigger guns now...

Go into your datasources list (View-Data sources) and remove the datasource to your SharePoint list. Then click on the add data source and choose your SharePoint connector and then the SharePoint list to add it back in.

You might also want to then delete and undo (as I described earlier) the entire form once you've added the data source back in.
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Cbeene ,

Could you please share a bit more about the issue?

Based on the screenshot that you mentioned, I think there is something wrong with the SP List connection within the custom form app.

Please check if you have changed some columns in your SP list. Please consider remove the SP list connection from this custom form app, then re-add a new connection to the SP List from the custom form app, then try it again, check if the issue is solved.

If the issue still exists, please consider remove the custom form from your SP list, then re-add a new one, then check if the issue still exists.

More details about removing custom form from a SP list, please check the following article:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/customize-list-form#delete-the-custom-form

Best regards,