Tip #1408: When tomorrow comes in Power Automate

Letters from Scrabble game arranged to spell "You said tomorrow yesterday"

Ever wondered how to use Dataverse date filters like “Today” or “Tomorrow” when listing records in Power Automate? Yes, plonking in the entire FetchXML with <condition attribute=”enabler_stamp” operator=”tomorrow” /> is one way to handle that. The other is to use query function Tomorrow in the filter: Microsoft.Dynamics.CRM.Tomorrow(PropertyName=’enabler_stamp’) Here’s the catch: “tomorrow” is relative. If you live anywhere west […]

Tip #347: How to use datetime fields in WHERE clause

Gotta love user Q&A sessions, like the one at Convergence 2015 that I had a privilege to take part in. Questions from users are always refreshing, very often challenging and sometimes they are just the reminder that any small bit of information that one possesses is not necessarily the common knowledge. On this occasion question […]