cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Load parent default value into combobox from Data Table

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.

 

snip1.PNG

 

 

 

 

 

 

 

 

 

 

 

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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,

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

3 REPLIES 3
Community Support
Community Support

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,

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

Works like a charm, many thanks

Anonymous
Not applicable

It's working, many thanks

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (21,748)