Reply to an email if it is received within a specific time slot

[Sophinfo]

Hello,

I created a flow to perform an automatic response to any email received between 07 PM and 07 AM.

But this flow is in error in the morning and evening.

First I convert the time zone to receive the time as a number : 

int(formatDateTime(utcNow(), 'HH'))

Then i check if this number is more than 19 or less than 7 :

int(body('Convertir_le_fuseau_horaire'))

Error :

InvalidTemplate. Unable to process template language expressions for action 'Convert_time_zone' at row '0' and column '0': "Format parameter '7' of template language function 'converttimezone' does not is not supported. The format must be a valid single format specifier character (such as "d" or "g") or a valid custom format pattern (such as "MMMM dd, yyyy" or "hh:mm:ss.ff") . For more information, see Standard Date and Time Format Strings and Custom .Net Framework Date and Time Format Strings. ".

Thanks!

Hubert

[VictorIvanidze]

Have a look at https://www.ivasoft.com/scheduledoofflow.shtml 

Use it as a base and modify according your needs. 

[Sophinfo]

Hi Victor,

Thank you for your answer, I tried to import the flow but without success. Is there another way, without going through recursive events in a calendar?
I noticed that the error I am encountering only occurs between 00:00 and 12:00, not after.

[VictorIvanidze]

Could you show your flow?

[Sophinfo]

Hi Victor,

here is my flow.

{
   "name":"xxx",
   "id":"/providers/Microsoft.Flow/flows/xxx",
   "type":"Microsoft.Flow/flows",
   "properties":{
      "apiId":"/providers/Microsoft.PowerApps/apis/shared_logicflows",
      "displayName":"Outlook V2",
      "definition":{
         "metadata":{
            "workflowEntityId":null,
            "processAdvisorMetadata":null,
            "flowclientsuspensionreason":"None",
            "flowclientsuspensiontime":null,
            "creator":{
               "id":"a8e22016-172e-46b1-8943-381538415145",
               "type":"User",
               "tenantId":"xxx"
            },
            "provisioningMethod":"FromDefinition",
            "failureAlertSubscription":true,
            "clientLastModifiedTime":"2022-03-28T15:52:35.4357181Z"
         },
         "$schema":"https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
         "contentVersion":"1.0.0.0",
         "parameters":{
            "$connections":{
               "defaultValue":{
                  
               },
               "type":"Object"
            },
            "$authentication":{
               "defaultValue":{
                  
               },
               "type":"SecureObject"
            }
         },
         "triggers":{
            "À_l'arrivée_d'un_nouvel_e-mail_(V3)":{
               "splitOn":"@triggerOutputs()?['body/value']",
               "metadata":{
                  "operationMetadataId":"dad6a2df-5403-4fc0-90f5-dd3108744ba6"
               },
               "type":"OpenApiConnectionNotification",
               "inputs":{
                  "host":{
                     "apiId":"/providers/Microsoft.PowerApps/apis/shared_office365",
                     "connectionName":"shared_office365",
                     "operationId":"OnNewEmailV3"
                  },
                  "parameters":{
                     "folderPath":"Inbox",
                     "includeAttachments":false,
                     "importance":"Any",
                     "fetchOnlyWithAttachment":false
                  },
                  "authentication":"@parameters('$authentication')"
               }
            }
         },
         "actions":{
            "Condition":{
               "actions":{
                  "Envoyer_un_e-mail_(V2)":{
                     "runAfter":{
                        
                     },
                     "metadata":{
                        "operationMetadataId":"af7f690b-bb4d-437b-ad75-e14af8bfecb0"
                     },
                     "type":"OpenApiConnection",
                     "inputs":{
                        "host":{
                           "apiId":"/providers/Microsoft.PowerApps/apis/shared_office365",
                           "connectionName":"shared_office365",
                           "operationId":"SendEmailV2"
                        },
                        "parameters":{
                           "emailMessage/To":"@triggerOutputs()?['body/from']",
                           "emailMessage/Subject":"[ATTENTION] - @{triggerOutputs()?['body/subject']}",
                           "emailMessage/Body":"<p>Les mails envoyés pendant les temps de repos, les congés et les week-ends n’appellent pas de réponse immédiate, hors urgence avérée ou situation d'astreinte</p>"
                        },
                        "authentication":"@parameters('$authentication')"
                     }
                  }
               },
               "runAfter":{
                  "Convertir_le_fuseau_horaire":[
                     "Succeeded"
                  ]
               },
               "expression":{
                  "or":[
                     {
                        "or":[
                           {
                              "equals":[
                                 "@dayOfWeek(triggerOutputs()?['body/receivedDateTime'])",
                                 0
                              ]
                           },
                           {
                              "equals":[
                                 "@dayOfWeek(triggerOutputs()?['body/receivedDateTime'])",
                                 6
                              ]
                           }
                        ]
                     },
                     {
                        "or":[
                           {
                              "greater":[
                                 "@int(body('Convertir_le_fuseau_horaire'))",
                                 19
                              ]
                           },
                           {
                              "less":[
                                 "@int(body('Convertir_le_fuseau_horaire'))",
                                 6
                              ]
                           }
                        ]
                     }
                  ]
               },
               "metadata":{
                  "operationMetadataId":"ed5f06c3-5444-494e-a59e-0134d76d6ac5"
               },
               "type":"If"
            },
            "Supprimer_l'e-mail_(v2)":{
               "runAfter":{
                  "Condition":[
                     "Succeeded"
                  ]
               },
               "metadata":{
                  "operationMetadataId":"466b3f5b-46ba-4c95-ad41-099af50b6762"
               },
               "type":"OpenApiConnection",
               "inputs":{
                  "host":{
                     "apiId":"/providers/Microsoft.PowerApps/apis/shared_office365",
                     "connectionName":"shared_office365",
                     "operationId":"DeleteEmail_V2"
                  },
                  "parameters":{
                     "messageId":"@triggerOutputs()?['body/id']"
                  },
                  "authentication":"@parameters('$authentication')"
               }
            },
            "Convertir_le_fuseau_horaire":{
               "runAfter":{
                  
               },
               "metadata":{
                  "operationMetadataId":"b3066431-6a6f-4c85-bf57-e7210e37ed60"
               },
               "type":"Expression",
               "kind":"ConvertTimeZone",
               "inputs":{
                  "baseTime":"@triggerOutputs()?['body/receivedDateTime']",
                  "formatString":"@{int(formatDateTime(utcNow(), 'HH'))}",
                  "sourceTimeZone":"UTC",
                  "destinationTimeZone":"Romance Standard Time"
               }
            }
         }
      },
      "connectionReferences":{
         "shared_office365":{
            "connectionName":"shared-office365-90031ca6-6ade-44ed-8508-fc2af25efbef",
            "source":"Embedded",
            "id":"/providers/Microsoft.PowerApps/apis/shared_office365",
            "tier":"NotSpecified"
         }
      },
      "flowFailureAlertSubscribed":false
   }
}

Thanks

[VictorIvanidze]

Sorry I don't want to import your flow. Cold you place here a screenshot? 

[VictorIvanidze]

Place HH (no quotes) to formatString field of "Convert time zone" action instead of 

@{int(formatDateTime(utcNow(), 'HH'))}

[Sophinfo]

If i remove the quotes i get this error : invalid expression

[Sophinfo]

[VictorIvanidze · Accepted solution]

[VictorIvanidze]

Hi @Sophinfo.

did it help? 

[Sophinfo]

Hi Victor, I have to check the next 24 hours but yes, it seems to work !

Thanks a lot 🙂

[VictorIvanidze]

Glad to help.

[Sophinfo]

Hi Victor,

No more errors!

Thanks again