I am trying to use "retrieve email messages from outlook" in power automate and filter by "body contains", so I want to set a dynamic variable in the body contains which is today's date, how to achieve this ?
I try to use “Run python script"
from datetime import date import sys today = date.today() sys.stdout.write(str(today))
and get variables produced "pythonscriptoutput" = 2022-09-07 however, when I pass the variable in "Body Contains" it just doesn't filter correctly then I create an input variable "Todaydate"and hardcode default value to 2022-09-08, then use "Todaydate" in the "Body Contains" to filter and it works. Please help thanks!