Power Platform Community Forum Thread Details

Odd Behavior Using Get Items in a Do Until

All,

Using this article as a base:

Get more than 5000 items from SharePoint with Power Automate:

https://www.tachytelic.net/2020/04/get-more-5000-items-sharepoint-power-automate/

I created this Power Automate (main portion below) which works without error. What I am trying to do is take in a csv which has over 5000 items and place it into a SharePoint Online list. In the below I’m looking to pull in two fields from the .csv by using ID as the key field so ID, Title, Job name.

The problem is that the Get Items where I am trying to look at the list items based on a Filter as such:

Returns for example, the column values items as such which in the case of the Title isn’t the value I want/need and I don’t see where it’s getting that value from based on what the .csv has in it:

"ID": 2,

"Title": "Applied filters:\nStatus is CLA",

The Parse JSON looks good and the For each values look good and actually those are the two values of data I’m trying to place into the list. Therefore, don’t know if my order of operations is way off or what.