My Power Automate Tips

So, as I go through making new creations with Microsft’s Power Automation (previously Flow), I thought I’d collect my observations and ways of doing things.

  • Setting a variable = null (using an expression) and then testing if it is null (expression) does not work. Type the word null into the value box rather than using an expression and it will work.
  • To work out the difference in time between two date/time values, convert them both to ticks (using the ticks expression) and subtract the later one from the earlier one. Divide the answer by the relevant number below to get the answer you want:
    • Divide by 600000000 to get the difference in minutes

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at

Up ↑