Aug 23 2021 02:14 PM
Hello - I am attempting to set up an Excel file which is stored on SharePoint to generate/post a message on an MS Team's channel. I have setup a list with a column POSTING DATE, and then I have Power Automate validating that the POSTING DATE = TODAY, if yes I want it to post a message if not I want it to stop. Below are some insights I have, my current hurdle is with UTC conversion to the current date format.
I am using the below command to format the Date/time of UTC to "yyyy/mm/dd" and then the header raw data returns as following, which looks like it's not converting AUG to 8 instead it's picking up the 45 from the timestamp. Expression in the Key Value field: formatDateTime(utcNow(), 'YYYY/mm/dd')
Aug 24 2021 12:19 PM
SolutionAug 24 2021 12:21 PM
Aug 24 2021 12:19 PM
SolutionIn Power Automate mm is minutes, and month is MM. Thus it takes
Mon, 23 Aug 2021 20:45:30