Thanks a lot Paulie! I´ve been using the Xpath Expression because of you! It definitely speeds up the flows and the best part is that it also reduces the API calls.

Another winner! Really need to spend more time with xml()... Thanks again!

Man, you just saved my life, thank you very much for this great tutorial

Truly helpful. Thank you!

Yes! This did exactly what I needed! Thank you much, Paulie!

Used this in a logic app and it worked like magic 👍

omg, thank you so much. I've been beating my head against the wall over and over for the past 3 days on this.

Legend. Thank you for this!

impressive!

Thanks a lot! I have been looking for this answer for 1 week and nothing worked except for this option. Please, if you have the same example using an Apply to Each loop, I would like to check it. Thanks again.

Hi Paulie, Brilliant thanks for this and good timing. I do need to do a mass delete of records in the Teams Table. Unfortunately our IT have locked access to the HTTP action. So I was going to leverage an earlier solution of your which uses Threads. I was going to run the Threads concurrently and the first thread would process rows 1 - 5000, the second thread 5001 - 1000 as so one. Within each thread there would be the 'apply to each' to 'delete row', which again would run concurrently maxing out a 50. My issue is that I do not know how to select rows 1 - 5000, 5001 - 1000 etc of a Teams Table. With a SharePoint list I can use the ID column. In the Teams Table I have created an AutoNumber column but this is saved as a text. I'm guessing a solution might involve 'Fetch XML Query' in the 'List Rows' action? Appreciate any suggestion?

Amazing

I am trying to create a column that counts each individual item from the item column. What do I need to change in the flow? Item Count A 1 A 2 A 3 B 1 B 2 A 4

How can I count from share point by text Ex. Column includes "Done" & " "Not Yet" how can I get in summarise table the count of each

Please teach. I’d like to use this with number. I put the word bellow in the count column { length(xpath(outputs(‘XML’), concat(‘//Array[ID/number() = ‘ , item(), ‘]’))) }. But didn’t work. What should I do?

I'm getting an error. This is my simple array: STOCK ITEM 45 STOCK ITEM 45 STOCK ITEM 45 CUSTOM ITEM 582 CUSTOM ITEM 582 CUSTOM ITEM 582 CUSTOM ITEM 582 Working XPATH: //Array[text()="STOCK ITEM 45"] Expression, using the format in your example: length(xpath(outputs('XML'), concat('//Array[text()="',item(),'"]'))) Error: The execution of template action 'Select' failed: The evaluation of 'query' action 'where' expression '{ "Description": "@item()", "Count": "@length(xpath(outputs('XML'), concat('//Array[text()=\"',item(),'\"]')))" }' failed: 'The template language function 'xpath' parameters are invalid: the 'xpath' parameter must be a supported, well formed XPath expression. Please see aka.ms/logicexpressions#xpath for usage details.'.