web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Odd Behavior Using Get...
Power Automate
Unanswered

Odd Behavior Using Get Items in a Do Until

(0) ShareShare
ReportReport
Posted on by

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:

koneill2020_7-1710271504544.png

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.

koneill2020_8-1710271504546.png

 

koneill2020_9-1710271504547.png

 

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 497 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 477 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 242

Last 30 days Overall leaderboard