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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Failed to get data fro...
Power Automate
Unanswered

Failed to get data from Lookup Field over 5,000 rows : (

(0) ShareShare
ReportReport
Posted on by 7

Dear all,

 

Currently, I have a table A ( over 10,000 rows data ) and one of its Lookup column is related to table B.

 

When I'm trying to get all the data in table A and also want to get a data column in Table B through the Lookup column in Table A via Power Automate.

 

However, I found that the data of the Lookup column cannot be achievd after 5,000 rows. But I can get the data of the other two columns and Threshold in Pagination has been setup 100,000.

 

MarkusLi_0-1678159820988.png

MarkusLi_1-1678159860573.png

I'm not sure if there are other limitation for Lookup column over 5,000 rows data ? 

 

so please help me , thank you 

 

 

 

 

 

 

 

 

 

 

 

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
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard