Nested gallery filtering

(0) Share

Report

Posted on by Sri

559

Hi All,

I have a gallery which filters all the DD in the organization from a SP list and the code for that is

Sort(
Filter(
Distinct(varcomb,DD),
Not(IsBlank(Result))
),Result)

I have a nested gallery into this which filters the respective details of the DD's (e.g. Project name, account name, respective PM and DM under them) from a collection. The items of the nested galley has

If(
rdoRAYG_2.Selected.Value = "All",
(If(
(IsBlank(TextInput3.Text) && IsBlank(DMSearchText_2.Text) && IsBlank(ProjectSearchText_2.Text) && IsEmpty(ddcol)
&& IsEmpty(seniorddcol) && IsEmpty(geocol) && IsBlank(PMSearchText_2.Text) && IsBlank(TextInput5.Text)),
Filter(
varoveralltype,
ThisItem.Result in DD,
ProjectSearchText_2.Text in ProjName,
TextInput3.Text in Acctname,
TextInput5.Text in AccManager,
Prjmethod in Prjmethod,
PMSearchText_2.Text in PM,
DMSearchText_2.Text in DM
),
Filter(
varoveralltype,
ThisItem.Result in DD,
ProjectSearchText_2.Text in ProjName,
TextInput3.Text in Acctname,
TextInput5.Text in AccManager,
IsBlank(geocol.Result) || IsEmpty(geocol.Result) || GeoHead in geocol.Result,
IsBlank(seniorddcol.Result) || IsEmpty(seniorddcol.Result) || Seniordd in seniorddcol.Result,
IsBlank(ddcol.Result) || IsEmpty(ddcol.Result) || DD in ddcol.Result,
Prjmethod in Prjmethod,
PMSearchText_2.Text in PM,
DMSearchText_2.Text in DM
)
)),
Filter(
varoveralltype,
ThisItem.Result in DD,
ProjectSearchText_2.Text in ProjName,
TextInput3.Text in Acctname,
TextInput5.Text in AccManager,
IsBlank(geocol.Result) || IsEmpty(geocol.Result) || GeoHead in geocol.Result,
IsBlank(seniorddcol.Result) || IsEmpty(seniorddcol.Result) || Seniordd in seniorddcol.Result,
IsBlank(ddcol.Result) || IsEmpty(ddcol.Result) || DD in ddcol.Result,
Prjmethod in Prjmethod,
PMSearchText_2.Text in PM,
DMSearchText_2.Text in DM,
rdoRAYG_2.Selected. Value in OverAllRAG
)
)

If I select the value from combo box, I need only that DD details to be displayed in the gallery and other DD names should be hidden from gallery. I have attached a screenshot of how it is getting displayed.

Any help would be greatly appreciated.

Categories:

General Questions

Screenshot (43).png

Screenshot (40).png

All responses (2)

Answers (0)

Sri 559 on at

Like (0)

Report

Re: Nested gallery filtering

Hi @v-jefferni ,
When loading for the first time the gallery will display all the DD present in the SP List.
1) One Combo box is Senior dd and the other combo box is DD. When a value is selected from Senior dd combo box it will display only the respective DD under them in Dd combo box and gallery.
2) The items property in both the combo box has filter function which gets the values from a collection.
3) varcomb is a variable I have used to collect the DD names using group by and the code for that is used in the main gallery:
ClearCollect(
varcomb,
GroupBy(
varoveralltype,
"DD",
"GroupDD"
)
);
varoveralltype - this a common variable that collects data from four different SP list which is used in the nested gallery
ClearCollect(
varoveralltype,
DevMaster,
MainMaster,
TestMaster,
CSSMaster
);
I have to filter the gallery with the respective DD names only whichever is selected in the Combo box and only that particular value should be listed in the gallery and other DD names should be invisible.
v-jefferni on at

Like (0)

Report

Re: Nested gallery filtering

Hi @Uthhra ,

Could you please share more details about your scenario? What's the relationship between the two Combo boxes? What are the Items property of them? What are the variables varcombo and varoveralltype? Could you please explain more of your purpose, from which combo box the value is selected?

Best regards,