Skip to main content

Notifications

Power Automate - General Discussion
Answered

Sharepoint with power automate

(0) ShareShare
ReportReport
Posted on by 62

I have created a database in sharepoint and create a power automate to send an email of expired dates.  However, when i receive the email, with the table, the table does not show all the expired dates, there various missing.  Could anyone help.  is there a limit to the amount of entries that can be send via email etc?

 

 

cheers1903_0-1642012690522.png

 

  • cheers1903 Profile Picture
    cheers1903 62 on at
    Re: Sharepoint with power automate

    thank you very much.  works now. 

  • Verified answer
    PowerAppsWizard Profile Picture
    PowerAppsWizard 382 on at
    Re: Sharepoint with power automate

    Hi

    See this post

    https://powerusers.microsoft.com/t5/General-Power-Automate/What-is-the-maximum-limit-for-Get-Items-action-in-MS-flow-for/td-p/136275

     

    Try this press the three dots at the get items action:

    PowerAppsWizard_1-1642420570332.png

     

    And turn On pagination and increase the threshold to max 100000

    PowerAppsWizard_2-1642420637997.png

     

    Maybe now solved 😁

     

     

  • cheers1903 Profile Picture
    cheers1903 62 on at
    Re: Sharepoint with power automate

    it has sent me exactly 100 expiries via email.  

    So i am guessing is that the limit it can send?

  • cheers1903 Profile Picture
    cheers1903 62 on at
    Re: Sharepoint with power automate

    thanks for that.  it now runs but the run is still not sending me all the expiries from the database list. 

     

    Any other thoughts?

  • PowerAppsWizard Profile Picture
    PowerAppsWizard 382 on at
    Re: Sharepoint with power automate

    Hi @cheers1903

     

    The first closing bracket is wrong...

     

    PowerAppsWizard_0-1642416277834.png

    Correct would be:

    (ExpiryDate le 'Outputs') or (ExpiryDate eq null)

  • cheers1903 Profile Picture
    cheers1903 62 on at
    Re: Sharepoint with power automate

    I have done this.  But it will not run now.  

     

    cheers1903_0-1642413446410.png

     

  • PowerAppsWizard Profile Picture
    PowerAppsWizard 382 on at
    Re: Sharepoint with power automate

    Try to add brackets around each filter expression e.g. (Column le 'Something') or (Column eq null)

  • cheers1903 Profile Picture
    cheers1903 62 on at
    Re: Sharepoint with power automate

    cheers1903_0-1642057093817.png

    this is the get item with advanced options 

  • ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Sharepoint with power automate

    @cheers1903 

    Can you expand the actions in your Flow and post a screen shot?  I assume that you are using a filter query and I need to see the query.

     

     

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard