Unanswered

Load parent default value into combobox from Data Table

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

v-xida-msft on at

Like (4)

Report
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,

Was this reply helpful? Yes No
lamacz 15 on at

Like (0)

Report

Works like a charm, many thanks

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It's working, many thanks

Was this reply helpful? Yes No
Elo_1502 2 on at

Like (0)

Report

Hola
Leyendo esta solución, agradeceré vuestro apoyo con lo siguiente. Tengo un campo en un formulario que necesito condicionar para el llenado (Poner reglas de datos) para que los suscriptores solo puedan ingresar un formato predeterminado. El formato es el siguiente 11111111-1 (Este dato puede ser Letra o Numero)
Si pueden ayudarme con solución lo agradeceré mucho

Saludos y un abrazo

Was this reply helpful? Yes No