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 / Filter Query and Dynam...
Power Automate
Unanswered

Filter Query and Dynamic Content Work Around?

(0) ShareShare
ReportReport
Posted on by 5

Hello,

 

I am building a scheduled flow to trigger each week and send an e-mail of past due items. However, when I use the "Get Items" trigger, no dynamic content is available. I can confirm the site address and list name have been included in the trigger (note: despite having named the list, I only have a string of characters). I thought I could use a filter array to filter out items that are not set to "Completed Status". It does not seem to do what I intend. Is there another possible solution?

Additional notes: I have attempted to create a new flow, use microsoft edge instead of chrome, and refreshed a number of times. The dymanic content issue persists. 

Categories:
I have the same question (0)
  • fchopo Profile Picture
    8,003 Moderator on at

    Hi @IRademacher 

    There is no "Get Items" trigger... Do you mean using "Get Items" action? In that action you need to specify the SharePoint site and list manually, since the trigger will be a specific date. I guess what you want to do is something like this?

    filter.png

     Hope it helps!

    Ferran

  • IRademacher Profile Picture
    5 on at

    Thank you for your advise and the correction, it would be Get Items action. I have also tried using the Filter Query, but it fails. I presume because the dynamic content is not present.

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
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard