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')
snapshot of raw data:
"Date": "Mon, 23 Aug 2021 20:45:30 GMT",
"Content-Length": "445",
"Content-Type": "application/json",
"Expires": "-1"
},
"body": {
"status": 404,
"message": "No row was found with Id '2021/45/23'
"error": {
"message": "No row was found with Id '2021/45/23'."
Any guidance/recommendations to troubleshoot would be awesome! I appreciate it!
