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.
I'm not sure if there are other limitation for Lookup column over 5,000 rows data ?
so please help me , thank you