trigger is not working - Githubissues

jogeswarmeher1 commented 4 months ago

Describe the Bug with repro steps

trigger is not working when new entry into table

What type of Logic App Is this happening in?

Consumption (Portal)

Are you using new designer or old designer

New Designer

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#",
        "actions": {
            "Execute_stored_procedure_(V2)": {
                "inputs": {
                    "body": {
                        "ID": "@triggerBody()?['ID']"
                    },
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['sql']['connectionId']"
                        }
                    },
                    "method": "post",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('default'))}/procedures/@{encodeURIComponent(encodeURIComponent('[dbo].[UpdateEmailNotifications]'))}"
                },
                "runAfter": {
                    "Send_email": [
                        "Succeeded"
                    ]
                },
                "type": "ApiConnection"
            },
            "Send_email": {
                "inputs": {
                    "body": {
                        "content": {
                            "html": "<p>&lt;p&gt;Hi @{triggerBody()?['FirstName']}, &amp;nbsp;&lt;/p&gt;&lt;br&gt;&lt;p&gt;Congrats on rejoining the K973 family.&lt;/p&gt;&lt;br&gt;&lt;p&gt;Thanks and regards,&lt;span&gt; &lt;/span&gt;K973 Teams&lt;/p&gt;&lt;br&gt;</p>",
                            "subject": "Welcome to K973"
                        },
                        "importance": "High",
                        "recipients": {
                            "to": [
                                {
                                    "address": "@triggerBody()?['EmailTo']"
                                }
                            ]
                        },
                        "senderAddress": "DoNotReply@ce79a31b-0d04-49b7-a79b-f3c8635ebb54.azurecomm.net"
                    },
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['acsemail']['connectionId']"
                        }
                    },
                    "method": "post",
                    "path": "/emails:sendGAVersion",
                    "queries": {
                        "api-version": "2023-03-31"
                    }
                },
                "runAfter": {},
                "type": "ApiConnection"
            }
        },
        "contentVersion": "1.0.0.0",
        "outputs": {},
        "parameters": {
            "$connections": {
                "defaultValue": {},
                "type": "Object"
            }
        },
        "triggers": {
            "When_an_item_is_created_(V2)": {
                "evaluatedRecurrence": {
                    "frequency": "Minute",
                    "interval": 1
                },
                "inputs": {
                    "host": {
                        "connection": {
                            "name": "@parameters('$connections')['sql']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/v2/datasets/@{encodeURIComponent(encodeURIComponent('default'))},@{encodeURIComponent(encodeURIComponent('default'))}/tables/@{encodeURIComponent(encodeURIComponent('[dbo].[EmailNotifications]'))}/onnewitems"
                },
                "recurrence": {
                    "frequency": "Minute",
                    "interval": 1
                },
                "splitOn": "@triggerBody()?['value']",
                "type": "ApiConnection"
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {
                "acsemail": {
                    "connectionId": "/subscriptions/c4a706f0-4a48-4aea-ae23-f4689e42d1ff/resourceGroups/dogApp-prod/providers/Microsoft.Web/connections/acsemail-1",
                    "connectionName": "acsemail-1",
                    "id": "/subscriptions/c4a706f0-4a48-4aea-ae23-f4689e42d1ff/providers/Microsoft.Web/locations/australiaeast/managedApis/acsemail"
                },
                "sql": {
                    "connectionId": "/subscriptions/c4a706f0-4a48-4aea-ae23-f4689e42d1ff/resourceGroups/dogApp-prod/providers/Microsoft.Web/connections/sql-1",
                    "connectionName": "sql-1",
                    "id": "/subscriptions/c4a706f0-4a48-4aea-ae23-f4689e42d1ff/providers/Microsoft.Web/locations/australiaeast/managedApis/sql"
                }
            }
        }
    }
}

Screenshots or Videos

No response

Browser

chrome

Additional context

trigger is not working

jogeswarmeher1 commented 4 months ago

giving below suggestion Easy Auth was not run in this time window. Authentication Configuration and Investigation Detector (EasyAuth)

github-actions[bot] commented 2 months ago

This issue is stale because it has been open for 45 days with no activity.