Showing results for 
Search instead for 
Did you mean: 
New Member

Filter Query and Dynamic Content Work Around?



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. 

Super User
Super User

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?


 Hope it helps!


Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

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.

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,337)