Combo box default value from CDS

[Axal]

Hi guys,

How to display default value for a combobox from a CDS table ? This combobox is part of Datacard of a form that its datasource is CDS table.

When I view the table in that form, my dropdown is empty although actually there is a value behind that field. It's a lookup field though. The Datacard if I check, Default property is "ThisItem.myfield" and in the particular combobox in that Datacard, its DefaultSelectedItem is Parent.default. Guess this is not working for a lookup field ?

Please help.

Thanks 

[StalinPonnusamy]

Hi @Axal 

It should work. I just tested for Account having Primary contact which is lookup.

Items: Choices([@Accounts].primarycontactid)

DefaultSelectedItems: Parent.Default

If this not works then we can use Lookup also works

LookUp(Contacts, Contact =BrowseGallery1.Selected.'Primary Contact'.Contact)

Example:

[Axal]

Hi,

No, it is not working for me with Parent.default in DefaultSelectedItem.

An btw, as this is CDS, the field is a look up to table company. So I tried to use Lookup as well, but it gave me error saying incompatible type. 

What should I put in the comparison actually ?

Thanks

[StalinPonnusamy]

• Is the name field Lookup to the company table?
• ThisItem should not work. Use gallery

LookUp(Contacts, Contact = BrowseGallery1.Selected.'Primary Contact'.Contact)

[Axal]

Hi,

Name is the Primary field name in Companies table. Btw I'm not using Gallery, and the record is actually coming from a ModelDrivenIntegration. But even though I using it as the comparison, it is still giving me the incompatible error.

I'm wondering why it keep giving me those error. Although the field "Company" is a lookup to table companies (Data type=lookup), ain't that field is Text as well ? 

I'm also actually put this ModelDrivenIntegrationForm.Item into a Variable (lets say the name is currentRecord), then tried to use it : Lookup(Companies, Name = currentRecord.company). Still this produced same error.

Totally confuse what should I use then ?

Thanks

[StalinPonnusamy]

Based on my SP integration, I believe ModerndrivenIntegration brings as the table and we need to get the one record.

What value are we getting from ModernappIntegration.Item.Company?

Can you try First(ModernappIntegration.Item.Company).

[Axal]

Hi,

Managed to solve the error. It was actually like you said, ModelDrivenFormIntegration.Item.Company is still a record so it needs further down to its field. So it is no error if like this : LookUp(Companies, Name = [@ModelDrivenFormIntegration].Item.Company.Name)

But unfortunately, the combo box still blank, although in my record (data) already has some selected company.

[Axal]

Hello all,

Just a few updates, while the issue is persist, something odd is this issue only happened if I open it from my Model-driven app. So as this is an embedded canvas app inside form, I run (play) my model-driven app and open the table that open that specific canvas app. I even put same field in other section of the original form of that table, so when the canvas app open, outside this canvas app I can see the "company" field is filled in, but inside canvas app is empty. Something like this :

The one in bottom is the same field but in a different section in that table's form. 

Why I said it is weird is, when editing my canvas app, in Power Apps Studio, that drop down is filled in correctly.

Anyone ever facing this problem ?

Much appreciated any advices.

Thanks,

[StalinPonnusamy]

Hi @Axal

That is weird. Did you tried to create another app or disconnect and reconnect the current one to see what happens?

[Axal]

Hi @StalinPonnusamy 

May I know how to disconnect and reconnect ?

Thanks,