Hi @KrishR ,
To get the first 'x' rows from an Excel Table, you can use the 'List rows present in a table' action and, after clicking in 'show advanced options', set the 'Top Count' to the desired number:
Here is the output: returned only 3 records (this Excel table as a total of 7 records):
If in the future you want to access the next 'x' rows, you can work with a loop that combine both the 'Top Count' and the 'Skip Count' inputs: this second one will ignore a certain quantity of rows when returning the records to you. For example, if I set the 'Skip Count' to 2 and keep the 'Top Count' to 3, it will return 3 records, ignoring the first two of the table:
Output:
In this second example, the first element matches to the 3rd element from the first flow run.
Let me know if it works for you or if you need any additional help!
-------------------------------------------------------------------------
If this is the answer for your question, please mark the post as Solved.
If this answer helps you in any way, please give it a like.
http://digitalmill.net/
