Filter Items that match value(s) from multiselect Field in Sharepoint List

Like (0) Share

Report

Posted on 19 Feb 2024 12:46:25 by ChrisBer

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
 )
 )
 )
);;

Categories:

General Questions

Using Apps Using Formulas

All responses (2)

Answers (1)

Verified answer

ChrisBer 9 on 19 Feb 2024 at 14:41:58

Like (0)

Report
Re: Filter Items that match value(s) from multiselect Field in Sharepoint List

Thank you @v-mengmli-msft . I ended up doing like this

ForAll( Distinct(selectedWerbemittel; Kanal); If( CountRows(Filter(selectedWerbemittel; Kanal = Value)) > 0; Collect( dynamicFormPrep; Filter('Formulare-Kommunikationsportfolio'; Value in Kanal.Value) ) ) );; ClearCollect(dynamicForm; ForAll(Distinct(dynamicFormPrep; ThisRecord); Value));;
v-mengmli-msft on 19 Feb 2024 at 13:06:24

Like (0)

Report
Re: Filter Items that match value(s) from multiselect Field in Sharepoint List

Hi @ChrisBer ,

Here is a method for your reference:

ClearCollect(dynamicForm;ForAll(Distinct(Ungroup(ForAll(selectedWerbemittel As C;Filter('Formulare-Kommunikationsportfolio';C.Kanal in Concat(Kanal,Value));"Value");ID) As B;LookUp('Formulare-Kommunikationsportfolio';ID=B.Value))

Best regards,

Rimmon