How to filter an array?

[Dhruv100322]

Hi,

I have a compose variable in a form of an array contains the following value:

I am getting items from sharepoint using get items. Once that is done I want to filter that using filter array:

There is a column called Channel in SharePoint which is a single choice column. I want to filter the choice so that it only returns the records where the channel value is in Compose variable. Hence, return the value if Channel/Value is either SMS or eMail.

An example of a two record.

 {
               
                "Channel": {
                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                    "Id": 0,
                    "Value": "eMail"
                },
                "Channel#Id": 0,
                "CellID": "eM1"
            },
 {
                "Channel": {
                    "@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                    "Id": 1,
                    "Value": "Facebook"
                },
                "Channel#Id": 1,
                "CellID": "F11"
            }

From the above example, it should only return the first record as "eMail" is one of the values from the Compose array.

How can I achieve this in power automate to filter get items results?

[DamoBird365 · Accepted solution]

Hi @Dhruv100322 

Here is the output you are looking for?

You can use filter array, where the channel/value is contained within the array.

Cheers
Damien

Please take a look and subscribe to my YouTube Channel for more Power Platform ideas and concepts.