Hi @Ashok2 ,
Could you please share a bit more about your scenario?
Do you want to create a cascading Dropdown boxes between four Dropdown boxes?
Further, do you want to populate other 3 Dropdown boxes against any Dropdown box selection?
Based on the needs that you mentioned, I afraid that there is no direct way to achieve your needs. If you configure the cascading Dropdown boxes based on any Dropdown box selection directly, I afraid that you would face circular reference issue within your Dropdown boxes.
The user @CRM-Kfar-Sava has faced similar issue with you, please check my response within the following thread:
https://powerusers.microsoft.com/t5/Building-Power-Apps/CRM-lookup-Circular-reference-between-properties-problem/td-p/195180
Add four ComboBox control within your app, then configure these ComboBoxes as below:
For ComboBox1:
Set the OnChange property to following:
Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
Set(SelectedColumn1, ComboBox1.Selected.Value);
Set the Items property to following:
Filter(
'Data Source',
If(
!IsBlank(SelectedColumn2),
Column2 = SelectedColumn2,
true
),
If(
!IsBlank(SelectedColumn3),
Column3 = SelectedColumn3,
true
),
If(
!IsBlank(SelectedColumn4),
Column4 = SelectedColumn4,
true
)
)
For ComboBox2:
Set the OnChange property to following:
Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
Set(SelectedColumn2, ComboBox2.Selected.Value);
Set the Items property to following:
Filter(
'Data Source',
If(
!IsBlank(SelectedColumn1),
Column1 = SelectedColumn1,
true
),
If(
!IsBlank(SelectedColumn3),
Column3 = SelectedColumn3,
true
),
If(
!IsBlank(SelectedColumn4),
Column4 = SelectedColumn4,
true
)
)
For ComboBox3:
Set the OnChange property to following:
Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
Set(SelectedColumn4, If(!IsBlank(ComboBox4.Selected.Value), ComboBox4.Selected.Value, Blank()));
Set(SelectedColumn3, ComboBox3.Selected.Value);
Set the Items property to following:
Filter(
'Data Source',
If(
!IsBlank(SelectedColumn1),
Column1 = SelectedColumn1,
true
),
If(
!IsBlank(SelectedColumn2),
Column2 = SelectedColumn2,
true
),
If(
!IsBlank(SelectedColumn4),
Column4 = SelectedColumn4,
true
)
)
For ComboBox4:
Set the OnChange property to following:
Set(SelectedColumn1, If(!IsBlank(ComboBox1.Selected.Value), ComboBox1.Selected.Value, Blank()));
Set(SelectedColumn2, If(!IsBlank(ComboBox2.Selected.Value), ComboBox2.Selected.Value, Blank()));
Set(SelectedColumn3, If(!IsBlank(ComboBox3.Selected.Value), ComboBox3.Selected.Value, Blank()));
Set(SelectedColumn4, ComboBox4.Selected.Value);
Set the Items property to following:
Filter(
'Data Source',
If(
!IsBlank(SelectedColumn1),
Column1 = SelectedColumn1,
true
),
If(
!IsBlank(SelectedColumn2),
Column2 = SelectedColumn2,
true
),
If(
!IsBlank(SelectedColumn4),
Column4 = SelectedColumn4,
true
)
)
Please take a try with above solution, then check if the issue is solved.
Best regards,