The latest available version (as of this writing) is 2.23.
The version installed will be displayed as shown below. To check the software version that you have, go to the Console and click on Help, then About. Today, we are going to highlight some of these new features.
In addition, Power Automate is now built-in with Windows 11 which is generally available. The latest Aug 2022 update of Microsoft Power Automate for desktop has been released! Yes, in case you’ve missed the news, Power Automate Desktop has been rebranded as Power Automate for desktop. This could be truly helpful if you have a SharePoint List with more than 5000 rows as the query will go through the entire list and help you find the specific data that you need.Latest updates on Microsoft Power Automate for desktop – Aug 2022 Visit this site to see more OData Filter query functions. In the Advanced options, you can now add the ‘Equals’ function in the ‘Filter Query’ section so that you can find the specific data in the SharePoint List, with the same reference number from the user input. Then, in the ‘Get Items’ action, make sure you connect to the SharePoint Site and select your List Name. I created an Instant flow and added ‘School reference number’ as a user input. Now you have the field name, let’s start working on the Flow. Once you in the edit column page, you can see the field name in the URL. Go to the SharePoint List settings and select the ‘Reference Number’ Column to do this. Main Phone Number,so I could apply a filter to retrieve only those records with a certain Reference Number.īefore you start working on the Flow, you need to find the field name of the ‘Reference Number’ Column. In this blog, I prepared a list of New Zealand Schools with School Names, Reference Numbers and their
On top of that this action is limited at 5000 items, which means you can only return the first 5000 rows from your SharePoint List.īy using the ODATA filters, it allows you to pull a specific set of items back rather than the entire SharePoint List. This however can take a good amount of time for the Flow to run if you have a large number of items in your SharePoint List. When you use ‘Get items’ action from Power Automate, it will bring back a list of items from your SharePoint List.
Get Items from a SharePoint List using Power Automate with ODATA Filters
0 kommentar(er)
