Tip #1427: Single letter custom formats for dates in Power Automate cloud flows

Today’s tipster is Elaiza “What The Flow” Benitez. (And you can be a tipster too, just send your gem to jar@crmtipoftheday.com!) “Froyo Queen” Azure McFarlane mentioned in a birdie chat that she was having trouble with formatting the month value using the formatDateTime function in Power Automate cloud flows. She was attempting to only retrieve the month value without the […]

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 […]