How to delete or Clean " Dead Letter Query " in Azure Service Bus by Logic

Question

Requirement : 

 1. Recurrence every week 
 2. when msg go to Dead letter Query , manager/Responsible Person get notification by email 
 3. Condition / Action : 
      1.Msg will be automatically deleted after 10 day from Topic in Azure service Bus NS
      2. Confirmation msg sent to Manager/Responsible Person

Answer 1

Hello @Emran Hossain - Thanks for reaching out, and posting on the MS Q&A. I understand you want to build automation using Logic Apps to send notifications based on when a message arrives at the Dead Letter Queue in your Service Bus namespace. If my understanding is correct, could you clarify the following?

• Do you want to trigger the notification workflow on a weekly recurring schedule or whenever a message arrives at the Dead Letter Queue? The former is a time-bound trigger and the latter is event based trigger, please confirm which one is ideal for your scenario.
• Regarding the Condition, could you share details on what needs to be checked? Or did you mean that it's more of an Action that keeps the message in the Dead Letter Queue for up to 10 days before deleting it automatically on day 10, and completes the workflow by sending another notification email?