cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Unable to submit form due to issue with combobox (after saving in version 3.19062.18)

Today I suddenly have the following issue.

I open a form in edit mode with a sharepoint record.

In the form is a combobox. In the interface the combobox shows the selected item as the value from my sharepoint record.

Capture.JPG

 

But when I then try to submit the form. I get the error that an entry is required. (It is set as required in sharepoint).

Error.jpg

Only when I manually reselect the item from the combobox can I submit the form.

I don't remember having this issue earlier this week. So it may be releated to the upgrade of 3.19062.18. Or am I missing out on something?

 

I created a label and and let it show the Combobox.Selected.Value. It is blank.

Only when I reselect the item in the combobox does the label show the selected value.

It appears the the connection between what is shown as the DefaultSelectedItems and the value of Combobox.Selected.Value is broken.

 

Is anyone else experiencing this problem.

I need it fixed asap so i can continue developing my app.

 

kr,

Casper

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Thanks for the help. I found the solution.

It had nothing to do with the version of Powerapps. I thought it worked in an ealier version but it did not, so probably I thought I tested it before and did not.

What did couse the issue was that when setting the defaultselectedItems for a Combobox just setting a value from an Item in the source Items by using ["itemvalue"] (In my case [Parent.Default]) wasn't enough eventhough the value was in the source items.

To correctly set the defaultselecteditems I had to use the following:

LookUp(Collection, Value = Parent.Default) or you could use the Filter function to select multiple items.

View solution in original post

8 REPLIES 8
HendosMark
Frequent Visitor

I'm experiencing issues with all commands related to Forms (submitform, resetform etc)

 

It appears the new update to Powerapps 3.19062.18 is causing problems with this functionality, hopefully they will get on the ball soon

 

Mark

AdamD
Helper III
Helper III

What is the DefaultSelectedItems property set to in the combobox? What is the information stored in the combobox's Items property?

Anonymous
Not applicable

DefaultSelectedItems is set to [Parent.Default] which in turn is set to ThisItem.Year.

As you can see from the sreenshot the value for the DefaultSelectedItems is correctly read from my Sharepointlist otherwise the combobox would be empty.

Capture2.JPG

As you can see the value is correctly displayed in the selected items list. But saving results in the aforementioned error.

Comboboxes can be tricky. You can set a value that exists outside of your items list to the DefaultSelectedItems property in your combobox, and it will display just fine but won't save. That's kind of what I'm thinking is the problem, there's a disconnect between the value being displayed in the DefaultSelectedItems and how it relates to the available list of items your combobox populates. Is the source of your Items list from the same SharePoint list as choices or from a different source?

As an example, I can have a combobox with items ["1","2","3"] to select from, but I can configure the DefaultSelectedItems property to ["4"] and it will look like 4 is successfully selected as an item in the combobox during use.

Anonymous
Not applicable

Thanks, I will look into it and let you know. It is from a different source but is has originaly been written from that source, so should be identical. As you can see the selected item is in the list.

Fortunately for now my workingday is over. So I will continue with it later.

 

kr,

Casper

Anonymous
Not applicable

Thanks for the help. I found the solution.

It had nothing to do with the version of Powerapps. I thought it worked in an ealier version but it did not, so probably I thought I tested it before and did not.

What did couse the issue was that when setting the defaultselectedItems for a Combobox just setting a value from an Item in the source Items by using ["itemvalue"] (In my case [Parent.Default]) wasn't enough eventhough the value was in the source items.

To correctly set the defaultselecteditems I had to use the following:

LookUp(Collection, Value = Parent.Default) or you could use the Filter function to select multiple items.

Hi,

 

I am facing the same issue, my values are saving in sharepoint and autopopulating as well from sharepoint.

while editing value is autopopulating but anclick of submit giving error as "value is mandatory".

Can you please elaborate the formula which you have used.

LookUp(Collection, Value = Parent.Default)

What should be used for Collection?

And what is the Value?

 

Please suggest. 

Thanks in advance.

This worked great for the lookup function...however, not able to make it work with Filter formula for multi-selection. Any thoughts on that please?

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,466)