I have this flow that :
* take a list of items in a list
* filter another list based on the value gotten in the 1st one
* adds some value from this 2nd list.
I have 12 value in the first list, that I get thanks to a "Get items" flow
After that, i set up a loop on a 2nd list with :
* Get items, and a condition fieldA eq 'value from get items 1'
and then i loop again on those values to make a sum of some other field.
My issue is : my Get items 2 can often get more than 100 values so I went to the setting, activated Pagination, and put a limit at 5000 (the maximum).
However, when I run the flow, for 2 out of 12 values from the 1st list, the Get items 2 get only 100 values, and I don't understand why...
The block is the same, parameter is identical, I have checked several times that my data were filled well.
I'm at loss.
Does any of you have an idea of what is the issue, and how to get it work properly ?
Thanks a lot
Could you try doing the same using the REST API in your browser. So somethign like this:
https://mytenant.sharepoint.com/_api/web/lists/GetByTitle('The name of your list')?$filter=Title eq 'Whatever'
It should return the same number of items.
(Don't know why I had to create a new user... weird).
First of all, thanks for the reply.
I'm not sure to understand this REST API thing : where should I put the example you've provided me ?
It does not seem to work the way I do it 😞
It says my list does not exist.
I've tried with its "display name" as well as the "UID" name (perhaps I made a mistake ?)
To understand better : how will I then include that in my Flow to make it work ?
here is my error message : (I changed the url of course)
<m:error xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"> <m:code>-1, System.ArgumentException</m:code> <m:message xml:lang="en-US"> List '41c0d595-9570-4e19-a88f-4f8054a942a8' does not exist at site with URL 'https://MYSITE.sharepoint.com'. </m:message> </m:error>
In the following url you should use the title of the list/library
https://mytenant.sharepoint.com/_api/web/lists/GetByTitle('The name of your list')/iterms?$filter=Title eq 'Whatever'
The guid you can use by:
https://mytenant.sharepoint.com/_api/web/lists/('GUID')/items?$filter=Title eq 'Whatever'
Also does your list live in the root site collection? you might have to add subsites etc.
The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Automate Community!
We are excited to announce the launch of Power Virtual Agents Community. Check it out now!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications