You’re offline. This is a read only version of the page.
2
I don't really understand how this works.
I have a Register table in sharepoint. The table has columns Department (selection) and Global status (text field).
I created two comboboxes, with Items = Choices(Register.Departament) and Items = Distinct(Register;'Global status')
And here questions arise.
1. Among the Department there are lines where this field is empty. Why is there no option without text in the combobox? Can it be added by hand somehow?
2. To filter the gallery, I use the formula
Share
ReportItems = Filter(Filter(Sort(Register; ID; Descending); Departament.Value = First(ComboBox1.SelectedItems.Value).Value);'Global status'=First(ComboBox2.SelectedItems.Result) .result)
I would like to be able to select multiple options, but if I remove First, the development environment complains that I am comparing text with a table (which, as it were, yes). The guides I found use the formula without first and for some reason it works.
3. Filters are good. But how to make the "show all" option? For example, show by default all Departments at once?
OK. Question 2 is not relevant. I figured it out. I don't need to use '=', but 'in'.
All responses (
Answers (
