This will be a quick post, but thought someone out there might find it useful if they are working in Microsoft Flow and need to get a local date and time and/or format a date and time.
So after a few minutes of digging I figured out the expression:
formatDateTime(convertFromUtc(utcNow(),'Eastern Standard Time'), 'd')
Be sure to replace ‘Eastern Standard Time’ with the correct time zone name. You can get a list from this Microsoft support site. Be sure to use the value in the Name of Time Zone column. Also, if you are using a time zone with periods “.” in it you may or may not need to remove them, you’ll have to experiment. You can also get a list of time zone names on your computer (so they should work on Flow, but not guaranteed) with this line of code in LINQPad:
You can find the options for the time zone format here in the .NET documentation.