cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerAsh
Regular Visitor

Choice columns error with SharePoint Forms

Hi,

 

I'm getting an error when customising SharePoint forms with Powerapps. The form itself works fine when using it in SharePoint (although some controls appear to have changed since I last used it) and all information is saved, however when I go in to edit it, I'm finding errors on any datacard linking to a Choice column.

 

Both locked and unlocked datacards in the form connected to Choice columns in the list were working fine last Friday, but today when editing, inputs that I think were previously just regular Dropdowns are now Combo Boxes, and all have the error "The data source supplied to the function is invalid" in the Items property. It's all connected to the right list, and the appropriate column names are input, and if I unlock the data card and retype the same expression into the items property for a second the error will go away but then the exact same message will return.Cat Sad

Capture2.JPG

 

 

The only way I've found to get rid of the errors is to change the input type to "Edit Lookup" rather than "Edit Selection" because if I select Edit Selection the same error will appear. I am confused because I thought that you could just use a regular dropdown control, rather than one that allows typing to filter the options (as that is what I had previously in the form, since there were only five or so options to choose from). 

Capture.JPGCapture1.JPG

 

I'd like to understand why it's suddenly just gotten upset with choice columns, and why I can't use a regular dropdown control in a locked datacard.

 

Cat Frustrated Ash

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Thorpe
Super User
Super User

There was a change a couple of weeks ago. Have you tried unchecking the choice field in the data pane then clicking data source refresh and then add the field back to the form? That is how I converted by drop down boxes to combo boxes and it seem to work well.

 

Here is the Blog post that talks about the Combo box change.

PowerApps update



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Jeff_Thorpe
Super User
Super User

There was a change a couple of weeks ago. Have you tried unchecking the choice field in the data pane then clicking data source refresh and then add the field back to the form? That is how I converted by drop down boxes to combo boxes and it seem to work well.

 

Here is the Blog post that talks about the Combo box change.

PowerApps update



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

So are you saying every powerapp form I have that uses a choice field getting t his odd error about data source supplied to function is invalid I have to convert to a combo field?  This was working.. is just stopped?

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (2,074)