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,23Aug202120:45:30GMT", "Content-Length":"445", "Content-Type":"application/json", "Expires":"-1" }, "body":{ "status":404, "message":"NorowwasfoundwithId'2021/45/23' "error":{ "message":"NorowwasfoundwithId'2021/45/23'." Any guidance/recommendations to troubleshoot would be awesome! I appreciate it!Solved1.6KViews0likes2Comments