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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get a row from excel t...
Power Automate
Answered

Get a row from excel to find more than 256 rows

(1) ShareShare
ReportReport
Posted on by 405

Hello,

 

More than a question than a request for any help however, I'm about to use Adobe Sign bulk upload to send 500-1000 contracts.

 

As part of this process, I've built a flow in power automate that upon completion, save the pdf to a sharepoint site. There is however a required naming convention for those files, therefore to do this I used 'get a row' from excel, to match up the email addresses from the bulk adobe send to one in the excel file, then use those details as part of the name of the file, for example 'payroll_firstname_surname.pdf' 

 

I understand that 'get a row' is limited to 256 rows, therefore I have added an action before this 'list rows present in table' and enabled Pagination and changed the threshold to 2000. 

 

Can anyone tell me if this will then extend the threshold of the 'get a row' to search more than 256?

 

If not, is there a known work around?

 

I hope this makes sense!

 

Thanks

Categories:
I have the same question (0)
  • Verified answer
    trice602 Profile Picture
    15,927 Super User 2026 Season 1 on at

    Hi @jap11 ,

     

    It seems like if you are using List rows present in a table with the filter query parameter set to email eq 'dynamiccontent_from_sender' then you will return only one row and then can use that row for your naming convention.  I'm suggesting that you don't need to use 'Get a row' action because with the filtered List rows present in a table action, you achieve the same thing.

     

     

  • Jap11 Profile Picture
    405 on at

    @trice602  - you know, I hadn't even thought of it like that!

     

    So if I set it up like this, it will achieve the same thing? _es_signer_email is the name of the column containing the email addresses.

     

    JoshPullan11_0-1715267918196.png

     

    Thanks!

  • trice602 Profile Picture
    15,927 Super User 2026 Season 1 on at

    Hi @jap11 ,

     

    I think you need to put the dynamic content for Event Participant inside single quotes but looks good for a test run!

     

     

     

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard