cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Iantaylor2050
Helper V
Helper V

ComboBox throws entry is required validation error on EditForm SharePoint

Hi All,

 

I have EditForm in Powerapps which loads item from SharePoint. There is a combobox called Event in the form, where particular SharePoint item Event Value is correctly loaded.

 

3.JPG

 

DefaultSelectedItems is {Vaue:ThisItem.Event}, Default is blank. Items Property is set to DataSourceName.Event

 

2.JPG

 

In the data card update property value of Event, it is set to ComBox3_1.Selected.Event which is correct. 

 

1.JPG

 

However when I try to save the form, it throws validation error "Entry is required" for Event combobox, despite its preselected with the value. Once I reselect the value in combobox, the error goes away. Any idea on how to solve this error. 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @Iantaylor2050,

Do you mean that the Combo Box has the error message even when there is a value within, the required validation not working?

Could you please tell me more about your sceanrio?

I have a test and the situation is confirmed on my side. I think this is a problem caused by inconsistent data structures. 

Modify your formula in the DefaultSelectedItems as below:

{Event:ThisItem.Event}

Hope it could help.

Regards,

Qi

Best Regards,
Qi

View solution in original post

5 REPLIES 5
indhaa
Impactful Individual
Impactful Individual

What happens if you change DefaultSelectedItems  of combobox to ComboBox3_1.Selected.Value

and the data card Update property to ComboBox3_1.Selected

 

v-qiaqi-msft
Community Support
Community Support

Hi @Iantaylor2050,

Do you mean that the Combo Box has the error message even when there is a value within, the required validation not working?

Could you please tell me more about your sceanrio?

I have a test and the situation is confirmed on my side. I think this is a problem caused by inconsistent data structures. 

Modify your formula in the DefaultSelectedItems as below:

{Event:ThisItem.Event}

Hope it could help.

Regards,

Qi

Best Regards,
Qi

Hi @v-qiaqi-msft 

 

I tried the same but still it doesn't work. It again throws the validation error "Entry is required".

 

It is an Editform which loads the data from SharePoint submitted in the NewForm. All other fields working fine except the combobox field.

 

Even tried with {Value:Parent.Default} and {Result:Parent.Default}. Still doesn't work. Any idea what could be the issue ?

kmsdove
Advocate I
Advocate I

I too have struggled with the nuances of the combo box.  There are a lot of resources out there, however not one has directly referenced this issue.  Even the super user blog on one of these comments.  If you still require a solution I believe I was able to finally overcome this issue with the error.  I use a combo box to retrieve a list of items (in a powerapp customize form app).  I deleted the datacardvalue.text and replaced it with a combo box.  That gets tricky on the edit portion of the user function. 

HagarAR
New Member

I've been searching for a solution for this issue for the past three day the thing that works for me is:

 

setting the DefaultSelectedItems of the combobox to 

LookUp(ListName, ColumnName = ThisItem.ColumnName)

 

in my case I used Combobox to read from a column called JobTitle from a 'JobTitles' SP list

LookUp(JobTitles, JobTitle = ThisItem.JobTitle)

 

right now I don't get the error "JobTitle is required" in the edit mode 

 

Note: I had to Publish to sharepoint list and close the list and open it again in new tab to see it doesn't through error message in edit mode

 

reference: Power Apps Combo Box DefaultSelectedItems - YouTube

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,141)