PowerApps Nested Gallery Filtering

(1) Share

Report

Posted on by Sri

559

Hi All,

I have a gallery within a gallery (nested gallery) where gallery 1 holds all DD names and gallery 2 will hold the respective details of all the DD(eg. project name, DD name, account name, account manager).

Gallery 1 - Collects all the DD names by Group By using a collection.

Gallery 2 - Collects all the values from 4 different SharePoint list (Dev Master, test master, CSS master, main master) into a common collection called varoveralltype.

The code on the second gallery is:

If(
rdoRAYG_2.Selected.Value = "All",
If(
Is Blank(ComboBox5.Selected.Result) && Is Blank(PMSearchText_2.Text) && Is Blank(DMSearchText_2.Text),
Filter(
varoveralltype,
ThisItem.Result in DD,
ProjectSearchText_2.Text in Proj Name,
TextInput3.Text in Acct name,
Prjmethod in Prjmethod,
TextInput7.Text in Geo Head,
PMSearchText_2.Text in PM,
DMSearchText_2.Text in DM
)
),
Filter(
varoveralltype,
ThisItem.Result in DD,
ProjectSearchText_2.Text in ProjName,
TextInput3.Text in Account name,
TextInput5.Text in Account Manager,
TextInput4.Text in DD,
TextInput7.Text in Geo Head,
Customer in Customer,
Prjmethod in Prjmethod,
PMSearchText_2.Text in PM,
DMSearchText_2.Text in DM,
rdoRAYG_2.Selected.Value in OverAllRAG
)
)

Based on the filter selected the nested gallery should filter the respective data's. By default the overall rag radio buttons will be selected as all and will load all the project details under the respective DD names. I am using Combo box for filtering the DD and senior DD values. When DD combo box is dependent on Senior DD selected value and the combo box show only the respective DD who is under Senior DD. When combo box value is selected the nested gallery must display only that specific DD values. In my case when one condition works the other doesn't work.

I have attached the screenshot of my page.

Any help would be greatly appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sri 559 on at

Like (1)

Report
Copy link

Link copied!

Hi @poweractivate ,
Thank you so much, I tried giving the conditions with || function in this way, IsBlank(geocol.Result) || IsEmpty(geocol.Result) || GeoHead in geocol.Result function and it worked perfectly.

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

Spoiler (Highlight to read)

I have two filter conditions which works like a if else. So first when rag radio is "all" selected by default and all the text input and combo box is blank it must filter all the projects under the respective dd names. And the second filter condition is like other than all if any other value is selected in radio it will filter. If I give the Combo box.selected.result in seniordd in the second part it is not filtering until I give the Combo box.selected.result in senior dd in the first part. If I give in first part, since Radio is default selected at first it doesn't load all the projects and executes only the combobox conditions and returns only blank values in nested gallery.

Was this reply helpful? Yes No
Verified answer

poweractivate 11,078 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Is Blank should be IsBlank . Maybe it is just a typo from how it was copied and pasted. If not, try correcting this and see if it helps:

//pseudocode / untested If( rdoRAYG_2.Selected.Value = "All", If( IsBlank(ComboBox5.Selected.Result) && IsBlank(PMSearchText_2.Text) && IsBlank(DMSearchText_2.Text), Filter( varoveralltype, ThisItem.Result in DD, ProjectSearchText_2.Text in ProjName, TextInput3.Text in Acctname, Prjmethod in Prjmethod, TextInput7.Text in GeoHead, PMSearchText_2.Text in PM, DMSearchText_2.Text in DM ) ), Filter( varoveralltype, ThisItem.Result in DD, ProjectSearchText_2.Text in ProjName, TextInput3.Text in Accountname, TextInput5.Text in AccountManager, TextInput4.Text in DD, TextInput7.Text in GeoHead, Customer in Customer, Prjmethod in Prjmethod, PMSearchText_2.Text in PM, DMSearchText_2.Text in DM, rdoRAYG_2.Selected.Value in OverAllRAG ) )

Note that in your Filter, each argument is being combined with the And function
If this is not intended, use instead
//pseudocode Filter( varoveralltype, ThisItem.Result in DD || ProjectSearchText_2.Text in ProjName .... )
Otherwise, leave it as you have it.

Other than this, could you clarify what you mean by
@Uthhra wrote:
In my case when one condition works the other doesn't work.

Which condition works when the other doesn't? When one condition is working, what is correct about it specifically, which one is the other condition, and what is the unexpected behavior of the other condition exactly?

Was this reply helpful? Yes No
Sri 559 on at

Like (0)

Report
Copy link

Link copied!

When value is selected in the combo box filtering is not happening in the gallery. Altogether it's not working correctly.

Was this reply helpful? Yes No
poweractivate 11,078 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Uthhra
@Uthhra wrote:
In my case when one condition works the other doesn't work.
I have attached the screenshot of my page.
Any help would be greatly appreciated.
Do you mean that
1. It is not working when the Combo Box is having a Default value, and is only working when the Combo Box is having a manual selection?
2. It is working when the Combo Box is having a Default value, but it is not working when the Combo Box is having a manual selection?
3. It is not working correctly just altogether?

Was this reply helpful? Yes No