You’re offline. This is a read only version of the page.
361
I need to filter the gallery based on these choice boxes, but I don't know how I can do it.
in my scenario I have a gallery (APS Request) that show this data, the "Site" column needs to be filtered in the choices box, however, the site column in sharepoint is of the CHOICES style.
Another thing I need to filter is the Status column, which is also a choice column (I don't know why, I didn't create the app).
If it answered your question, please mark it as solved.
IF you are using dropdown controls, make sure to set the default property to Blank() and the button OnSelect to
Reset(Dropdown1);; Reset(Dropdown2)
Oh right, hadn't realized this.
now, last thing (promise)
I put this formula to the dropdown because it makes more sense... but I want to leave an option to "reset" the selected items, for example: a button that "erases" the choices "Requested" and "SJC"
There was a typo in my formula and if you are using only two comboboxes for Choice type fields that are single select type then this should work.:
Share
Report
All responses (
Answers (
Filter(
'APS Request', Len(ComboBox1.Selected.Value)=0 ||
Site.Value = ComboBox1.Selected.Value,
Len(ComboBox2.Selected.Value)=0 ||
Status.Value = ComboBox2.Selected.Value
)
The above filter should work if both comboboxes have choices, if either one has a choice and if both are blank, all the records should show. Please post the text of the current items of your gallery.
the filter worked.
however, would it be possible to filter through the two comboboxes?
example: filter by selection value of the 2 simultaneous comboboxes? so it will be grade 10.
I am assuming that the information applies to all of your combobox controls. ie. single selection, allows blank. You do not need the "in" operator for single selection comboboxes. Besides, this operator is not delegable in SharePoint and will always give a warning.
Filter(
'APS Request', Len(ComboBox1.Selected.Site)=0 ||
Site.Value = ComboBox1.Selected.Value,
Len(ComboBox2.Selected.Value)=0 ||
Status.Value = ComboBox2.Selected.Value
Len(ComboBox3.Selected.Value)=0 ||
someotherchoicecolumn.Value=ComboBox3.Selected.Value
)
I tried this, but
I want it to receive more than one filter, which doesn't filter just by the "site" column, understand?
And if possible without that dataset refusal warning...
Combobox's or dropdown? If comboboxes, single or multiselect?
Name of list, 'APS Request'? Allow blanks in choices?
