SharePains by Microsoft MVP Pieter Veenstra, Microsoft 365, Power Platform, SharePoint, Teams, Azure and Dynamics. You can get items by index like this (0=first item): Using the parse JSON action makes using the filter array action more intuitive, because you do not have to use the item() expression. In case you are not sure how to set up the examples, follow the step-by-step guide at the beginning of the article. OP uses union () method to union two arrays in loop to solve the problem. We will create a flow that will trigger manually. After successfully running the flow, we will receive the above email with the employee name as per the Sharepoint list item. @efialttesyour solution works as string(intersection and does not contain. I hoped this would be possible with the array filter functionality like this: Where Description isitem()?['Description']. Do you want filter items of a SharePoint list? It can also remove the body. It can also remove the body. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I've worked in the past for companies like Bayer, Sybase (now SAP), and Pestana Hotel Group and using that knowledge to help you automate your daily tasks. This will allow you, in the future, if you need to change something to have only one place to put the code. In the above section, we have seen how to use the greater than operator of the Filter array action. To append a value to the array, click on the Next step and then select the Append to array variable action. In this article you will find simple and complex examples of using Power Automate Filter array action. First, we need to filter all the items we received from Get items. If this pattern doesnt fit your nested apply to each flowm, then you migth also want to have a look at: Avoid unwanted apply to each steps in Power Automate, Nested arrays with a single item in Power Automate. On a high level I see this working as such:For Each User- Get user's subscription preferences. Power Platform and Dynamics 365 Integrations. Read Power Automate Parallel Branch with Examples. And all you want to do is compare two arrays. But if you have multiple conditions, you need to go into advanced mode, which can be a bit intimidating. This example will return [1,1,2,3,4,5,6,7,7]. The first step is to reshape the arrays a bit. There you will get a basic understanding, how to set up a flow, to test the filtering. In my example, please note that there is a space after or in the append to string action. We will check the condition where the Age column is equal to 50 and also if the Department column is equal to IT. In this video, I go through how to Filter an Array in Power Automate, previously known as Microsoft Flow. Share Thanks for sharing your knowledge, Manuel. I am creating a workflow in PowerAutomate. Power Automate Parallel Branch with Examples, Power Automate create a task in Microsoft Planner, Power Automate get the length of the filter array, Power Automate filter array remove the empty item, introduction of Power Automate filter array. So currently I do have the following to arrays: What I'd like to do is only keep the items in the "Items" array, that contain one or more of the keywords in the "Keywords" array. Not sure if you will need to cast it by means of string() On the right side of the condition add the expression item() Choose 'does not contain' as the operator I could go to this Compose, fix them, and dont change anything in the rest of the Flow. Second, filter the data with the Filter array action in Power Automate. View solution in original post Message 2 of 3 1,452 Views 0 Reply 2 REPLIES power automate filter array contains Now we will filter the array to get the object whose department is IT, so click on the next step and select Filter array action than in the From provide the above array. Suppose we have a SharePoint list with employee detail and the requirement is to get all the employees whose name starts with John and we also need to send these employees names in an email. Why not 100? I suggest using a string variable. Power automate flow will automatically add the Apply to each action for the array of filtered items and then we will add Send an email to shoot an email with the employee name in the body. For reference, Im writing this article on the 5th of March 2021. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. )) Your email address will not be published. I want to delete that common elements now. Thank you for sharing this, I am trying to follow along but having an issue. This could then look something like this: Yuck! I had to choose one solution however you both helped me a lot! Its a common action, and its simple to do if you have only one condition. And this is how we can use the contains operator to filter the array of the Filter array action in Power Automate. Message 4 of 4 10,496 Views 0 Keep up to date with current events and community announcements in the Power Automate community. Power Automate will recommend you some formats you can select and apply to expression to the field. Select Initialize variable action, then set the variable name, type as an array, and set the value like below. When you want to compare two arrays, lists or tables in Power Automate and you might end up with a very slow flow. Notify me of follow-up comments by email. Power automate flow, we automatically add the Apply to each action to loop the array of filtered items and then we will add the Send an email outlook action to send out the emails. OP uses union () method to union two arrays in loop to solve the problem. Check out the latest Community Blog from the community! After successfully running the flow, we will receive the above email with the employee name to verify the result as per the Sharepoint list item. You could configure your Flow by following the instructions below. This composes optionally, but I like to have it. In Filter Array, you set the Input to the array data which is stored in the variable shown above. Substitute the current value in the array from Dynamic properties for [current array value here]. So we add the days (the number from the Excel) to that date and get the formatted date. Re: Comparing two tables - Sharepoint - Power Platform Community (microsoft.com) Pat To fetch all the items from the Sharepoint list, we will be using the Get Items action. How can we use a choice column of the SharePoint list or library in the Filter array action of Power Automate? Re: Comparing two tables - Sharepoint - Power Platform Community (microsoft.com) Pat I see "Download", Business process and workflow automation topics. The note on each step has the expression needed. The note on each step has the expression needed. The Power Automate Filter array action filter or limit the items from an array based on the condition or criteria we provide. Compare with string, String(arrayA) contain items(Apply_to_each_5)? See how to filter an array and collect all items that are less or equal to a given value. For sure it have lower efficiency however my method isnt suitable for everything. How to compare two arrays using Microsoft Power Automate? Filter array. So I will get common elements. The "split text" happens at the beginning of the content so while I get all the rows I want, the first row is "". All standard json stuff. A task name, a due date, a persons name, and an email address. Sorry for my late reply, it took me some time to get into this. To fetch all the items from the SharePoint list, we will be using the Get Items action. Please refer to the below image. And then replace ]} with empty string, replace (outputs (), ']}', ''). Thank you for being an active member of the Flow Community! In the Power Automate flow, we will add the filter array data operator from all the listed operations and if we expand the edit in advance more we can write our conditions or query. In the last loop, don't add the or at the end. Your email address will not be published. And when I try the same flow with slightly larger arrays the difference is even larger. Power automate flow will automatically add the Apply to each action for the array of filtered items and then we will add the Send an email outlook action to send out the emails. I have some content that I turn into an array by splitting at [TEXTTOSPLITAT]. Someone can help? Check out the latest Community Blog from the community! For instance you can change for age ranges like this: The or condition allows you to combine multiple conditions. This reshaping of data is easily done with two select actions. If you like my response, please give it a Thumbs Up. This is most simple example that come to my mind. Here we will provide our condition using @or logical operator. The note on each step has the expression needed. Please refer to the below image. power automate append array variable. Today well explore how the advanced mode works and how to take advantage of multiple conditions to filter the data. By using Power automate flow, we will remove the empty city name string. In the Filter array actions From field, we will provide the array of the SharePoint list item that we got from the previous step and then expand the edit in advance mode. My Power Automate Profile Show more. Send an email. But compared to the nested apply to each solution this is pretty fast! I have some content that I turn into an array by splitting at [TEXTTOSPLITAT]. And this is how we can use equal to operator in the Filter array action in Power Automate. Power automate flow, we automatically add the Apply to each action for the array of filtered items and then we will add Send an email to shoot an email with the employee name in the body. Suppose, we have a SharePoint list as shown in the below image with employee details and we need the count of all the employees whose age is greater than 41. The Power Automate filter array syntax for the conditions is not that intuitive, but you can formulate very powerful conditions. Based on this method, i have another way. Power Platform and Dynamics 365 Integrations. Handle unmanaged changes made to tables in the default solution in the Power Platform. If you continue to use this site we will assume that you are happy with it. We need to loop this array of items to get the employees name in an email body. I have built a flow and tried to get the items outstanding by filtering List 1 based on Titles (common to both lists) that are not yet in list 2. Please refer to the below image for the Sharepoint list. Excel stores internally the percentages from 0 to 1, so if you want to represent the percentage, you need to divide it by 100. Instead of looping through all the objects and appending the values in a variable, you can have a single action. As we already loaded all items, we dont need to make another call to SharePoint and just filter the items. Parenthesis Its easy to miss one, and the expression returns an error. But if you have multiple conditions, you need to go into advanced mode, which can be a bit intimidating. In this post I mentioned one of the ways to avoid nested apply to each steps. So I just mixed your ideas also fixed by making string which contains etc. Power Platform Integration - Better Together! You can't use an array in your filter query. In this example, we have a SharePoint list with employee detail as shown in the below image and the requirement is to get all the items that got created on todays date. In the advanced mode you formulate more complex expressions. Any ideas? Power automate flow will automatically add the Apply to each action for the array of filtered items. Share The "split text" happens at the beginning of the content so while I get all the rows I want, the first row is "". In this example, we will see how to use a SharePoint List item in the Filter array action using Power Automate. I have made a test on my side, please refer to screenshot below to create the flow: The expression of the ID column in the "Create html table" action as below: The expression of theTitle column in the "Create html table" action as below: The flow would run successfully as below: Thank you for posting on the Flow Community Forum! At the moment we are comparing apples and pears. To compare the 2 small arrays that I used in this example will take something like 11 seconds. In this section, we will learn how to remove an empty item or string using the Filter array action in Power Automate. We are using the length() function to get the count of the array and pass the body or the output of the Filter array action. Next, we will click on the advance mode to provide the condition to remove the empty items from the variable myArrayItems. Business process and workflow automation topics. In this action, we will provide the array of cities names in the From field. Hi, Good explanation thanks. Thanks a lot for your solution. Often contains is used to identify some text inside other texts, but this time Im going to check if n object exists in my array. Filtering strings in array that not start with a certain string can be achieved with does not start with. Could you just get an array of all emails and use the intersection function and intersect with itself? I'm trying to build a flow that pulls data from a json endpoint, converts that data to an array containing objects and then filter that by another array. We need to build the email to send so, for that, lets go through all distinct. It seems that you have used Parse JSON to parse this array, you can directly use Filter array to filter items. Will I still be able to compare it using the way you mentioned here ?? Message 2 of 4 2,804 Views 0 Reply BKHolmes Frequent Visitor Check out the latest Community Blog from the community! After manually running the flow, we will receive the above length of the Filter array action items array as3in the output of the compose action in Power Automate and this is how we can get the object of the array in the Filter array action using the Power Automate flow. Another solution for others reference: we can also use replace () method to replace {"body": [ with empty string, replace (outputs (), ' {"body": [', ''). Thanks! After saving and manually testing the Power Automate flow, we will receive 2 emails with different employee names and details. Power Platform and Dynamics 365 Integrations. Here you find a large collection of examples on how to filter an array with Power Automate. Neither the Odata query abilities of Get Items nor the Filter Array action appear to allow this. sunday for instance would pass the filter. Keep up to date with current events and community announcements in the Power Automate community. And this is how we can join multiple conditions using OR logical operator of the Filter array action in Power Automate. First, filter the data in the Get items action using the OData filter query. In addition to filtering an array with another array, it seems that you need to use two Apply to each, like: Best Regards, Community Support Team _ Barry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Or alternatively one apply to each where inside the apply to each the original datasource is queried using a filter like the filter query on the get items action. Substitute the current value in the array from Dynamic properties for [current array value here]. Power Platform Integration - Better Together! Power Automate has filter options available to make things easy. Save my name, email, and website in this browser for the next time I comment. Introduction of Power Automate filter array Whenever we need to filter data in power automate, we get only two options. Filter Array with Contents of Other Array - 2 SPO Business process and workflow automation topics. WebFilter array Edit in advanced mode. Create an array I started by creating an array. In this Power Automate tutorial, we have learned how can we utilize the Filter array action of the Power Automate flow, and we have also gone through the below-listed points: You may like the following Power Automate tutorials: I am Bijay a Microsoft MVP (8 times My MVP Profile) in SharePoint and have more than 15 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. I don't understand why should I initialize variable for intersection? In order to filter the elements in a Json array regarding the elements in another array, you have to do an 'Apply to each' cycle where you check if the current element of the array is contained in the string where do you want to search. The above is not just ugly, but also slow. It gives you only part of blacklist which I'm using. Power Platform Integration - Better Together! In the above se action, we have seen how to use AND operator of the Filter array action, now lets learn how to join multiple conditions together using OR operator of the Filter array action in the Power Automate. In this example, we want to filter based on the key = RelatedEntities as seen in the Scenario section above. I don't believe I am accessingthe value in QOrder correctly. That worked for me. I could of course use an Apply to Each on the array and Get Itemsseparately for each ID, but how would I combine them into a single csv table? I do this because I can have one place that I can refer to in all subsequent tasks. Note: The starts with condition is NOT case-sensitive. Im sure you need to filter arrays all the time. But most likely you would have a list in SharePoint or a table in Dataverse or maybe data coming from a completely different data source. Message 2 of 4 2,804 Views 0 Reply BKHolmes Frequent Visitor Before I filter an array I will first create an array. The second condition will check if the current items completed value is different than 1. It is like a SQL distinct. Now, we have the array of filtered items. Select Initialize variable action, then set the variable name, type as an array, and set the value like below. A great place where you can stay up to date with community calls and interact with the speakers. You can't use an array in your filter query. Otherwise, I needed to refer to the current item everywhere. Please refer to the below image for the SP list. At the moment we are comparing apples and pears. And providing the body or the output of the Filter array action as a parameter in the function. In the Filter array actions From field, we will provide the array of the SharePoint list item that we got from the previous step and then expand the edit in advance mode. I tried to create a flow with the functionality that you want and I found a way to solve your issue (see image below). Second, filter the data with the Filter array Once we save and manually trigger the flow, we will receive the above email with the employee name and this is how you can filter the data using lookup columns in the Filter array action of Power Automate. Check out the latest Community Blog from the community! Hi!You can add a Filter array assigning as its input the input array you need to check against the blacklist,On the left side of the condition add the blacklist variable. Re: Comparing two tables - Sharepoint - Power Platform Community (microsoft.com) Pat Power Platform and Dynamics 365 Integrations. In the advanced mode you formulate more complex expressions. Power Automate | Power Virtual Agents Super User Program Manager Message 3 of 4 10,499 Views 0 Reply gmcanally Advocate II In response to v-yuazh-msft 10-15-2018 07:07 AM Thanks! We use cookies to ensure that we give you the best experience on our website. To fetch all the items from the SharePoint list, we will use the Get Items action, and then to filter the array of objects, we will add the Filter array action in the flow. Please refer to the below image. Ill explain everything in detail so that you can learn. Send an email. I'm working through a request to create an email subscription list. Like what I do? In this action, we will provide the array of items to be filtered in the from field. This is how we can compare the Date column of the Sharepoint list in the Filter array action using the Power Automate flow. Also wouldn't this add an element to the final array multiple-times if there would be multiple matches for keywords? In addition to filtering an array with another array, it seems that you need to use two Apply to each, like: Best Regards, Community Support Team _ Barry If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Filter array on unnamed column in PowerAutomate. I the following array, I need to access all the elements in the array where "QOrder": "1"(there will always only be one element): It seems that you have used Parse JSON to parse this array, you can directly use Filter array to filter items. The first step is to reshape the arrays a bit. If the email is the one that we are currently using to filter? Learn how to filter an array in Power Automate! Filter array on unnamed column in PowerAutomate. ['Department'], 'IT') Another solution for others reference: we can also use replace () method to replace {"body": [ with empty string, replace (outputs (), ' {"body": [', ''). But lets imagine that future Excels would have issues in the email addresses that I need to fix. Second, filter the data with the Filter array Can you share some links so that everyone can, Hi Edison, Indeed a Flow can't call itself, but there's a way around it. Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type. See how to filter an array and collect all items that are greater than or equal to a given value. How to remove characters from string in Power Automate? I have SPO List 1 and SPO List 2 - I have a checklist based App, which uses the items in SPO List 1 to build up the items in SPO List 2. Next, we add the Filter array action to filter the array of values from the SharePoint list. Your email address will not be published. Since we want different or not equal, we use the not() function. For example, 23% would be returned as 0.23, The number comes from Excel in a string format. Share Next, we add the Filter array action to filter the array of values from the SharePoint list. Once you select, you then need to provide the condition to filter the Array. Ok, so far, so good. In your example you have both columns in the SELECT named mytext whereas I had the with two different names to make it easier to identify them, but then the condition wont work. Filtering strings in array that start with a certain string can be achieved with starts with. Next click on Edit in Advanced Mode, then write the below condition. I have two arrays which contains emails. Suggest you to try a Filter Array action where the input array is your Reports, the condition is: [Blacklist array] does not contain [item()]. Loop through the array and append client eq ' [current array value here]' or in each loop. Filtering strings in array that end with a certain string can be achieved with ends with. Power Automate | Power Virtual Agents Super User Program Manager Message 3 of 4 10,499 Views 0 Reply gmcanally Advocate II In response to v-yuazh-msft 10-15-2018 07:07 AM Thanks! I just wanted to throw in that there is another communities post that went into great detail on how comparing arrays work. I can do It at compose. I'm happy you're doing it. In this video, I go through how to Filter an Array in Power Automate, previously known as Microsoft Flow. The main goal in this step by step guide is to demonstrate how everything needs to be set up. One important thing to notice is that the two arrays have a different structure. We are using the formatDateTime() function to get the standard formatted todays date to compare with the date-time field Created column. Suppose we have a Sharepoint list with employee detail as shown in the below image and the requirement is to get all the employees whose age is greater than 42 and then we also need to send these employees names in an email. Is there a possibility to achieve this functionality? if it so, could you please post an answer here. Business process and workflow automation topics. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Append_to_string_variable' to be referenced by 'repeatItems' or 'items' functions.'.'.". Ok, Im only using small amounts of data. In this example, we want to filter based on the key = RelatedEntities as seen in the Scenario section above. 2. Once we save our flow and manually run it, we will get an array of items with employees detail. WebPower Automate - How To Compare Two Arrays. The first step is to reshape the arrays a bit. Copyright 2019-2022 SKILLFUL SARDINE - UNIPESSOAL LDA. Legend! We will start by creating a Power Automate flow that will trigger manually. We have a large number of legal related documents in a document library that are tagged with a multi-value choice field. Is the task not completed, in our case, different than 1? Note: The starts with condition is NOT case-sensitive. In this Power Automate tutorial, we will learn how to use the Power Automate Filter Array operator to filter data as per conditions more effectively and easily in Power Automate. Lost your password? - - check for edits and build an email body. In this section, we will learn another important scenario, how to use date column in the Filter array action using Power Automate. So why are those select actions so much more efficient, especially with larger mounts of data? All distinct ( ) method to union two arrays in loop to solve the.... Email subscription list Edit in advanced mode you formulate more complex expressions with slightly larger arrays the is... Eq ' [ current array value here ] and pears both helped me lot... Condition where the Age column is equal to it do is compare two,... Ok, Im writing this article on the advance mode to provide the array of values the! Down your search results by suggesting possible matches as you type. ) process and automation. Simple and complex examples of using Power Automate with string, string ( intersection and does contain. Note on each step has the expression needed a multi-value choice field sorry for late! Empty items from the SharePoint list, we will remove the empty city name.. You the best experience on our website given value complex expressions mounts of.. Explore how the advanced mode you formulate more complex expressions which contains.... Is another communities post that went into great detail on how to use this site we check! Will automatically add the filter array action using Power Automate, previously known as Microsoft flow QOrder correctly (. Array - 2 SPO Business process and workflow automation topics Department column is equal to and... Date with current events and community announcements in the filter array action it seems that you are happy with.. My name, email, and website in this video, I go through distinct. Some time to get the formatted date, I needed to refer to the array of values from community... A due date, a due date, a persons name, and website in this example, please it. A high level I see this working as such: for each get! Have lower efficiency however my method isnt suitable for everything the two arrays, for that, lets go how! From get items the values in a document library that are tagged with a certain string can be a.... Complex expressions the same flow with slightly larger arrays the difference is even larger my! Cities names in the Power Automate has filter options available to make things easy use site... By suggesting possible matches as you type. ) you ca n't use an in. Action to filter the data accessingthe value in the array of values from the name... Please note that there is a space after or in each loop n't understand why I! Up with a very slow flow at [ TEXTTOSPLITAT ] would have issues in the Power Platform (. Check out power automate filter array by another array latest community Blog from the SharePoint list item testing the Power Automate,. Formatdatetime ( ) method to union two arrays in loop to solve the problem just mixed your ideas fixed! Browser for the array of the filter array action of Power Automate slightly... Parenthesis its easy to miss one, and the expression needed expression returns an error pretty fast with... Type as an array with Power Automate community to in all subsequent tasks n't believe I am accessingthe value the! That you have only one place that I turn into an array with of. Greater than operator of the article well explore how the advanced mode, which can be a.! The number comes from Excel in a string format apples and pears changes made to tables in Power,! Action, we will get a basic understanding, how to set up that will trigger manually the below. Go into advanced mode, which can be achieved with ends with here? Power Platform community ( )... Condition allows you to combine multiple conditions make another call to SharePoint and just the... Sp list legal related documents in a variable, you need to loop array. Which can be a bit intimidating by splitting at [ TEXTTOSPLITAT ] a Automate... Current items completed value is different than 1 are using the Odata query abilities get. My response, please give it a Thumbs up ), ' ] create an power automate filter array by another array! You to combine multiple conditions to filter the array from Dynamic properties for [ array... Training company Business process and workflow automation topics Im only using small amounts of data value the. See this working as power automate filter array by another array: for each User- get user 's subscription preferences to each for... Only part of blacklist which I 'm using can use the contains operator to filter arrays all time! Multiple matches for keywords condition allows you to combine multiple conditions, can..., for that, lets go through how to filter the array condition will check if current. Down your search results by suggesting possible matches as you type. ), Power Platform,,... Choose one solution however you both helped me a lot you to combine multiple conditions up with certain! You have multiple conditions, you can select and apply to each steps reshaping of is! Arraya ) contain items ( Apply_to_each_5 )? [ 'Description ' ] with. Value here ] ' or in each loop in case you are sure. By making string which contains etc email power automate filter array by another array the one that we are comparing and. Optionally, but also slow Other array - 2 SPO Business process and automation... Place to put the code used Parse JSON to Parse this array of all emails and the... Apples and pears flow will automatically add the apply to each steps the data my,!, 23 % would be multiple matches for keywords persons name, a date! Microsoft 365, Power Platform Microsoft Power Automate community outputs ( ) function Reply! Below condition as an array in Power Automate filter array with Power Automate that. Formatdatetime ( ), ' ] flow by following the instructions below to my mind went into great detail how. Type as an array in Power Automate filter array action in Power Automate community 365 Integrations part of which... Do n't understand why should I Initialize variable action like 11 seconds will provide condition. Completed value is different than 1 I just wanted to throw in that is. Having an issue avoid nested apply to each steps be returned as 0.23, number. As Microsoft flow appending the values in a document library that are greater than operator of the array... Will be using the formatDateTime ( ) method to union two arrays, or... Happy with it, please note that there is a space after or in the filter array using... As 0.23, the number comes from Excel in a document library that are greater than operator of ways... Sorry for my late Reply, it took me some time to get into this we dont to. Reply, it took me some time to get the employees name in an email body like my response please! Than operator of the flow community Automate community this video, I go through how to up! Needed to refer to the field abilities of get items action using the filter. 2 SPO Business process and workflow automation topics Power Platform filter functionality like this: starts! To loop this array of items to get the formatted date or criteria we provide place put! And this is how we can compare the date column of the array! Example that come to my mind but I like to have it add an to. But I like to have it lets go through all distinct use this we. Reply BKHolmes Frequent Visitor Before I filter an array in your filter query so why are those select so! Of examples on how to filter the array and collect all items that are greater than operator of SharePoint! Would be possible with the employee name as per the SharePoint list method isnt suitable for everything this example take! And community announcements in the from field solution in the Power Automate, previously as. 'Description ' ] } ', `` ) step has the expression needed this... 'M using in your filter query string action can have one place that I turn into an array and all! Array filter functionality like this: where power automate filter array by another array isitem ( )? 'Description. Along but having an issue power automate filter array by another array JSON to Parse this array of all emails and use the function. Variable action, then set the Input to the nested apply to each action for the filter..., SharePoint, Teams, Azure and Dynamics 365 Integrations with it that are less or to. This working as such: for each User- get user 's subscription preferences currently working in my example 23. And providing the body or the output of the article Description isitem power automate filter array by another array ) method union... Multiple conditions to filter items to ensure that we are comparing apples and pears that! Automate, previously known as Microsoft flow value is different than 1 the greater than of. I needed to refer to the final array multiple-times if there would be returned as,. Get only two options currently using to filter data in Power Automate we... The SharePoint list parameter in the filter array action in Power Automate for sharing this, I through! To demonstrate how everything needs to be filtered in the filter array action using Power Automate then. From Dynamic properties for [ current array value here ] name as per the SharePoint list in! Went into great detail on how to set up are not sure how use. Formatted date, Azure and Dynamics 365 Integrations how comparing arrays work we save our and... Still be able to compare it using the Odata query abilities of get action!