Hi everyone!
I hope someone can help me.
I have the following scenario: SharePoint list (MedArticles) with next columns:
Title --> text
Drugs --> choise (can select only one value)
Nosology --> choise (multi-select. Can select from 1 up to 23 values)
Indications --> choise (multi-select. Can select from 1 up to 3 values)
Author_publ --> text
PublicationsYear --> text
The goal is to display articles in the gallery using filters and search.
I organized the search by Author_publ and filter by drug.
In this case Items property for galArticles looks like this:
SortByColumns(
Filter(
Filter(
MedArticlesEng,
(Drugs.Value = cmbPreparatFilter.Selected.Value || IsBlank(cmbPreparatFilter.Selected.Value))
),
txtSearch.Text in Title || txtSearch.Text in Author_publ
),
"PublicationsYear"
)
And this works fine.
Currently, the problem is that I cannot create a filter by Nosology and Indications.
I created glrNosology with Items property
Choices([@MedArticlesEng].Nosology)
For chbNosology control object for OnCheck property I set folowing value:
Collect(colNosologyFilter,ThisItem)
and for OnUncheck:
Remove(colNosologyFilter,ThisItem)
When testing the collection, I can see that items are added to the collection when selected and removed from the collection when the item is clicked again.
As example
I don't know what value I need to set for the Default property for chbNosology, how to get the value from this collection colNosologyFilter now and how to combine these filters.
I understand that it is possible to create a filter for Indications according to the same principle.
I would appreciate any advice and help.
