Automating Blob Verification and Email Notification Using Azure Logic Apps

Question

Hello everyone,

I’m working on a solution to archive data in Azure on a daily basis. Each day, two blobs will be uploaded to a storage container following this naming convention:

security-data-yyyymmdd.csv

security-data-yyyymmdd.json

I’d like to automate the process of verifying whether these uploads were successful and send an email notification to stakeholders with the results. For this, I’ve chosen to use Azure Logic Apps, as it seems to be the most suitable tool for the job.

However, I’m new to Logic Apps and would really appreciate guidance on how to implement the following workflow:

1. Check for File Existence within a container:
   Navigate to a specific container and verify if both the .csv and .json files from yesterday's date exist. I will Include the status (found or not found) in the email.

Extract Value from JSON:
Read the .json file and extract the value of a specific field. This value should also be included in the email.

1. Count Files in a second Container:
   Access a second container and count the number of files that were uploaded yesterday. Include this count in the email notification.

If anyone can help break down how to implement these steps using Logic Apps, or point me to relevant examples or templates, I’d be extremely grateful.

Thanks in advance!

Answer 1

Hello Zorghost,

Thanks for your time over the meeting.

We have configured the logic app as shown in below image to meet your requirements,

If this answer was helpful, please click "Accept the answer" and mark Yes, as this can help other community members.

If you have any other questions or are still experiencing issues, feel free to ask in the "comments" section, and I'd be happy to help.