Hi Powerapps experts,
my task is to create a dynamic form, based in form element data in a SharePoint list (named 'Formulare-Kommunikationsportfolio'). This works like a charm. I collect the elements and map it in a gallery on the respective form items.
Now, I struggle with filtering the items for the dynamic form. I only want to collect items from 'Formulare-Kommunikationsportfolio' in the collection "dynamicForm", where the value of the field entry in column "Kanal" in the collection "selectedWerbemittel" (which is a text field) matches one of the values in the field from column "Kanal" of 'Formulare-Kommunikationsportfolio' (which is a multiselect field). So basically to filter if a string (from selectedWerbemittel) in contained in an array (from 'Formulare-Kommunikationsportfolio').
This is my approach so far but I dont't know how to do the filter logic (syntax with ; and ;; is correct for my language version DE).
Thank you in advance for a little help dear experts!
ClearCollect(
dynamicForm;
Filter(
'Formulare-Kommunikationsportfolio';
!IsEmpty(
Filter(
selectedWerbemittel;
// match fields
)
)
)
);;
