Azure / LogicAppsUX

https://learn.microsoft.com/azure/logic-apps
MIT License
77 stars 84 forks source link

Outlook SendEmail V2 #6054

Open TroyDeppert opened 1 week ago

TroyDeppert commented 1 week ago

When I select 'Outlook - Send Email (V2)', it prompts me to login to Azure to create a connection. From past experience, I know this will create a problem with all the other Logic Apps that use that connection. Why doesn't have the option to use an existing connection like the Legacy editing did?

ccastrotrejo commented 1 week ago

Hi @TroyDeppert thanks for raising this issue. Is this happening in a Consumption or Standard Logic App? Was this the first connection you created?

We do offer the experience of selecting different connections, or an already created connection. If you click in change connection, you will be able to see the old connections created.

Image Image

TroyDeppert commented 1 week ago

Hello,

They are Consumption Logic Apps. Here is what I see when I select Outlook Send Email (V2):

@.***

There is no way to select other connections. It just keeps prompting for sign in under Create a new connection.

Thanks, Troy

From: Carlos Emiliano Castro Trejo @.> Sent: Monday, November 11, 2024 3:56 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

Hi @TroyDepperthttps://github.com/TroyDeppert thanks for raising this issue. Is this happening in a Consumption or Standard Logic App? Was this the first connection you created?

We do offer the experience of selecting different connections, or an already created connection. If you click in change connection, you will be able to see the old connections created.

image.png (view on web)https://github.com/user-attachments/assets/980c3a99-65fa-4cad-801b-fcdf14b2fc20 image.png (view on web)https://github.com/user-attachments/assets/1d60cb57-3c01-4dfe-9f06-61bae7f876f8

- Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2469005528, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPQ7SQQEJ7URKSQ2ZLD2AEKUJAVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRZGAYDKNJSHA. You are receiving this because you were mentioned.Message ID: @.**@.>>

ccastrotrejo commented 1 week ago

Hi @TroyDeppert is this the first connection that you create? Even if you sign in does it continue prompting to create a new connection? If you create the connection does the designer shows the experience to change the connection?

TroyDeppert commented 1 week ago

No, the connection I want to use has already been created. It is called AzureDI. For some reason, it doesn't recognize that the connection already exists. Since we have been converted to the new editor with no option go back, I can copy a previous Send Email and paste it and make the necessary changes. The problem is, when I create a new logic app, this cut-and-paste method is no longer available to me and it doesn’t show a ‘Change Connection’ anywhere, just the Sign in.

From: Carlos Emiliano Castro Trejo @.> Sent: Monday, November 11, 2024 4:18 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

Hi @TroyDepperthttps://github.com/TroyDeppert is this the first connection that you create? Even if you sign in does it continue prompting to create a new connection? If you create the connection does the designer shows the experience to change the connection?

— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2469035972, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPUPYUC34W54VMNH4VD2AENJ3AVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRZGAZTKOJXGI. You are receiving this because you were mentioned.Message ID: @.**@.>>

ccastrotrejo commented 1 week ago

@TroyDeppert Is there any chance you can share with us your workflow schema? If you want you can share it to my email ccastrotrejo@microsoft.com

TroyDeppert commented 1 week ago

Is that the URL to the Logic App or the Code View? Here is the weird thing. I was just testing it on an old disabled Logic App, and the first time it brought up the correct dialog box with the correct connection. I removed it, then tried it 2 more times and both the subsequent times showed the ‘Sign In’ option.

From: Carlos Emiliano Castro Trejo @.> Sent: Monday, November 11, 2024 4:50 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

@TroyDepperthttps://github.com/TroyDeppert Is there any chance you can share with us your workflow schema? If you want you can share it to my email @.**@.>

— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2469109289, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPQJOOUI3BEGY4LV3Q32AERCHAVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINRZGEYDSMRYHE. You are receiving this because you were mentioned.Message ID: @.**@.>>

ccastrotrejo commented 1 week ago

@TroyDeppert its the code view. Ok thanks for letting us know this specific scenario

TroyDeppert commented 1 week ago

Attached is the code view.

{
    "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": {
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "name": ***@***.***('$connections')['office365']['connectionId']"
                        }
                    },
                    "method": "get",
                    "path": "/Mail/OnNewEmail",
                    "queries": {
                        "importance": "Any",
                        "fetchOnlyWithAttachment": true,
                        "includeAttachments": true,
                        "subjectFilter": "InternationalSalesPBI",
                        "folderPath": "Inbox"
                    }
                },
                "recurrence": {
                    "frequency": "Day",
                    "interval": 1
                },
                "splitOn": ***@***.***()?['value']"
            }
        },
        "actions": {
            "For_each": {
                "type": "Foreach",
                "foreach": ***@***.***()?['Attachments']",
                "actions": {
                    "Create_block_blob": {
                        "type": "ApiConnection",
                        "inputs": {
                            "host": {
                                "connection": {
                                    "name": ***@***.***('$connections')['azureblob_1']['connectionId']"
                                }
                            },
                            "method": "post",
                            "body": ***@***.***(items('For_each')?['ContentBytes'])",
                            "path": "/codeless/CreateBlockBlob",
                            "queries": {
                                "folderPath": "/internationalsales/In/",
                                "name": ***@***.***('For_each')?['Name']"
                            }
                        },
                        "runAfter": {
                            "Set_AttachmentName": [
                                "Succeeded"
                            ]
                        },
                        "runtimeConfiguration": {
                            "contentTransfer": {
                                "transferMode": "Chunked"
                            }
                        }
                    },
                    "Set_AttachmentName": {
                        "type": "SetVariable",
                        "inputs": {
                            "name": "AttachmentName",
                            "value": ***@***.***('For_each')?['Name']"
                        },
                        "runAfter": {
                            "Set_RunDate": [
                                "Succeeded"
                            ]
                        }
                    },
                    "Set_RunDate": {
                        "type": "SetVariable",
                        "inputs": {
                            "name": "RunDate",
                            "value": "@{concat(substring(items('For_each')?['Name'],0,2),'-',substring(items('For_each')?['Name'],2,2),'-',substring(items('For_each')?['Name'],4,4))}"
                        }
                    },
                    "Switch_on_Attachment_Filename": {
                        "type": "Switch",
                        "expression": ***@***.***(items('For_each')?['Name'],9,2)",
                        "default": {
                            "actions": {}
                        },
                        "cases": {
                            "Filename_contains_BT": {
                                "actions": {
                                    "Filename_BT_Switch": {
                                        "type": "Switch",
                                        "description": "Check the name of the file for pe or ra",
                                        "expression": ***@***.***(items('For_each')?['Name'],12,2)",
                                        "default": {
                                            "actions": {}
                                        },
                                        "cases": {
                                            "Spreadsheet_for_Pe": {
                                                "actions": {
                                                    "Check_BT_Penguin_Run_Status_Failed": {
                                                        "type": "If",
                                                        "expression": {
                                                            "and": [
                                                                {
                                                                    "not": {
                                                                        "equals": [
                                                                            ***@***.***('Get_PARun_Status')?['status']",
                                                                            "Succeeded"
                                                                        ]
                                                                    }
                                                                }
                                                            ]
                                                        },
                                                        "actions": {
                                                            "Send_BT_Pe_Run_Failed_email": {
                                                                "type": "ApiConnection",
                                                                "inputs": {
                                                                    "host": {
                                                                        "connection": {
                                                                            "name": ***@***.***('$connections')['office365']['connectionId']"
                                                                        }
                                                                    },
                                                                    "method": "post",
                                                                    "body": {
                                                                        "To": ***@***.***",
                                                                        "Subject": "International Sales BT Penguin Ingest Failed",
                                                                        "Body": "@{body('Get_PARun_Status')?['status']}  @{variables('RunDate')} @{variables('AttachmentName')}",
                                                                        "Importance": "Normal"
                                                                    },
                                                                    "path": "/Mail"
                                                                }
                                                            }
                                                        },
                                                        "else": {
                                                            "actions": {}
                                                        },
                                                        "runAfter": {
                                                            "Until_PARun_check": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    },
                                                    "Run_Load_BT_PG_Pipeline": {
                                                        "type": "ApiConnection",
                                                        "inputs": {
                                                            "host": {
                                                                "connection": {
                                                                    "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                                }
                                                            },
                                                            "method": "post",
                                                            "body": {
                                                                "FileName": ***@***.***('For_each')?['Name']",
                                                                "RunDate": ***@***.***('RunDate')"
                                                            },
                                                            "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelines/@{encodeURIComponent('Load_BT_PG_Stage')}/CreateRun",
                                                            "queries": {
                                                                "x-ms-api-version": "2017-09-01-preview"
                                                            }
                                                        }
                                                    },
                                                    "Set_PARun_to_false": {
                                                        "type": "SetVariable",
                                                        "inputs": {
                                                            "name": "PARun",
                                                            "value": ***@***.***(false)"
                                                        },
                                                        "runAfter": {
                                                            "Check_BT_Penguin_Run_Status_Failed": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    },
                                                    "Until_PARun_check": {
                                                        "type": "Until",
                                                        "expression": ***@***.***(variables('PARun'), bool(true))",
                                                        "limit": {
                                                            "count": 60,
                                                            "timeout": "PT1H"
                                                        },
                                                        "actions": {
                                                            "10_Sec_Delay": {
                                                                "type": "Wait",
                                                                "inputs": {
                                                                    "interval": {
                                                                        "count": 10,
                                                                        "unit": "Second"
                                                                    }
                                                                }
                                                            },
                                                            "Check_PARun_Status": {
                                                                "type": "If",
                                                                "expression": {
                                                                    "and": [
                                                                        {
                                                                            "not": {
                                                                                "equals": [
                                                                                    ***@***.***('Get_PARun_Status')?['status']",
                                                                                    "InProgress"
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "actions": {
                                                                    "Set_PARun_to_true": {
                                                                        "type": "SetVariable",
                                                                        "inputs": {
                                                                            "name": "PARun",
                                                                            "value": ***@***.***(true)"
                                                                        }
                                                                    }
                                                                },
                                                                "else": {
                                                                    "actions": {}
                                                                },
                                                                "runAfter": {
                                                                    "Get_PARun_Status": [
                                                                        "Succeeded"
                                                                    ]
                                                                }
                                                            },
                                                            "Get_PARun_Status": {
                                                                "type": "ApiConnection",
                                                                "inputs": {
                                                                    "host": {
                                                                        "connection": {
                                                                            "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                                        }
                                                                    },
                                                                    "method": "get",
                                                                    "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelineRuns/@{encodeURIComponent(body('Run_Load_BT_PG_Pipeline')?['runId'])}",
                                                                    "queries": {
                                                                        "x-ms-api-version": "2017-09-01-preview"
                                                                    }
                                                                },
                                                                "runAfter": {
                                                                    "10_Sec_Delay": [
                                                                        "Succeeded"
                                                                    ]
                                                                }
                                                            }
                                                        },
                                                        "runAfter": {
                                                            "Run_Load_BT_PG_Pipeline": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    }
                                                },
                                                "case": "Pe"
                                            },
                                            "Spreadsheet_for_Ra": {
                                                "actions": {
                                                    "Check_RERun_Status_Successful": {
                                                        "type": "If",
                                                        "expression": {
                                                            "and": [
                                                                {
                                                                    "not": {
                                                                        "equals": [
                                                                            ***@***.***('Get_a_RERun_Status')?['status']",
                                                                            "Succeeded"
                                                                        ]
                                                                    }
                                                                }
                                                            ]
                                                        },
                                                        "actions": {
                                                            "Send_RARun_Failed_email": {
                                                                "type": "ApiConnection",
                                                                "inputs": {
                                                                    "host": {
                                                                        "connection": {
                                                                            "name": ***@***.***('$connections')['office365']['connectionId']"
                                                                        }
                                                                    },
                                                                    "method": "post",
                                                                    "body": {
                                                                        "To": ***@***.***",
                                                                        "Subject": "International Sales RE Ingest Failed",
                                                                        "Body": "@{body('Get_a_RERun_Status')?['status']}  @{variables('RunDate')} @{variables('AttachmentName')}"
                                                                    },
                                                                    "path": "/Mail"
                                                                }
                                                            }
                                                        },
                                                        "else": {
                                                            "actions": {}
                                                        },
                                                        "runAfter": {
                                                            "Until_RERun_check": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    },
                                                    "Run_Load_BT_RH_Pipeline": {
                                                        "type": "ApiConnection",
                                                        "inputs": {
                                                            "host": {
                                                                "connection": {
                                                                    "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                                }
                                                            },
                                                            "method": "post",
                                                            "body": {
                                                                "FileName": ***@***.***('For_each')?['Name']",
                                                                "RunDate": ***@***.***('RunDate')"
                                                            },
                                                            "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelines/@{encodeURIComponent('Load_BT_RH_Stage')}/CreateRun",
                                                            "queries": {
                                                                "x-ms-api-version": "2017-09-01-preview"
                                                            }
                                                        }
                                                    },
                                                    "Set_RERun_to_false": {
                                                        "type": "SetVariable",
                                                        "inputs": {
                                                            "name": "RERun",
                                                            "value": ***@***.***(false)"
                                                        },
                                                        "runAfter": {
                                                            "Check_RERun_Status_Successful": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    },
                                                    "Until_RERun_check": {
                                                        "type": "Until",
                                                        "expression": ***@***.***(variables('RERun'), bool(true))",
                                                        "limit": {
                                                            "count": 60,
                                                            "timeout": "PT1H"
                                                        },
                                                        "actions": {
                                                            "10_Sec_Delay_2": {
                                                                "type": "Wait",
                                                                "inputs": {
                                                                    "interval": {
                                                                        "count": 10,
                                                                        "unit": "Second"
                                                                    }
                                                                }
                                                            },
                                                            "Check_RERun_Status": {
                                                                "type": "If",
                                                                "expression": {
                                                                    "and": [
                                                                        {
                                                                            "not": {
                                                                                "equals": [
                                                                                    ***@***.***('Get_a_RERun_Status')?['status']",
                                                                                    "InProgress"
                                                                                ]
                                                                            }
                                                                        }
                                                                    ]
                                                                },
                                                                "actions": {
                                                                    "Set_RERun_to_true": {
                                                                        "type": "SetVariable",
                                                                        "inputs": {
                                                                            "name": "RERun",
                                                                            "value": ***@***.***(true)"
                                                                        }
                                                                    }
                                                                },
                                                                "else": {
                                                                    "actions": {}
                                                                },
                                                                "runAfter": {
                                                                    "Get_a_RERun_Status": [
                                                                        "Succeeded"
                                                                    ]
                                                                }
                                                            },
                                                            "Get_a_RERun_Status": {
                                                                "type": "ApiConnection",
                                                                "inputs": {
                                                                    "host": {
                                                                        "connection": {
                                                                            "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                                        }
                                                                    },
                                                                    "method": "get",
                                                                    "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelineRuns/@{encodeURIComponent(body('Run_Load_BT_RH_Pipeline')?['runId'])}",
                                                                    "queries": {
                                                                        "x-ms-api-version": "2017-09-01-preview"
                                                                    }
                                                                },
                                                                "runAfter": {
                                                                    "10_Sec_Delay_2": [
                                                                        "Succeeded"
                                                                    ]
                                                                }
                                                            }
                                                        },
                                                        "runAfter": {
                                                            "Run_Load_BT_RH_Pipeline": [
                                                                "Succeeded"
                                                            ]
                                                        }
                                                    }
                                                },
                                                "case": "ra"
                                            }
                                        }
                                    }
                                },
                                "case": "BT"
                            },
                            "Filename_contains_Bookazine": {
                                "actions": {
                                    "Check_Bookazine_Run_Status": {
                                        "type": "If",
                                        "expression": {
                                            "and": [
                                                {
                                                    "not": {
                                                        "equals": [
                                                            ***@***.***('Get_a_pipeline_run')?['status']",
                                                            "Succeeded"
                                                        ]
                                                    }
                                                }
                                            ]
                                        },
                                        "actions": {
                                            "Send_Bookazine_Failed_email": {
                                                "type": "ApiConnection",
                                                "inputs": {
                                                    "host": {
                                                        "connection": {
                                                            "name": ***@***.***('$connections')['office365']['connectionId']"
                                                        }
                                                    },
                                                    "method": "post",
                                                    "body": {
                                                        "To": ***@***.***",
                                                        "Subject": "International Sales Bookazine Run Failed",
                                                        "Body": "@{body('Get_a_pipeline_run')?['status']}  @{variables('RunDate')} @{variables('AttachmentName')}",
                                                        "Importance": "Normal"
                                                    },
                                                    "path": "/Mail"
                                                }
                                            }
                                        },
                                        "else": {
                                            "actions": {}
                                        },
                                        "runAfter": {
                                            "Until_Bookazine_Run_is_complete": [
                                                "Succeeded"
                                            ]
                                        }
                                    },
                                    "Run_Load_Bookazine_pipeline": {
                                        "type": "ApiConnection",
                                        "inputs": {
                                            "host": {
                                                "connection": {
                                                    "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                }
                                            },
                                            "method": "post",
                                            "body": {
                                                "FileName": ***@***.***('For_each')?['Name']",
                                                "RunDate": ***@***.***('RunDate')"
                                            },
                                            "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelines/@{encodeURIComponent('Load_Bookazine_Stage')}/CreateRun",
                                            "queries": {
                                                "x-ms-api-version": "2017-09-01-preview"
                                            }
                                        }
                                    },
                                    "Set_BookazineRun_to_false": {
                                        "type": "SetVariable",
                                        "inputs": {
                                            "name": "BookazineRun",
                                            "value": ***@***.***(false)"
                                        },
                                        "runAfter": {
                                            "Check_Bookazine_Run_Status": [
                                                "Succeeded"
                                            ]
                                        }
                                    },
                                    "Until_Bookazine_Run_is_complete": {
                                        "type": "Until",
                                        "expression": ***@***.***(variables('BookazineRun'), bool(true))",
                                        "limit": {
                                            "count": 60,
                                            "timeout": "PT1H"
                                        },
                                        "actions": {
                                            "Bookazine_Delay": {
                                                "type": "Wait",
                                                "inputs": {
                                                    "interval": {
                                                        "count": 10,
                                                        "unit": "Second"
                                                    }
                                                }
                                            },
                                            "Get_a_pipeline_run": {
                                                "type": "ApiConnection",
                                                "inputs": {
                                                    "host": {
                                                        "connection": {
                                                            "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                        }
                                                    },
                                                    "method": "get",
                                                    "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelineRuns/@{encodeURIComponent(body('Run_Load_Bookazine_pipeline')?['runId'])}",
                                                    "queries": {
                                                        "x-ms-api-version": "2017-09-01-preview"
                                                    }
                                                },
                                                "runAfter": {
                                                    "Bookazine_Delay": [
                                                        "Succeeded"
                                                    ]
                                                }
                                            },
                                            "Wait_for_Bookazine_Run_to_complete": {
                                                "type": "If",
                                                "expression": {
                                                    "and": [
                                                        {
                                                            "not": {
                                                                "equals": [
                                                                    ***@***.***('Get_a_pipeline_run')?['status']",
                                                                    "InProgress"
                                                                ]
                                                            }
                                                        }
                                                    ]
                                                },
                                                "actions": {
                                                    "Set_Bookazine_run_to_true": {
                                                        "type": "SetVariable",
                                                        "inputs": {
                                                            "name": "BookazineRun",
                                                            "value": ***@***.***(true)"
                                                        }
                                                    }
                                                },
                                                "else": {
                                                    "actions": {}
                                                },
                                                "runAfter": {
                                                    "Get_a_pipeline_run": [
                                                        "Succeeded"
                                                    ]
                                                }
                                            }
                                        },
                                        "runAfter": {
                                            "Run_Load_Bookazine_pipeline": [
                                                "Succeeded"
                                            ]
                                        }
                                    }
                                },
                                "case": "Bo"
                            },
                            "Filename_contains_Ingram": {
                                "actions": {
                                    "Check_Ingram_Run_Status": {
                                        "type": "If",
                                        "expression": {
                                            "and": [
                                                {
                                                    "not": {
                                                        "equals": [
                                                            ***@***.***('Get_Ingram_pipeline_run_status')?['status']",
                                                            "Succeeded"
                                                        ]
                                                    }
                                                }
                                            ]
                                        },
                                        "actions": {
                                            "Send_Ingram_failed_email": {
                                                "type": "ApiConnection",
                                                "inputs": {
                                                    "host": {
                                                        "connection": {
                                                            "name": ***@***.***('$connections')['office365']['connectionId']"
                                                        }
                                                    },
                                                    "method": "post",
                                                    "body": {
                                                        "To": ***@***.***",
                                                        "Subject": "International Sales Ingram Load Failed",
                                                        "Body": "@{body('Get_Ingram_pipeline_run_status')?['status']}  @{variables('RunDate')} @{variables('AttachmentName')}",
                                                        "Importance": "Normal"
                                                    },
                                                    "path": "/Mail"
                                                }
                                            }
                                        },
                                        "else": {
                                            "actions": {}
                                        },
                                        "runAfter": {
                                            "Until_Ingram_Run_complete": [
                                                "Succeeded"
                                            ]
                                        }
                                    },
                                    "Run_Load_Ingram_pipeline": {
                                        "type": "ApiConnection",
                                        "inputs": {
                                            "host": {
                                                "connection": {
                                                    "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                }
                                            },
                                            "method": "post",
                                            "body": {
                                                "FileName": ***@***.***('For_each')?['Name']",
                                                "RunDate": ***@***.***('RunDate')"
                                            },
                                            "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelines/@{encodeURIComponent('Load_Ingram')}/CreateRun",
                                            "queries": {
                                                "x-ms-api-version": "2017-09-01-preview"
                                            }
                                        }
                                    },
                                    "Set_IngramRun_to_false": {
                                        "type": "SetVariable",
                                        "inputs": {
                                            "name": "IngramRun",
                                            "value": ***@***.***(false)"
                                        },
                                        "runAfter": {
                                            "Check_Ingram_Run_Status": [
                                                "Succeeded"
                                            ]
                                        }
                                    },
                                    "Until_Ingram_Run_complete": {
                                        "type": "Until",
                                        "expression": ***@***.***(variables('IngramRun'), bool(true))",
                                        "limit": {
                                            "count": 60,
                                            "timeout": "PT1H"
                                        },
                                        "actions": {
                                            "Get_Ingram_pipeline_run_status": {
                                                "type": "ApiConnection",
                                                "inputs": {
                                                    "host": {
                                                        "connection": {
                                                            "name": ***@***.***('$connections')['azuredatafactory']['connectionId']"
                                                        }
                                                    },
                                                    "method": "get",
                                                    "path": "/subscriptions/@{encodeURIComponent('f34918e0-5182-4f13-b12d-4388432474c7')}/resourcegroups/@{encodeURIComponent('RG-PRH_PowerBI')}/providers/Microsoft.DataFactory/factories/@{encodeURIComponent('adf-singularity-prd')}/pipelineRuns/@{encodeURIComponent(body('Run_Load_Ingram_pipeline')?['runId'])}",
                                                    "queries": {
                                                        "x-ms-api-version": "2017-09-01-preview"
                                                    }
                                                },
                                                "runAfter": {
                                                    "Ingram_Delay": [
                                                        "Succeeded"
                                                    ]
                                                }
                                            },
                                            "Ingram_Delay": {
                                                "type": "Wait",
                                                "inputs": {
                                                    "interval": {
                                                        "count": 10,
                                                        "unit": "Second"
                                                    }
                                                }
                                            },
                                            "Wait_for_Ingram_Run_to_complete": {
                                                "type": "If",
                                                "expression": {
                                                    "and": [
                                                        {
                                                            "not": {
                                                                "equals": [
                                                                    ***@***.***('Get_Ingram_pipeline_run_status')?['status']",
                                                                    "InProgress"
                                                                ]
                                                            }
                                                        }
                                                    ]
                                                },
                                                "actions": {
                                                    "Set_IngramRun_to_true": {
                                                        "type": "SetVariable",
                                                        "inputs": {
                                                            "name": "IngramRun",
                                                            "value": ***@***.***(true)"
                                                        }
                                                    }
                                                },
                                                "else": {
                                                    "actions": {}
                                                },
                                                "runAfter": {
                                                    "Get_Ingram_pipeline_run_status": [
                                                        "Succeeded"
                                                    ]
                                                }
                                            }
                                        },
                                        "runAfter": {
                                            "Run_Load_Ingram_pipeline": [
                                                "Succeeded"
                                            ]
                                        }
                                    }
                                },
                                "case": "In"
                            }
                        },
                        "runAfter": {
                            "Create_block_blob": [
                                "Succeeded"
                            ]
                        }
                    }
                },
                "runAfter": {
                    "Initialize_BookazineRun": [
                        "Succeeded"
                    ]
                },
                "runtimeConfiguration": {
                    "concurrency": {
                        "repetitions": 1
                    }
                }
            },
            "HTTP": {
                "type": "Http",
                "inputs": {
                    "uri": "https://prod-03.eastus2.logic.azure.com/servers/ssas2prd/models/RG-PRH_PowerBI/refreshes",
                    "method": "POST",
                    "body": {
                        "Objects": [
                            {
                                "database": "Singularity",
                                "table": "International Sales"
                            }
                        ],
                        "type": "full"
                    },
                    "authentication": {
                        "audience": "https://*.asazure.windows.net",
                        "clientId": "3afc0682-13e2-41a4-afaa-8b7b72b7259a",
                        "secret": "7eb267ee-88d9-4106-979b-017d2c53e0bd",
                        "tenant": "35a3d2a4-3172-457d-8b65-131efb2a337e",
                        "type": "ActiveDirectoryOAuth"
                    }
                },
                "runAfter": {
                    "Send_an_email_(V2)": [
                        "SUCCEEDED"
                    ]
                },
                "operationOptions": "DisableAsyncPattern"
            },
            "Initialize_BookazineRun": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "BookazineRun",
                            "type": "Boolean",
                            "value": ***@***.***(false)"
                        }
                    ]
                },
                "runAfter": {
                    "Initialize_IngramRun": [
                        "Succeeded"
                    ]
                }
            },
            "Initialize_IngramRun": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "IngramRun",
                            "type": "Boolean",
                            "value": ***@***.***(false)"
                        }
                    ]
                },
                "runAfter": {
                    "Initialize_RERun": [
                        "Succeeded"
                    ]
                }
            },
            "Initialize_PARun": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "PARun",
                            "type": "Boolean",
                            "value": ***@***.***(false)"
                        }
                    ]
                },
                "runAfter": {
                    "Initialize_variable": [
                        "Succeeded"
                    ]
                }
            },
            "Initialize_RERun": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "RERun",
                            "type": "Boolean",
                            "value": ***@***.***(false)"
                        }
                    ]
                },
                "runAfter": {
                    "Initialize_PARun": [
                        "Succeeded"
                    ]
                }
            },
            "Initialize_RunDate": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "RunDate",
                            "type": "String"
                        }
                    ]
                },
                "runAfter": {}
            },
            "Initialize_variable": {
                "type": "InitializeVariable",
                "inputs": {
                    "variables": [
                        {
                            "name": "AttachmentName",
                            "type": "string"
                        }
                    ]
                },
                "runAfter": {
                    "Initialize_RunDate": [
                        "Succeeded"
                    ]
                }
            },
            "Send_an_email_(V2)": {
                "type": "ApiConnection",
                "inputs": {
                    "host": {
                        "connection": {
                            "referenceName": null
                        }
                    },
                    "method": "post",
                    "body": {
                        "To": "",
                        "Subject": "",
                        "Body": "",
                        "Importance": "Normal"
                    },
                    "path": "/v2/Mail"
                },
                "runAfter": {
                    "For_each": [
                        "Succeeded"
                    ]
                }
            }
        },
        "outputs": {},
        "parameters": {
            "$connections": {
                "type": "Object",
                "defaultValue": {}
            }
        }
    },
    "parameters": {
        "$connections": {
            "value": {
                "office365": {
                    "id": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/providers/Microsoft.Web/locations/eastus2/managedApis/office365",
                    "connectionId": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/resourceGroups/RG-PRH_PowerBI/providers/Microsoft.Web/connections/office365",
                    "connectionName": "office365"
                },
                "azureblob_1": {
                    "id": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/providers/Microsoft.Web/locations/eastus2/managedApis/azureblob",
                    "connectionId": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/resourceGroups/RG-PRH_PowerBI/providers/Microsoft.Web/connections/azureblob-1",
                    "connectionName": "azureblob-1"
                },
                "azuredatafactory": {
                    "id": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/providers/Microsoft.Web/locations/eastus2/managedApis/azuredatafactory",
                    "connectionId": "/subscriptions/f34918e0-5182-4f13-b12d-4388432474c7/resourceGroups/RG-PRH_PowerBI/providers/Microsoft.Web/connections/azuredatafactory-1",
                    "connectionName": "azuredatafactory-1"
                }
            }
        }
    }
}
ccastrotrejo commented 6 days ago

Hi @TroyDeppert we didn't see anything anormal from the workflow schema. Is there any chance we can get the network logs from whenever you open the designer and it prompts to create a new connection? You can do that by following the steps of this guide collecting-network-logs-in-a-har-file Please send the HAR file to my email: ccastrotrejo@microsoft.com as this might contain sensitive information

TroyDeppert commented 6 days ago

So, even after zipping the file, it wouldn’t send it. I could drop it into Box if that’s OK for you all.

From: Carlos Emiliano Castro Trejo @.> Sent: Tuesday, November 12, 2024 12:25 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

Hi @TroyDepperthttps://github.com/TroyDeppert we didn't see anything anormal from the workflow schema. Is there any chance we can get the network logs from whenever you open the designer and it prompts to create a new connection? You can do that by following the steps of this guide collecting-network-logs-in-a-har-filehttps://agreeable-beach-04ed7ce1e.5.azurestaticapps.net/tsg#collecting-network-logs-in-a-har-file Please send the HAR file to my email: @.**@.> as this might contain sensitive information

— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2471145260, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPQY73JR6WNQ5V35MQ32AI2YNAVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDINZRGE2DKMRWGA. You are receiving this because you were mentioned.Message ID: @.**@.>>

github-actions[bot] commented 3 days ago

We requested more information to triage this issue. If the issue goes more than 7 days with no more information it'll be automatically closed.

TroyDeppert commented 2 days ago

I sent an email that the log capture was too large to send via email even when zipped. I asked if you could pull it from a Box account.

Troy


From: github-actions[bot] @.> Sent: Friday, November 15, 2024 5:02:41 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

We requested more information to triage this issue. If the issue goes more than 7 days with no more information it'll be automatically closed.

— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2480009623, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPW5JC7XHF6XT6UWB7L2AZVQDAVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBQGAYDSNRSGM. You are receiving this because you were mentioned.Message ID: @.***>

ccastrotrejo commented 1 day ago

Hi @TroyDeppert yes if you could provide us a link from where to download it, would be great!

TroyDeppert commented 12 hours ago

Hello Carlos,

Here is the link to the file: https://www.dropbox.com/scl/fo/ed9s8f7gdcr9dl9oe0c2j/APdxVHHRItgZ8B39ItYVM2c?rlkey=zsgxpboz8h33fxfgq5sersvmn&st=0p6dxfk1&dl=0

Please email if there is a problem accessing the file.

Thanks, Troy

From: Carlos Emiliano Castro Trejo @.> Sent: Sunday, November 17, 2024 6:53 PM To: Azure/LogicAppsUX @.> Cc: Deppert, Troy @.>; Mention @.> Subject: Re: [Azure/LogicAppsUX] Outlook SendEmail V2 (Issue #6054)

CAUTION: This email originated from outside of Penguin Random House. Please be extra cautious when opening file attachments or clicking on links.

Hi @TroyDepperthttps://github.com/TroyDeppert yes if you could provide us a link from where to download it, would be great!

— Reply to this email directly, view it on GitHubhttps://github.com/Azure/LogicAppsUX/issues/6054#issuecomment-2481683576, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ARJWOPQLAC6REMUL54TOY4T2BET45AVCNFSM6AAAAABROE2TSCVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDIOBRGY4DGNJXGY. You are receiving this because you were mentioned.Message ID: @.**@.>>