Unanswered

Pagination issue-All rows not mapped from excel to SharePoint list

(0) Share

Report

Posted on by Loveleen1

Hi,

While linking the excel sheet to a list in SharePoint, it allows me to map only 256 rows. However, I have around 700 rows in my excel sheet. I turned on the 'pagination' and added '1000' in threshold. Still it is mapping 256 rows in the list in SharePoint. Help needed. Thank you.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

creativeopinion 10,506 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Loveleen1 You will also need to turn on Pagination for the List rows present in a table action.

However, I noticed that you are running a Get Items action within an Apply to Each loop. I would recommend only running this action once OUTSIDE of the Apply to Each loop and using a Filter Array action instead.

This will improve the efficiency of your flow. I can't tell from your screenshot what is taking place in your flow.

If you are cross-referencing data—it would be more efficient to run the Get Items action outside of the loop then use a Filter Array action to filter out those items returned before continuing on with your flow.

You can refer to this section of my YT Tutorial on how to use a Filter Array action.

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No
Loveleen1 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion , your suggestion for pagination worked. Also, I appreciate how you pinpointed my 'Get item' action causing the efficiency of flow to decrease within 'Apply to each' action.
I built my flow to map all the rows from excel sheet to SharePoint list and since the flow is scheduled to run every day; so, if any changes made to any row, the list would get updated automatically.

However, my scheduled flow runs but constantly running gives me the following error:

Do you know why my flow's performance is slow? And how can I fix the error mentioned above?

Was this reply helpful? Yes No
creativeopinion 10,506 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Loveleen1 As mentioned in my original post you need to pull the Get Items action OUTSIDE of the Apply to Each action. If your SharePoint list has 5000 items (even if it has 100) items, the way your logic is set up in your flow is that it has to pull all those items each time it's looping through an Excel item.

You also have two nested apply to each actions. Which is inefficient. If you need to loop through each Excel row—that's fine. However, you should locate the matching SharePoint item first, and update it. No need to loop through all your SharePoint items to find a matching item to your Excel row.

You can refer to this section of my YT Tutorial on how to use a Filter Array action.

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Loveleen1 42 on at

Like (0)

Report
Copy link

Link copied!

@creativeopinion I still don't understand after watching your video as how to use filter array in my case. I have to map the all the rows in excel to SharePoint list and if any changes made to excel, it should automatically update SharePoint list. Could you help me with the flow?

Was this reply helpful? Yes No