Combobox default selected item from variable

[BiTry]

Hi,

I want the value of the box to be displayed depending on the value of a variable /the value of another list depends on this value/. The values of the box are a sharepoint list, /has 2 columns "parent", "child"/

Varibale=r_sum ->the value of the combobox would depend on this value

Sharepointlist name=dropdown10

DefaultselectedItem=Filter(dropdown10,parent=r_sum.Text)

Item=Distinct(dropdown10,Szulo)

Thx, 

[CNT]

@BiTry r_sim doesn't seem to be a variable but rather a Label control?

[BiTry]

Uhh.. sorry, Label 

[CNT]

@BiTry OK, U'r formula seems to be fine. What's the issue?

[BiTry]

[CNT]

@BiTry What is the value in r_sim.Text? Do you have any matching records in the  Szulo column of the dropdown10 SP List? Could you confirm this?

[BiTry]

[CNT]

@BiTry Is the Filter in the DefaultSelectedItems returning any records? You could do a CountRows of the same formula in a Label to confirm this.

[vikas1606 · Accepted solution]

Hi @BiTry 

The problem is when you used Distinct it creates a dynamic column Value. 

Now, When you try to filter at DefaultSelectedItems it has a column name Szulo.

So, To resolve this issue you need to rename your column to "Value" at DefaultSelectedItems or try to keep a common name at both places (Items and DefaultSelectedItems). You can use the below statement at DefaultSelectedItems to fix this.

RenameColumns(Filter(dropdown10, Szulo= Label4.Text),"Szulo","Value")

[BiTry]

DefaultSelectedItems returning value 55, 

This shrepoint list detail 

from excel  /sharepoint columns 'text/