cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Inconsistent behaviour with Combobox and CDS lookup fields

Comboboxes connected to CDS lookup fields sometimes work and sometimes not, take a look at this pic:

cds_blank.jpg

The "Owner" Combobox works fine when selecting and submitting the form. The "areas" comboboxes does not work. I can select values and the changes are saved to the entity with SubmitForm. However, the comboboxes turns blank after submitting. The exact same "areas" comboboxes works fine in another form! I see no logic as the comboboxes are defined exactly the same across the app:

cds_blank2.jpg

Changing the "DefaultSelectedItems" to "ThisItem.crc09_MainAreaLookup" instead of "Parent.Default" makes it work temporarily, but the next time the app is run it's blank again.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Inconsistent behaviour with Combobox and CDS lookup fields

Hi @JohnP ,

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side. I afraid that the Parent.Default formula would not work within the DefaultSelectedItems property of the LookUp filed ComboBox within a Edit form which connects to CDS Entity.

 

As an alternative solution, please consider set the DefaultSelectedItems property of the LookUp filed ComboBox to following:

ThisItem.'LookUp Field'

On your side, you may type:

ThisItem.'MainAreaLookUp'

Note: The ThisItem.'LookUp Field' formula works well on my side without issue.

 

In addition, please also take a try with the following workaround:

set the DefaultSelectedItems property of the LookUp filed ComboBox in your Edit form to following:

LookUp(ReferencedEntity, 'Unique Identifier Column' = ThisItem.'MainAreaLookUp'.'Unique Identifier Column')

Note: The ReferencedEntity represents the Entity your MainAreaLookUp field reference records from, you need to add the ReferencedEntity as data source into your app firstly. The 'Unique Identifier Column' column represents the 'Unique Identifier' column in your CDS Entity.

 

If you want to get further help in this issue, please submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Inconsistent behaviour with Combobox and CDS lookup fields

Hi @JohnP ,

Based on the issue that you mentioned, I have made a test, and the issue is confirmed on my side. I afraid that the Parent.Default formula would not work within the DefaultSelectedItems property of the LookUp filed ComboBox within a Edit form which connects to CDS Entity.

 

As an alternative solution, please consider set the DefaultSelectedItems property of the LookUp filed ComboBox to following:

ThisItem.'LookUp Field'

On your side, you may type:

ThisItem.'MainAreaLookUp'

Note: The ThisItem.'LookUp Field' formula works well on my side without issue.

 

In addition, please also take a try with the following workaround:

set the DefaultSelectedItems property of the LookUp filed ComboBox in your Edit form to following:

LookUp(ReferencedEntity, 'Unique Identifier Column' = ThisItem.'MainAreaLookUp'.'Unique Identifier Column')

Note: The ReferencedEntity represents the Entity your MainAreaLookUp field reference records from, you need to add the ReferencedEntity as data source into your app firstly. The 'Unique Identifier Column' column represents the 'Unique Identifier' column in your CDS Entity.

 

If you want to get further help in this issue, please submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020 Winner Announced

Check it out!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (10,173)