@HansenvomDeich You need to utilize both the Top Count and Skip Count fields.
Skip Count:
This field determines how many rows should be skipped before starting to retrieve rows. Since you want to start at row 682, you should set the Skip Count to 681. This is because the count starts from 0. So, skipping 681 rows will bring you to the start of the 682nd row.
Top Count:
This field specifies how many rows should be retrieved after skipping. Since you want to retrieve rows from 682 to 692, you need to retrieve 11 rows (692 - 682 + 1 = 11). Therefore, set the Top Count to 11.
In this tutorial I cover:
✅ How to create an Automated Cloud Flow
✅ How to dynamically select a Table in the List Rows Present in a Table Action
✅ How to use the Parse JSON action
✅ How to use the When a file is created (properties only) trigger
✅ How to avoid the Apply to Each Action
✅ How to Create an Item in SharePoint from Excel Data
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!
|
