SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2676938%22%20slang%3D%22en-US%22%3ELooking%20to%20post%20in%20MS%20teams%20via%20PowerAutomate%20and%20Excel%20with%20Dynamic%20Content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2676938%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20-%20I%20am%20attempting%20to%20set%20up%20an%20Excel%20file%20which%20is%20stored%20on%20SharePoint%20to%20generate%2Fpost%20a%20message%20on%20an%20MS%20Team's%20channel.%20I%20have%20setup%20a%20list%20with%20a%20column%20POSTING%20DATE%2C%20and%20then%20I%20have%20Power%20Automate%20validating%20that%20the%20POSTING%20DATE%20%3D%20TODAY%2C%20if%20yes%20I%20want%20it%20to%20post%20a%20message%20if%20not%20I%20want%20it%20to%20stop.%20Below%20are%20some%20insights%20I%20have%2C%20my%20current%20hurdle%20is%20with%20UTC%20conversion%20to%20the%20current%20date%20format.%3C%2FP%3E%3CP%3EI%20am%20using%20the%20below%20command%20to%20format%20the%20Date%2Ftime%20of%20UTC%20to%20%22yyyy%2Fmm%2Fdd%22%20and%20then%20the%20header%20raw%20data%20returns%20as%20following%2C%20which%20looks%20like%20it's%20not%20converting%20AUG%20to%208%20instead%20it's%20picking%20up%20the%2045%20from%20the%20timestamp.%26nbsp%3B%20%26nbsp%3B%3CEM%3EExpression%20in%20the%20Key%20Value%20field%3A%26nbsp%3B%26nbsp%3B%3CSPAN%3EformatDateTime(utcNow()%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E'YYYY%2Fmm%2Fdd'%3C%2FSPAN%3E%3CSPAN%3E)%3C%2FSPAN%3E%3C%2FEM%3E%3C%2FP%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3Esnapshot%20of%20raw%20data%3A%3C%2FDIV%3E%3CDIV%3E%3CDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Date%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Mon%2C%26nbsp%3B23%26nbsp%3BAug%26nbsp%3B2021%26nbsp%3B20%3A45%3A30%26nbsp%3BGMT%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Content-Length%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22445%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Content-Type%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22application%2Fjson%22%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22Expires%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22-1%22%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%7D%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22body%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%7B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22status%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E404%3C%2FSPAN%3E%3CSPAN%3E%2C%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22message%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22No%26nbsp%3Brow%26nbsp%3Bwas%26nbsp%3Bfound%26nbsp%3Bwith%26nbsp%3BId%26nbsp%3B'2021%2F45%2F23'%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22error%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%7B%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%3E%3CSPAN%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22message%22%3C%2FSPAN%3E%3CSPAN%3E%3A%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E%22No%26nbsp%3Brow%26nbsp%3Bwas%26nbsp%3Bfound%26nbsp%3Bwith%26nbsp%3BId%26nbsp%3B'2021%2F45%2F23'.%22%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%3EAny%20guidance%2Frecommendations%20to%20troubleshoot%20would%20be%20awesome!%20I%20appreciate%20it!%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2676938%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPower%20Automate%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETeams%20365%20family%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2680595%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20to%20post%20in%20MS%20teams%20via%20PowerAutomate%20and%20Excel%20with%20Dynamic%20Content%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2680595%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1135601%22%20target%3D%22_blank%22%3E%40MegK21%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Power%20Automate%20%3CSTRONG%3Emm%3C%2FSTRONG%3E%20is%20minutes%2C%20and%20month%20is%20%3CSTRONG%3EMM%3C%2FSTRONG%3E.%20Thus%20it%20takes%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EMon%2C%26nbsp%3B%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E23%3C%2FSTRONG%3E%3C%2FFONT%3E%26nbsp%3BAug%26nbsp%3B%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E2021%3C%2FSTRONG%3E%3C%2FFONT%3E%26nbsp%3B20%3A%3CFONT%20color%3D%22%23FF0000%22%3E%3CSTRONG%3E45%3C%2FSTRONG%3E%3C%2FFONT%3E%3A30%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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!
2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@MegK21 

In Power Automate mm is minutes, and month is MM. Thus it takes

Mon, 23 Aug 2021 20:45:30

Sergei - thank you, I feel silly but 100% appreciate the help!