cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Saego
Level: Powered On

Issues with "Default" in Combobox

Hi there,

 

As the title suggests, I'm having trouble with the default in Combobox. 

So I have 3 frames: a browse, a detail (view) form and an edit / add form.

When people want to edit a field, I want the comboboxes, dropdowns and datumpicker to show the old data. I've got it working for the dropdowns and datumpicker, but the comboboxes doesn't seem to work. Everytime it displays: "Search items" instead of (for example) a customer.

 

 

I tried Parent.Default, but that doesn't work. It gives a red circle with a cross inside it which says something about that it expects the type of Record, but this rule produces incompatible value from the type Number. 

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
mohitawasthi04
Level: Power Up

Re: Issues with "Default" in Combobox

Hey,

 

We can use the below formula in the defaultSelectedItems , the catch is it accepts a record value and not a single data value in the control -->

Filter('Table', Id = Gallery.Selected.Id).ColumnBoundToCombobox

12 REPLIES 12
Community Support Team
Community Support Team

Re: Issues with "Default" in Combobox

Which property you are working with the ComBo Box control?

The Default property, or the InputTextPlaceholder property?

 

The Search Item is defined under the InputTextPlaceholder property, so if you would like to have it to be displayed as the default user name, then you may take a try to set the 

 

InputTextPlaceholder property with

Gallery.Selected.Customerfield.DisplayName

and the Default property set to:

Gallery.Selected.Customerfield

More information, see:

Combo Box in PowerApps

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Saego
Level: Powered On

Re: Issues with "Default" in Combobox

Hi Michael (@, thanks for your answer. 

 

I think I explained it wrongly. I will add some more information below with properties from the Datacard and Combobox.

 

I have a Datacard (DataCardClient).

Default:

Empty

 

Update

LookUp('[dbo].[tbl_Clients]'; Name = ComboBox2.Selected.Name; ID)

 

AllowedValues

DataSourceInfo('[dbo].[tbl_Voyages]';DataSourceInfo.AllowedValues; "Clients_ID")

 

And next the properties of the ComboBox (ComboBoxClient):

DisplayFields

["Name"]

 

SearchFields

["Name"]

 

Items

'[dbo].[tbl_Clients]'

 

Default

Empty

 

DefaultSelectedItems

Empty

 

------------------------------------

So when I choose the client, it saves and it's viewable in de view form (and in the SQL database) but when I want to edit that later, the combobox is emtpy and shows the text from InputTextPlaceholder, which is not what I want. I want it to show the value which I chose before.

I hope this explained my problem better.

 

EDIT: If I put DataCardClientValue88 in the InputTextPlaceholder, it shows the right one, it shows the chosen Client, which is good, but not exactly what I want. If people edit that form and save, it saves a blank for Client, since nothing is filled in (because there is no working default). 

Saego
Level: Powered On

Re: Issues with "Default" in Combobox

Hi Michael (@v-micsh-msft),

 

Thank your for your response. 

I'm talking about the Default property, not the InputTextPlaceholder.

 

Here is some more information, since your solution didn't work for me.

In the edit screen, these are the most imporant properties for the datacard and combobox:

 

ComboboxClient:

DisplayFields: ["Name"]

SearchFields: ["Name"]

Items: Sort('[dbo].[tbl_Clients]';Name)

Default: Empty

InputTextPlaceholder: DataCardValue80 (This is the Client Value in the Detail / View screen. This is just a temporarily solution so people know which Client they picked).

 

DatacardClient:

DataField: "Client_ID"

DisplayName: "Client"

Default: Empty

Update: LookUp('[dbo].[tbl_Clients]'; Name = ComboBoxClient.Selected.Name; ID)

AllowedValues: Empty

 

 

---------------------------------

I forgot to tell that DatacardClient had a connection to a DropDown first, but I replaced it with a Combobox because I want the users to be able to search for Client in the list itself.

 

So the problem one more time:

I can upload the chosen Client to the database (I can see it in SQL and in the detail/view screen in Powerapps). When editing a voyage, the combobox doesnt display the picked Client anymore and has to be picked again. That's because the Default is empty ofcourse, but I don't know what to fill in there. 

Community Support Team
Community Support Team

Re: Issues with "Default" in Combobox

The Default property should depend on the form property.

So when the Form is submitting new record, you can just leave it as empty, when form control switches to Edit Mode, change the value of the Default property as below:

So the whole formula should be:

 

If(EditForm1.Mode=New,
"",
Lookup('[dbo].[tbl_Clients]'; ID = Gallery.Selected.ID; Name))

See if doing it in this way would make it work as expected.

 

Regards,

Michael

 

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Saego
Level: Powered On

Re: Issues with "Default" in Combobox

So, it didn't give me any errors with this formula (I replaced Client with Charterers by the way):

 

If(Gallery_Voyage_Edit.Mode = New; "";LookUp('[dbo].[tbl_Charterers]'; ID = Gallery_Voyages_Browse.Selected.ID; Name))

 

When I put that in the Default from the DatacardCharterer, it didn't give me an error like mentioned before, but it doesn't display the right Charterer in the Combobox either. 

 

When I put it in the Default from ComboboxCharterer, it gives me the following error: 

 

The property expects record values but this rule produces incompatible text values.

 

I don't know how to solve that. 

Again, thanks for your help Michael @v-micsh-msft

 

RussellGove
Level 8

Re: Issues with "Default" in Combobox

I think you need to set DefaultSelectedItem instead of Default.

 

 

 

 

Saego
Level: Powered On

Re: Issues with "Default" in Combobox

Hi @RussellGove,

 

I tried to set the DefaultSelectedItems to:

 

If(Gallery_Voyage_Edit.Mode = New; "";LookUp('[dbo].[tbl_Charterers]'; ID = Gallery_Voyages_Browse.Selected.ID; Name))

 

Sadly, that didn't work either. It gives me the following error:

 

The property expects record Table values, but this rule produces incompatible Text values. Or something like that.

MK1
Level: Powered On

Re: Issues with "Default" in Combobox

Hi,

I'm also having same kind of issue.

In my scenario, 

I have a combo box which will be filtered based on values we choose from a Dropdown

DropDown= A, B,C

when a user selects A,C then there will be only 1 value in the combo box,

But when they choose B there will be multiple options on Combobox they need to select.

What my issue is: When a user selects A,C from dropdown a textbox should be populated with Combobox value automatically, but when user selects B they should be able to select options from combobox values.

How can i set the properties.

 texbox needs to be populated conditionally. like when they select A,C from dropdown then the textbox value should be the only value from combobox.

When they select B from the dropdown, they should be able to select 3 values from combobox and populate into the textbox.

textBox= Concat(combobox.SelectedItems,Result&",")

This is the formual i used on textbox.So what ever user selects on combobox will bepopulated into textbox

But textbox should be set to default combobox option when they select A,C from dropdown

Highlighted
krywar
Level: Powered On

Re: Issues with "Default" in Combobox

I am having the same issues with setting the Default values for a Combo Box - did anyone solve this since the last post?

Helpful resources

Announcements
firstImage

PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.

firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 420 members 4,631 guests
Please welcome our newest community members: