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

Notifications

Announcements

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 393

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,886 Super User 2025 Season 2 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
    393 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,886 Super User 2025 Season 2 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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard