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 setting
condition
Solved! Go to 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')}'
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
Proud to be a Flownaut!
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.
Hi!
Two different approaches to doublecheck Internal column name in this great thread:
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!
Proud to be a Flownaut!
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')}'
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!
Proud to be a Flownaut!
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
91 | |
57 | |
41 | |
39 | |
38 |
User | Count |
---|---|
82 | |
69 | |
57 | |
55 | |
41 |