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 / 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

Forum hierarchy changes are complete!

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

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 525 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 324 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard