Filter query without dynamic content

[hgartner]

I'm creating a Recurring Trigger flow and then using Get Items to filter the sharepoint columns to bring me only the items I want.

My goal is to get the date items (I will create a future date) and send a due date e-mail, for example: start date 09/11/2023 - end date 09/11/2024. Therefore, when the date 09/11/2024 is the same (UTCNOW), send an email stating that the item has expired.

But I'm stuck in Get Items which doesn't bring me dynamic content. This has been happening since mid-August and so far nothing has changed. Does anyone know if there have been any changes to this method, or is there a problem/something that might be happening in my data source (sharepoint).

This link is an example similar to what I intend to create, but unfortunately the dynamic content does not appear for me.

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Sending-a-Reminder-Email-from-a-Sh... 

[hgartner]

See my screenshot

[wskinnermctc]

There will not be any Dynamic Content available for the Get Items to put within itself. You can only use dynamic content AFTER the Get Items.

To use the filter query, you manually type in what you want to filter.

The example you linked is exactly how the filter query will look.

[hgartner]

Hi, @wskinnermctc 

Thank you very much.

So after manually placing the content I want to filter (the idea was to filter the date column, but using an addToTime expression to subtract a number of months and then add a condition step (if addToTime is equal to UtcNow()), submit email me), I have to add a Compose step and include the dynamic Date content, then add another Compose to use the expression I mentioned above, and then the Condition step (addToTime is equal to utcnow( )) and finally sending an email. I did it here and this way it worked.

With your experience, do you think this flow has become confusing/bureaucratic? Would you have any suggestions?