How to extract date and time from email

(0) Share

Report

Posted on by EFernando

Hello,

very new with flow and automation.

I want to create a google calendar event using the information in notification email body or subject.

this is the kind of email i would get. the invitee will be different every time. and the invitee email. also the date and time.

all i want to do is a way to extract the date and time so i can plug it in to the workflow below. End time will always be 30 minutes after start time. i can do that by add minutes. but figuring out start time seems impossible.

please, any help is greatly appreciated!!!

-Eranga

Categories:

Process mining

I have the same question (0)

All responses (9)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report

@EFernando please share output of html to text action

Was this reply helpful? Yes No
EFernando 18 on at

Like (0)

Report

@jinivthakkar see below for both conversions of subject and body. i did them both in separate steps.
Let me know if there's a different way to see the output

raw input for subject -
{
    "host": {
        "connectionReferenceName": "shared_conversionservice",
        "operationId": "HtmlToText"
    },
    "parameters": {
        "Content": "<p>New Event: John Doe - 01:00pm Mon, May 3, 2021 - Tower Crane (CMM) - 30 min</p>"
    }
}

raw output for subject -
{
    "statusCode": 200,
    "headers": {
        "Pragma": "no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net,ARRAffinitySameSite=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;SameSite=None;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "Date": "Mon, 03 May 2021 15:14:33 GMT",
        "Content-Type": "text/html; charset=utf-8",
        "Expires": "-1",
        "Content-Length": "75"
    },
    "body": "New Event: John Doe - 01:00pm Mon, May 3, 2021 - Tower Crane (CMM) - 30 min"
}

raw input for body -
{
    "host": {
        "connectionReferenceName": "shared_conversionservice",
        "operationId": "HtmlToText"
    },
    "parameters": {
        "Content": "<p><html lang=\"en\" style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif\"><head style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif\">\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta content=\"text/html; charset=utf-8\"><meta name=\"viewport\" content=\"width=device-width\" style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif\"><style>\r\n\r\n</style></head><body bgcolor=\"#ffffff\" style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif; height:100%; width:100%!important; background-color:#ffffff\"><div class=\"main-wrapper\" style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif; padding:20px 0; margin:0 auto; max-width:600px\"><table class=\"body-wrap\" style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif; width:80%; margin:20px auto 0; margin:0 auto; padding-bottom:20px; border-bottom:1px dashed #dadada\"><tbody><tr style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif\"><td style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif; text-align:center\"><p style=\"font-family:"Proxima Nova","proxima-nova",Helvetica,Arial sans-serif\"><img alt=\"Calendly\" src=\"http://assets.calendly.com/assets/emails/logo-email-header_legacy-bf5b520caa9ce340db28579b758ee14277...>"
    }
}

raw output for body -
{
    "statusCode": 200,
    "headers": {
        "Pragma": "no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net,ARRAffinitySameSite=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;SameSite=None;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "true",
        "Date": "Mon, 03 May 2021 15:14:33 GMT",
        "Content-Type": "text/html; charset=utf-8",
        "Expires": "-1",
        "Content-Length": "5135"
    },
    "body": "Calendly\n[http://assets.calendly.com/assets/emails/logo-email-header_legacy-bf5b520caa9ce340db28579b758ee14277...]"
}

Was this reply helpful? Yes No
EFernando 18 on at

Like (0)

Report

@jinivthakkar not sure why my other comment got deleted

Raw input for subject -
{
    "host": {
        "connectionReferenceName": "shared_conversionservice",
        "operationId": "HtmlToText"
    },
    "parameters": {
        "Content": "<p>New Event: John Doe - 01:00pm Mon, May 3, 2021 - Tower Crane (CMM) - 30 min</p>"
    }
}

Raw output for subject -
{
    "statusCode": 200,
    "headers": {
        "Pragma": "no-cache",
        "Transfer-Encoding": "chunked",
        "Vary": "Accept-Encoding",
        "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
        "X-Content-Type-Options": "nosniff",
        "X-Frame-Options": "DENY",
        "Cache-Control": "no-store, no-cache",
        "Set-Cookie": "ARRAffinity=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net,ARRAffinitySameSite=e6542d98ba549c57708befaa0104ee3a0d8267c5ad730919ce48720c5d020975;Path=/;HttpOnly;SameSite=None;Secure;Domain=conversionservice-cus.azconn-cus.p.azurewebsites.net",
        "Timing-Allow-Origin": "*",
        "x-ms-apihub-cached-response": "false",
        "Date": "Mon, 03 May 2021 15:14:33 GMT",
        "Content-Type": "text/html; charset=utf-8",
        "Expires": "-1",
        "Content-Length": "75"
    },
    "body": "New Event: John Doe - 01:00pm Mon, May 3, 2021 - Tower Crane (CMM) - 30 min"
}

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
@EFernando here is how I did this, Compose step 1 has the raw output you shared

Compose 4 - Event start date time
Compose 5 - Event end date time
Compose 6 - Subject
The same has been passed to create event

Expressions used are as below
outputs('Compose')['body'] //Compose 2 split(outputs('Compose_2'),' - ') //Compose 3 formatDateTime(outputs('Compose_3')[1],'yyyy-MM-dd hh:mm tt') //Compose 4 addToTime(outputs('Compose_4'),30,'Minute','yyyy-MM-dd hh:mm tt') //Compose 5 outputs('Compose_3')[0] //Compose 6

Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
EFernando 18 on at

Like (0)

Report

@jinivthakkar thank you very much for taking time to help me.
the only step that i can't figure out is Compose 2

Mine looks like this. and mine is an expression instead of an output.
Please advise. thank you.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report

@EFernando what is the action before Compose, please can you share screenshot with that action ?

Was this reply helpful? Yes No
EFernando 18 on at

Like (0)

Report

@jinivthakkar see below. Compose is Html to text 2

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report

@EFernando Compose 1 should be body from step 1 when an email arrives.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
EFernando 18 on at

Like (0)

Report

@jinivthakkar I get this error for compose 2.

see below for my updated flow. i fixed compose 1 per your direction.

Was this reply helpful? Yes No