I have a flow where all items with a "calibration due date" within my dynamic 30 day range have their "status" updated to "calibrate now". After item update block, I want it to send an automated email every Monday (until the due date no longer falls in my dynamic date range) containing dynamic content from my sharepoint list like the device in need of calibration's "serial number" and "calibration due date" in the email body.
When I try to add the dynamic content it recommends to me, it comes out blank in my test emails. How do I make it so that this content shows up, but only for items with my original filter (cal date within the 30 window)?
I attached images below of what i have.
Filter query is:
CalDate ge '@{formatDateTime(utcNow(), 'yyyy-MM-dd')}' and CalDate lt '@{formatDateTime(addDays(utcNow(), 31), 'yyyy-MM-dd')}'
Hi @jc2000 !
Could you please provide me with screenshots of your flow run ?
Can you extend the "Send a mail" action in the run to see what is passed ?
Thanks.
T
WarrenBelz
146,605
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,946
Most Valuable Professional