customized combobox/dropdown datacard not showing updated valued in customized PowerApps

[ssvk]

Hi , 

I have a datacard called "PPP" - list A (single line of text in SP list ) .

I am inserting combobox control (pulling distinct values from PPP column-list B)

When user selects the value and submits the form , it gets updated in PPP column -list A.

When I edit the item in customized form, it shows no values in this datacard.

Update : combobox.selected.Result

Any suggestion/help ?

[ssvk]

okay, so here is an update - 

I inserted both controls - dropdown & combobox.

with dropdown - when I set default property as Parent.Default ( I am seeing updated value on Edit Form ) . But , I want to achieve this with combobox . In Combobox , I can only set default to "ThisItem"

[tchin-nin]

Hi @ssvk,

Few thing to understand about Combobox and DropdownLists :

I'll use the following data to demonstrate :

SharePoint List "SPList1" only default Columns "Title" (Single line of text), "Created by" (Person), "Created" (DateTime)

SharePoint List "SPList2" same default columns as SPList1 + "Title2" (single line of Text)

I want my PowerApps to create new items in SPList2, and the value possible for the "Title2" column are all the values of Title items in SPList1. (I'm doing a sort of manual look up but with single line of text to make thing easy to understand)

- The Items property defines the items available to select in the Combobox/dropdownlist. It also defines the structure of the items that are displayed in the control.

Example on my SPList2 form : Title2DropdownList.Items = SPList1 //  Value=Title (the column to display in the dropdown). So the structure of items in my dropdown is :

Title(Single line of text) | Createdby (Person) | Created (DateTime)

-The Selected property of a Combobox/Dropdownlist has the same structure as the control's Items.

Example, on my form when I select an item in my Title2DropdownList, the Selected property contains the full record selected :

"This is my title" | {complex Person object} | "2018-09-25T12:18:47"

- The Datacard Update property defines what is going to be pushed in DataCard.DataField (column) of the Form.DataSource. It has to have the exact structure the DataSource is expecting.

Example, my Title2 on SPList2 is a single line of text, that's mean I have to push a string, the Title of my selected object

Title2DataCard.Update : Title2DropdownList.Selected.Title (which is equal to "This is my title")

-The Combobox.DefaultSelectedItems / DropdownList.Default expect the same structure as the Combobox/Dropdownlist Items property.

Example : My dropdown list default property must be an entire record of SPList1

Title2DataCard.Default (or Title2DropdownList.Default) : LookUp(SPList1, Title=ThisItem.Title2)

I hope I am clear enough so you understand a better how it works.

In your case, ListA has a PPP column (single line of text) and you want this to be a value pulled from ListB PPP column.

In your ListA form, PPPDataCard, you put a combobox named PPPCombobox.

PPPCombobox.Items : ListB
PPPCombobox.DisplayFields : ["PPP"]
PPPCombobox.SearchFields : ["PPP"]

PPPDataCard.Update : PPPCombobox.Selected.PPP

PPPCombobox.DefaultSelectedItems : LookUp(ListB, ListB[@PPP] = ThisItem[@PPP])

I'm using DataSource[@Property] because your 2 lists have a column named PPP, this notation is used for disambiguation.

Tell me how it goes and if you have any question.

Théo

[ssvk]

hi @tchin-nin,

Thank you for response : 

I tried what you  suggested , but its still not showing the updated values on the edit form for lookup fields.

below details are :

PPPCombobox.Items : ListB  -> SortByColumns(Distinct(ListB,PPP),"Result")
PPPCombobox.DisplayFields : ["PPP"]  -> "Result"
PPPCombobox.SearchFields : ["PPP"]    -> "Result"

PPPDataCard.Update : PPPCombobox.Selected.PPP   ->  PPPComboBox.Selected.Result

PPPCombobox.DefaultSelectedItems : LookUp(ListB, ListB[@PPP] = ThisItem[@PPP])  -> LookUp(ListB,PPP="Result")

[tchin-nin]

Hi @ssvk

By doing a Distinct() function, you modify the ListB structure because you're retrieving a Result column. 

LookUp(ListB,PPP="Result")

 This can't work because your trying to get the item with a PPP value equal to the string "result". And also the lookup in ListB retrieve not the same structure as an item in distinct(listB,PPP). 

You should probably try :

LookUp(Distinct(ListB,PPP),Result=ThisItem.PPP)

Théo