cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hbbfzs
Frequent Visitor

Combobox only displaying delimeters after form submit

Hi all,

 

I’m currently having a problem with the comboboxes in that they only show the delimiters in the app after submitting the form (e.g. I would expect to see “Item 1, Item 2, Item 3” and instead I see “ ,  , , ”). It seems to be a problem for both single select and multi-select comboboxes, but not for the drop downs, free text fields or radio buttons that are also within the form but display selected results correctly. Even stranger is that the data is recording correctly in the back end Sharepoint list (i.e. “Item 1, Item 2, Item 3”).

 

I have included the objects and properties that I think may hold the key to the mystery below, but remains unsolved (due to a lack of solving by me). Any assistance or ideas will be greatly appreciated.

 

Object

Property

Formula (fx)

cbxOperatingCountries(combobox)

Item

SortByColumns(Filter('Country risks',('Country risk level'.Value = "High" Or 'Country risk level'.Value = "Severe" Or 'Country risk level'.Value = "None")),"Title").Country

cbxOperatingCountries(combobox)

DefaultSelectedItems

RenameColumns(Filter(Split(Parent .Default,","),!IsBlank(Result)),"Result","Value")

cbxOperatingCountries(combobox)

Reset

false

Data Card Operating Countries

Default

ThisItem.OperatingCountries

Data Card Operating Countries

Update

Concat(cbxOperatingCountries.SelectedItems, Country & ", ")

Submit button

OnSelect

SubmitForm(Form1)

Form1

DataSource

Sharepoint List 1

Form 1

OnSuccess

Set(glbCurrentRecord, Self.LastSubmit);

Form1

Item

Patch(Coalesce(glbCurrentRecord, Defaults('Sharepoint List 1')),{ID: Blank()})

 

1 REPLY 1
hbbfzs
Frequent Visitor

Just bumping this post so hopefully some new eyes can see it!

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,555)