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?
Solved! Go to 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.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
14 | |
13 | |
12 | |
10 | |
9 |
User | Count |
---|---|
31 | |
21 | |
17 | |
14 | |
12 |