cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User
Super User

Re: Choice columns error with SharePoint Forms

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
Highlighted
Super User
Super User

Re: Choice columns error with SharePoint Forms

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

Highlighted
Helper IV
Helper IV

Re: Choice columns error with SharePoint Forms

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
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,815)