Azure
Logic app do not work
Severity
P3 - Medium (Minor functionality affected)
Describe the Bug with repro steps
I am trying to create logic app for alerting system. App get email in and we filter based on subject if we continue or not. If we continue we check from excel who is in duty and we call that supervisor or we send sms depending of time. We have currently working implementation working very nicely using zapier(in production 1 year) I wanted to use microsoft resources (we habe aput 60 subscriptions in 3 tenants) so we decided to use logic app. I have been able to filter subjects, we have twilio integration (sms and phone), excel integration for on-duty schedule with phone numbers, but this logic app does not work, always something. I am using claude to help me, but always some issues in logic app. I am extremely disappointed. It is extremely difficult to create logic app in this case and compared to zapier. Always some errors but no clue what is problem. I suggest you to investigate Zapier, Make and compare with Logic app (in my opinion huge difference and not advantage of Logic app).
What type of Logic App Is this happening in?
Consumption (Portal)
Are you experiencing a regression?
No response
Which operating system are you using?
Windows
Did you refer to the TSG before filing this issue? https://aka.ms/lauxtsg
Yes
Workflow JSON
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"contentVersion": "1.0.0.0",
"triggers": {
"When_a_new_email_arrives_(V2)": {
"type": "ApiConnectionNotification",
"description": "gets alerts from other systems",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['outlook']['connectionId']"
}
},
"fetch": {
"pathTemplate": {
"template": "/v2/Mail/OnNewEmail"
},
"method": "get",
"queries": {
"importance": "Any",
"fetchOnlyWithAttachment": false,
"includeAttachments": false,
"folderPath": "Inbox"
}
},
"subscribe": {
"body": {
"NotificationUrl": "@listCallbackUrl()"
},
"pathTemplate": {
"template": "/MailSubscriptionPoke/$subscriptions"
},
"method": "post",
"queries": {
"importance": "Any",
"fetchOnlyWithAttachment": false,
"folderPath": "Inbox"
}
}
},
"splitOn": "@triggerBody()?['value']"
}
},
"actions": {
"Initialize_supervisorPhone": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "supervisorPhone",
"type": "string",
"value": ""
}
]
},
"runAfter": {}
},
"Initialize_supervisorName": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "supervisorName",
"type": "string",
"value": ""
}
]
},
"runAfter": {
"Initialize_supervisorPhone": ["Succeeded"]
}
},
"Initialize_shouldCall": {
"type": "InitializeVariable",
"inputs": {
"variables": [
{
"name": "shouldCall",
"type": "boolean",
"value": false
}
]
},
"runAfter": {
"Initialize_supervisorName": ["Succeeded"]
}
},
"Condition": {
"type": "If",
"expression": {
"and": [
{
"not": {
"endsWith": [
"@toLower(triggerBody()?['Subject'])",
"is ok"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"recovery"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"resolved"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"summarized notifications"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"warning"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"down ended"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"lisätietoja tikettiin"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"elenia"
]
}
},
{
"not": {
"contains": [
"@toLower(triggerBody()?['Subject'])",
"tiketti"
]
}
}
]
},
"actions": {
"List_rows_present_in_a_table": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['excelonlinebusiness']['connectionId']"
}
},
"method": "get",
"path": "/drives/@{encodeURIComponent('b!XdIv9RKtC0yXCM_kUyezbafPJgwYLwxBmqTuR11PglhsX6WNBV7lS7M8ThPbTDZd')}/files/@{encodeURIComponent(encodeURIComponent('012VYM2TBWA2UVD2AASNHYIBQEG2LPKWS7'))}/tables/@{encodeURIComponent('{F1FA593E-FCBC-4702-A3DD-81826B82D2C0}')}/items",
"queries": {
"source": "sites/aidon.sharepoint.com,f52fd25d-ad12-4c0b-9708-cfe45327b36d,0c26cfa7-2f18-410c-9aa4-ee475d4f8258",
"extractSensitivityLabel": false
}
},
"operationOptions": "DisableAutomaticDecompression",
"metadata": {
"012VYM2TBWA2UVD2AASNHYIBQEG2LPKWS7": "/24-7 team/Vuorolista.xlsx"
}
},
"For_each": {
"type": "Foreach",
"foreach": "@body('List_rows_present_in_a_table')?['value']",
"actions": {
"Find_correct_person_in_duty": {
"type": "If",
"expression": {
"and": [
{
"lessOrEquals": [
"@items('For_each')?['StartDate']",
"@utcNow()"
]
},
{
"greater": [
"@items('For_each')?['EndDate']",
"@utcNow()"
]
}
]
},
"actions": {
"Set_supervisorName": {
"type": "SetVariable",
"inputs": {
"name": "supervisorName",
"value": "@items('For_each')?['User']"
},
"runAfter": {}
},
"Set_supervisorPhone": {
"type": "SetVariable",
"inputs": {
"name": "supervisorPhone",
"value": "@items('For_each')?['Phone']"
},
"runAfter": {
"Set_supervisorName": ["Succeeded"]
}
}
},
"else": {
"actions": {}
}
}
},
"runAfter": {
"List_rows_present_in_a_table": ["Succeeded"]
}
},
"Check_supervisor_found": {
"type": "If",
"expression": {
"and": [
{
"not": {
"equals": [
"@variables('supervisorPhone')",
""
]
}
}
]
},
"actions": {
"Call_CheckWorkingHours": {
"type": "Function",
"inputs": {
"function": {
"id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/sites/alert-duty-func-vfobxxobcpsj2/functions/CheckWorkingHours"
}
},
"runAfter": {}
},
"Parse_Function_Response": {
"type": "ParseJson",
"inputs": {
"content": "@body('Call_CheckWorkingHours')",
"schema": {
"type": "object",
"properties": {
"currentTime": { "type": "string" },
"dayOfWeek": { "type": "string" },
"isWorkingDay": { "type": "boolean" },
"isWorkingHours": { "type": "boolean" },
"shouldAlert": { "type": "boolean" },
"reason": { "type": "string" }
}
}
},
"runAfter": {
"Call_CheckWorkingHours": ["Succeeded"]
}
},
"Set_shouldCall": {
"type": "SetVariable",
"inputs": {
"name": "shouldCall",
"value": "@body('Parse_Function_Response')?['shouldAlert']"
},
"runAfter": {
"Parse_Function_Response": ["Succeeded"]
}
},
"Send_SMS": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['twilio']['connectionId']"
}
},
"method": "post",
"path": "/Messages.json",
"body": {
"from": "+3584573975047",
"to": "@{if(startsWith(variables('supervisorPhone'), '+'), variables('supervisorPhone'), concat('+', variables('supervisorPhone')))}",
"body": "HÄLYTYS: @{triggerBody()?['Subject']}\n\nLähettäjä: @{triggerBody()?['From']}\nAika: @{body('Parse_Function_Response')?['currentTime']}"
}
},
"runAfter": {
"Set_shouldCall": ["Succeeded"]
}
},
"Condition_Should_Call": {
"type": "If",
"expression": {
"and": [
{
"equals": [
"@variables('shouldCall')",
true
]
}
]
},
"actions": {
"Delay_30_seconds": {
"type": "Wait",
"inputs": {
"interval": {
"count": 30,
"unit": "Second"
}
},
"runAfter": {}
},
"Make_Voice_Call": {
"type": "ApiConnection",
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['twilio']['connectionId']"
}
},
"method": "post",
"path": "/Calls.json",
"body": {
"from": "+3584573975047",
"to": "@{if(startsWith(variables('supervisorPhone'), '+'), variables('supervisorPhone'), concat('+', variables('supervisorPhone')))}",
"url": "https://funcstorvfobxxobcpsj2.blob.core.windows.net/twiml/alert.xml"
}
},
"runAfter": {
"Delay_30_seconds": ["Succeeded"]
}
}
},
"else": {
"actions": {}
},
"runAfter": {
"Send_SMS": ["Succeeded"]
}
}
},
"else": {
"actions": {}
},
"runAfter": {
"For_each": ["Succeeded"]
}
}
},
"else": {
"actions": {}
},
"runAfter": {
"Initialize_shouldCall": ["Succeeded"]
}
}
},
"outputs": {},
"parameters": {
"$connections": {
"type": "Object",
"defaultValue": {}
}
}
},
"parameters": {
"$connections": {
"value": {
"outlook": {
"id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/outlook",
"connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/outlook",
"connectionName": "outlook"
},
"excelonlinebusiness": {
"id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/excelonlinebusiness",
"connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/excelonlinebusiness",
"connectionName": "excelonlinebusiness"
},
"twilio": {
"id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/twilio",
"connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/twilio",
"connectionName": "twilio"
}
}
}
}
}
Screenshots or Videos
No response
Environment
using Logic app Designer
Additional context
No response
Hi @pehkope thanks for letting us know about this. We are constantly looking on how to improve the designer experience and bring a solid UI to the customers.
- Why is it not working? Is it a connection? is it the workflow execution results?
- Which are the parts you face issues more frequently with?
- Which are the parts you think are better in Zapier?
- Can you take create a support request ticket? Our customer support team will do the best to help you integrate and build the workflow properly.
Hi Carlos, i missed your email until now. My case is to have alertsystem. Process goes like this (in Zapier)
email received -> we use just subject 2. we compare subject with know false alerts (about 10 filters). If incoming subject does not be in zapier filters we continue, else we stop because we know this is false alert. 3. we need to find who is supervisor today (supervisor is on duty one week and then someone else continues). It uses google sheets and finds this weeks supervisor name and phonenumber 4. we send text message via twilio to supervisor 5. we have script which understands holidays for future --> so if this is holiday or saturday or sunday or time is between 4pm - 8 am --> we continue 6. we call to supervisor
This is very intuitive process and in every time when email is sent you can see what it did and why it stopped. Below is example where filter stopped flow (run haavascript) which handles vacations, weekdays etc. Thanx for contacting... I try to find fixes but it is not so intuitive in this ui br Petri ps you can use my company email @.***
[cid:833a87bc-436b-4303-b60c-29352729c7a3]
Here is Logic app run details
[cid:3e3524b4-243d-45b8-b8d6-0e111952a77c]
Very difficult what happened and why (at least for me)
[cid:e3911f99-06a1-4b29-aaff-41005ec96588]
[cid:a3bcf11c-5c7f-4f72-b39d-016ab5904d8d]
Just error Actionfailed. No info why it fails
[cid:e981c94c-26a2-459c-91fa-b7a49c9ba797]
[cid:893f8331-d87c-4dac-86de-768da684bf91]
[cid:5b51a479-093e-43a6-9338-a79c297f9ddc]
Workflow id: /subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Logic/workflows/AlertSystem Azure portal session id: 73bb984cc06c414fac6d09448a35345b Logic App designer session id: undefined Logic App designer instance id: N/A Timestamp: Thu, 20 Nov 2025 07:54:52 GMT
{ "definition": { "$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#", "contentVersion": "1.0.0.0", "triggers": { "When_a_new_email_arrives_(V2)": { "type": "ApiConnectionNotification", "description": "gets alerts from other systems", "inputs": { "host": { "connection": { "name": @.('$connections')['outlook']['connectionId']" } }, "fetch": { "pathTemplate": { "template": "/v2/Mail/OnNewEmail" }, "method": "get", "queries": { "importance": "Any", "fetchOnlyWithAttachment": false, "includeAttachments": false, "folderPath": "Inbox" } }, "subscribe": { "body": { "NotificationUrl": @.()" }, "pathTemplate": { "template": "/MailSubscriptionPoke/$subscriptions" }, "method": "post", "queries": { "importance": "Any", "fetchOnlyWithAttachment": false, "folderPath": "Inbox" } } }, "splitOn": @.()?['value']" } }, "actions": { "Initialize_supervisorPhone": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "supervisorPhone", "type": "string", "value": "" } ] }, "runAfter": {} }, "Initialize_supervisorName": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "supervisorName", "type": "string", "value": "" } ] }, "runAfter": { "Initialize_supervisorPhone": [ "Succeeded" ] } }, "Initialize_shouldCall": { "type": "InitializeVariable", "inputs": { "variables": [ { "name": "shouldCall", "type": "boolean", "value": false } ] }, "runAfter": { "Initialize_supervisorName": [ "Succeeded" ] } }, "Condition": { "type": "If", "expression": { "and": [ { "not": { "endsWith": [ @.(triggerBody()?['Subject'])", "is ok" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "recovery" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "resolved" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "summarized notifications" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "warning" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "down ended" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "lisätietoja tikettiin" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "elenia" ] } }, { "not": { "contains": [ @.(triggerBody()?['Subject'])", "tiketti" ] } } ] }, "actions": { "List_rows_present_in_a_table": { "type": "ApiConnection", "inputs": { "host": { "connection": { "name": @.('$connections')['excelonlinebusiness']['connectionId']" } }, "method": "get", "path": "/drives/@{encodeURIComponent('b!XdIv9RKtC0yXCM_kUyezbafPJgwYLwxBmqTuR11PglhsX6WNBV7lS7M8ThPbTDZd')}/files/@{encodeURIComponent(encodeURIComponent('012VYM2TBWA2UVD2AASNHYIBQEG2LPKWS7'))}/tables/@{encodeURIComponent('{F1FA593E-FCBC-4702-A3DD-81826B82D2C0}')}/items", "queries": { "source": "sites/aidon.sharepoint.com,f52fd25d-ad12-4c0b-9708-cfe45327b36d,0c26cfa7-2f18-410c-9aa4-ee475d4f8258", "extractSensitivityLabel": false } }, "operationOptions": "DisableAutomaticDecompression", "metadata": { "012VYM2TBWA2UVD2AASNHYIBQEG2LPKWS7": "/24-7 team/Vuorolista.xlsx" } }, "For_each": { "type": "Foreach", "foreach": @.('List_rows_present_in_a_table')?['value']", "actions": { "Find_correct_person_in_duty": { "type": "If", "expression": { "and": [ { "lessOrEquals": [ @.('For_each')?['StartDate']", @.()" ] }, { "greater": [ @.('For_each')?['EndDate']", @.()" ] } ] }, "actions": { "Set_supervisorName": { "type": "SetVariable", "inputs": { "name": "supervisorName", "value": @.('For_each')?['User']" } }, "Set_supervisorPhone": { "type": "SetVariable", "inputs": { "name": "supervisorPhone", "value": @.('For_each')?['Phone']" }, "runAfter": { "Set_supervisorName": [ "Succeeded" ] } } }, "else": { "actions": {} } } }, "runAfter": { "List_rows_present_in_a_table": [ "Succeeded" ] } }, "Check_supervisor_found": { "type": "If", "expression": { "and": [ { "not": { "equals": [ @.('supervisorPhone')", "" ] } } ] }, "actions": { "Call_CheckWorkingHours": { "type": "Function", "inputs": { "function": { "id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/sites/alert-duty-func-vfobxxobcpsj2/functions/CheckWorkingHours" } } }, "Parse_Function_Response": { "type": "ParseJson", "inputs": { "content": @.('Call_CheckWorkingHours')", "schema": { "type": "object", "properties": { "currentTime": { "type": "string" }, "dayOfWeek": { "type": "string" }, "isWorkingDay": { "type": "boolean" }, "isWorkingHours": { "type": "boolean" }, "shouldAlert": { "type": "boolean" }, "reason": { "type": "string" } } } }, "runAfter": { "Call_CheckWorkingHours": [ "Succeeded" ] } }, "Set_shouldCall": { "type": "SetVariable", "inputs": { "name": "shouldCall", "value": @.('Parse_Function_Response')?['shouldAlert']" }, "runAfter": { "Parse_Function_Response": [ "Succeeded" ] } }, "Send_SMS": { "type": "ApiConnection", "inputs": { "host": { "connection": { "name": @.('$connections')['twilio']['connectionId']" } }, "method": "post", "body": { "from": "+3584573975047", "to": "@{if(startsWith(variables('supervisorPhone'), '+'), variables('supervisorPhone'), concat('+', variables('supervisorPhone')))}", "body": "HÄLYTYS: @{triggerBody()?['Subject']}\n\nLähettäjä: @{triggerBody()?['From']}\nAika: @{body('Parse_Function_Response')?['currentTime']}" }, "path": "/Messages.json" }, "runAfter": { "Set_shouldCall": [ "Succeeded" ] } }, "Condition_Should_Call": { "type": "If", "expression": { "and": [ { "equals": [ @.('shouldCall')", true ] } ] }, "actions": { "Delay_30_seconds": { "type": "Wait", "inputs": { "interval": { "count": 30, "unit": "Second" } } }, "Make_Voice_Call": { "runAfter": { "Delay_30_seconds": [ "Succeeded" ] }, "type": "ApiConnection", "inputs": { "host": { "connection": { "name": @.('$connections')['twilio']['connectionId']" } }, "method": "post", "path": "/Calls.json", "body": { "from": "+3584573975047", "to": "@{if(startsWith(variables('supervisorPhone'), '+'), variables('supervisorPhone'), concat('+', variables('supervisorPhone')))}", "url": "https://funcstorvfobxxobcpsj2.blob.core.windows.net/twiml/alert.xml" } } } }, "else": { "actions": {} }, "runAfter": { "Send_SMS": [ "Succeeded" ] } } }, "else": { "actions": {} }, "runAfter": { "For_each": [ "Succeeded" ] } } }, "else": { "actions": {} }, "runAfter": { "Initialize_shouldCall": [ "Succeeded" ] } } }, "outputs": {}, "parameters": { "$connections": { "type": "Object", "defaultValue": {} } } }, "parameters": { "$connections": { "type": "Object", "value": { "outlook": { "id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/outlook", "connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/outlook", "connectionName": "outlook" }, "excelonlinebusiness": { "id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/excelonlinebusiness", "connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/excelonlinebusiness", "connectionName": "excelonlinebusiness" }, "twilio": { "id": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/providers/Microsoft.Web/locations/westeurope/managedApis/twilio", "connectionId": "/subscriptions/65a6dbd2-db4b-45f9-abca-d381d2e25359/resourceGroups/alertsystem-rg/providers/Microsoft.Web/connections/twilio", "connectionName": "twilio" } } } } }
Lähettäjä: Carlos Castro Trejo @.> Lähetetty: keskiviikko 19. marraskuuta 2025 18.56 Vastaanottaja: Azure/LogicAppsUX @.> Kopio: Petri Pehkonen @.>; Mention @.> Aihe: Re: [Azure/LogicAppsUX] Logic app do not work (Issue #8596)
[https://avatars.githubusercontent.com/u/102700317?s=20&v=4]ccastrotrejo left a comment (Azure/LogicAppsUX#8596)https://github.com/Azure/LogicAppsUX/issues/8596#issuecomment-3553744226
Hi @pehkopehttps://github.com/pehkope thanks for letting us know about this. We are constantly looking on how to improve the designer experience and bring a solid UI to the customers.
- Why is it not working? Is it a connection? is it the workflow execution results?
- Which are the parts you face issues more frequently with?
- Which are the parts you think are better in Zapier?
- Can you take create a support request ticket? Our customer support team will do the best to help you integrate and build the workflow properly.
— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/8596#issuecomment-3553744226, or unsubscribehttps://github.com/notifications/unsubscribe-auth/AAOABXYJBAIU3NEMWRI4LPD35SOKXAVCNFSM6AAAAACMRPGKHKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZTKNJTG42DIMRSGY. You are receiving this because you were mentioned.Message ID: @.***>