Minute function inside Office365Outlook connector Fx

[ndy856]

I've built a button to send out email with custom subject line with time included but the minute is not up to date by the time user send out. 

Ex: it need to send this subject line: 1260/ss/yyyymmdd/hhmm/In.

the hhmm need to be real time at the time of pressed. 

what's the best approach or function to put in OnSelect inside that Outlook365 function?

[RandyHayes · Accepted solution]

@ndy856 

If it is based off of the exact time the button is pressed, then consider taking a snapshot of the time at that point.  This can be done with a variable.

Ex. OnSelect:

    Set(pressTime, Now())

You can then use that in your Subject line when the Email is sent:

ex.   your subject:  "1260/" & Text(pressTime, "ss/yyyymmdd/hhmm") & "/In"

I hope this is helpful for you.