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 Africa Challenge 2022

Power Apps Africa Challenge

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

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,135)