Hi, building my first canvas app and struggle with making correct filter settings to a gallery.
The function of the app is to search for technical literature. There are 4 types of literature and those are available in 5 different languages.
The data are on a sharepoint. I created a gallery with a search function by text. That works so far. But I would like to give the user the possiblilty to pre-limit the items visible in the gallery. For this purpose I created a page with several Togglebuttons.
I started with the following code
Filter(Filter(PowerApps
;Type = "Certificate"&&'T Certificate'.Value=true
Or Type = "Instruction Bulletin"&&'T Instruction Bulletin'.Value=true
Or Type = "Product Bulletin"&&'T Product Bulletin'.Value=true
Or Type = "MCS Table"&&'T MCS Table'.Value=true
Or Language = "German"&&'T German'.Value=true
Or Language = "French"&&'T French'.Value=true)
;SearchInput.Text in Title Or SearchInput.Text in AdditionalSearchString Or SearchInput.Text in Category)
But when I checked the function I noticed that everything is fine as long as I just use the toggles to limit the titems to show. But the language buttons do not work. When I uncheck i.e. German, I still see German documents in the gallery and in addition the settings I did with the items to show are not working any more (i.e I unchecked the toggle Certificates - no certificates in the list. But when I check in addition German documents the certificates appear back in the gallery even the toggle is still unchecked.
What did I mixed up here? And is using the filter function the best way for my task (Because I do have the delegation warning with my code)? I read something about changing a field in sharepoint with toggles ...
Thanks in advance for your support
Andreas
