Looking to post in MS teams via PowerAutomate and Excel with Dynamic Content

Question

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

sergeibaklan · Accepted Answer

MegK21&nbsp;
In Power Automate mm is minutes, and month is MM. Thus it takes
Mon,&nbsp;23&nbsp;Aug&nbsp;2021&nbsp;20:45:30

Forum Discussion

Looking to post in MS teams via PowerAutomate and Excel with Dynamic Content

2 Replies

Resources