Good morning!
I have a gallery which gets filtered by a few dropdown items: GM, ERP, Module. The code below is currently working as expected:
SortByColumns( Filter(_L1Records, If(!IsBlank(dropGM.SelectedText.Value), GM = dropGM.SelectedText.Value, true) && If(!IsBlank(dropERP.SelectedText.Value), ERP = dropERP.SelectedText.Value, true) && If(!IsBlank(dropModule.SelectedText.Value), L1_Type = dropModule.SelectedText.Value, true) ), "GM", Ascending )
From within the gallery I have two text labels called validate_Diff_vs_Recon and validate_Unrecon_vs_Prov which returns either "Yes" or "No". On the outside of the gallery I have a new dropdown object called dropMismatchType and I'd like to filter the gallery for where either the text labels are "No". I have tried this and it's giving me a circular reference error:
SortByColumns( Filter(_L1Records, If(!IsBlank(dropGM.SelectedText.Value), GM = dropGM.SelectedText.Value, true) && If(!IsBlank(dropERP.SelectedText.Value), ERP = dropERP.SelectedText.Value, true) && If(!IsBlank(dropModule.SelectedText.Value), L1_Type = dropModule.SelectedText.Value, true) && If(dropMatchType.SelectedText.Value = "Mismatch", Filter(g_Summary.AllItems, validate_Diff_vs_Recon.Text = "No" || validate_Unrecon_vs_Prov.Text = "No")) ), "GM", Ascending )
Is there a way for me to filter / search based on a field value within the gallery? Any help would be greatly appreciated!
Solved! Go to Solution.
You can't reference the items in the gallery to filter_L1Records to create the items that go into the gallery. If the labels for data for validate_Diff_vs_Recon and validate_Unrecon_vs_Prov are referencing columns in _L1Records then you should be able to use those columns in the Filter formula.
You can't reference the items in the gallery to filter_L1Records to create the items that go into the gallery. If the labels for data for validate_Diff_vs_Recon and validate_Unrecon_vs_Prov are referencing columns in _L1Records then you should be able to use those columns in the Filter formula.
User | Count |
---|---|
160 | |
91 | |
68 | |
64 | |
63 |
User | Count |
---|---|
210 | |
157 | |
93 | |
81 | |
71 |