Hey Flow Fam,
Was hoping someone could help me out with a question. I a relatively new to flow without much expression experience. What I am looking to accomplish is to capture all SharePoint items in a last that have a created date from the day prior. Since its Monday today I want all items created on Sunday.
I will then add all of these to an HTML Table and send them via email daily. I was able to get the HTML Table to work when I was testing it but I cannot get the filter to work properly. Any suggestions/input would be very helpful!
I have tried a few different articles and they all give me invalid formula error.
Example of some I have tried:
addDays(utcnow('yyyy-MM-ddTHH:mm:ssZ'),-1)
The expression "Created gt 2020-11-29T21:27:19.0000000Z" is not valid.
&
addDays(utcNow('yyyy-MM-dd'),-1,'yyyy-MM-dd')
The expression "Created ge 2020-11-29" is not valid. Creating query failed.
