power automate
1 Topic
Looking to post in MS teams via PowerAutomate and Excel with Dynamic Content
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!Solved1.7KViews0likes2Comments