RegEx for "Start Date" is equal to Today-30

[BDbadger]

I'm trying to send an email to issue owners when an Active issue is 30 days old.  I also have a "Due Date" however that is a calculated column, and I wasn't able to get that to work either, so this is the approach I thought might be easier.  Can someone help me with the expression to accomplish this?

The flow will loop through daily and send an email to the issue owner after it has been active for 30 days.

column settingcondition

[efialttes]

Hi!

I would focus on 'Get items' Filter Query input and type the following

YourInternalColumnName gt '@{addDays(utcNow(),-30,'yyyy-MM-dd')}' and YourInternalColumnName lt '@{addDays(utcNow(),-29,'yyyy-MM-dd')}'

Now you just need to replace 'YourInternal ColumnName' accordingly. Assuming you named it as Start Date and did not changed it afterwords, your internal column name is probably  Start_x0020_Date

Hope this helps

[BDbadger]

Thanks!  I really like the approach of using the string in the 'get items', that makes total sense.  I've tried using the string provided, however it still does not seem to work.  Using the inspector tools, it seems like the column name doesn't match what was in your proposed solution, I'm not certain that is the issue.  Anything else I may be overlooking?

Very much appreciate your help.

[efialttes]

Hi!

Two different approaches to doublecheck Internal column name in this great thread:

https://powerusers.microsoft.com/t5/Building-Flows/Sort-in-GET-ITEMS-by-column-with-space/td-p/69396...

If internal name is not the issue, please share a screen capture from your flow design so we can see current 'Get items' inputs.

THanx!

[BDbadger · Accepted solution]

Thanks for the help, it seems to do what I am looking for by replacing the 'gt' with 'ge' in the string provided.

YourInternalColumnName gt '@{addDays(utcNow(),-30,'yyyy-MM-dd')}' and YourInternalColumnName lt '@{addDays(utcNow(),-29,'yyyy-MM-dd')}'

[efialttes]

@BDbadger 

Issue finally solved, right?

May I ask you for a favour?

So, please note you can even select several responses as solution, even from different community members!

Or, you can click on 'Thumbs up' in any answer you found valuable... even in all of them 😉

Any of these two suggestions is the cheapest, easiest way to say thanks to somebody that spent its time simply trying to help, and improve his/her community inernal metrics. And just between you and me, everytime an inspiring answer receive a kudo in this community, an ewok escapes from The Emperor menace 

Thanx in advance for making this community great!