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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (2,568)