Load parent default value into combobox from Data Table

[Anonymous]

Hi all,

I have come across an issue, that I've already lost hours trying to figure out and was hoping somebody here can help me.

To draw a picture :

I have a combination of a Form and Data Table in my App. 

Form has Item property: DataTable.Selected

In that Form there is a Datacard called "Project" with simple text field value. Default property for this DataCardValue is set to "ComboBox".Selected.Title".  Combobox is bringing list of projects from sharepoint list "Consolidated Projects"

Items property:

"Filter('Consolidated Projects',Confidential.Value="No").Title"

DefaultSelectedItems property:

"{ '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

Value: If(Text(Form.Mode)="1","", Parent.Default)}"

Whenever I pick some project from ComboBox, mentioned DataCardValue gets updated and when I submit the form, that column is updated in sharepoint list.  However, when I want to view and edit this item, combobox is showing that value, but it seems like that value is not selected, because mentioned DataCardValue remains blank. I have to re-select value in combobox in order to get DataCardValue updated. For ilustration I am adding a printscreen.

Same issue happens when I changed DefaultSelectedItems propery of combobox to

"{ '@odata.type' : "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",

Value: If(Text(Form3_4.Mode)="1","", ThisItem.Project)}"

Is there a way how to fix this issue?

I would be gratefull for any advice/guidance.

Thank you all

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about your scenario?

Do you want the ComboBox to be populated with saved Project value when you edit an existing record?

Based on the formula you provided within the DefaultSelectedItems property of ComboBox, I think there is something wrong with it. I have made a test on my side, please take a try with the following workaround:

Set the DefaultSelectedItems property of ComboBox to following formula:

{
    Title: If(Text(Form.Mode) = "1", "", Parent.Default)
}

Set the SelectMultiple property of the ComboBox to false.

Please take a try with above solution, then check if the issue is solved.

Best regards,

[lamacz]

Works like a charm, many thanks

[Anonymous]

It's working, many thanks