Logic app to retrieve the latest file from a blob folder

Question

How can I create a logic app that retrieves the latest file from a blob folder when a Http request is received, where there are multiple files, and sends it as an attachment? Are there any specific steps or configurations required for this process?

Answer 1

Hello,

Thank you for raising the post.

To create a logic app that retrieves the latest file from a blob folder when a Http request is received, where there are multiple files, and sends it as an attachment, you can follow these steps:

1. Create a new logic app in the Azure portal.
2. Add a "When a HTTP request is received" trigger to your logic app.
3. Add a "List blobs" action to your logic app, and configure it to list the blobs in the desired container and folder.
4. Add a "Filter array" action to your logic app, and configure it to filter the blobs to only include the ones that match your desired criteria (e.g. only include blobs with a certain prefix or extension).
5. Add a "Sort array" action to your logic app, and configure it to sort the filtered blobs by their "Last Modified" property in descending order.
6. Add a "Get blob content" action to your logic app, and configure it to get the content of the first blob in the sorted array (which should be the latest one).
7. Add a "Create HTML table" action to your logic app, and configure it to create an HTML table that includes the name and URL of the latest blob. 8. Add a "Send an email" action to your logic app, and configure it to send an email with the HTML table as an attachment.

These are the general steps you can follow to create a logic app that retrieves the latest file from a blob folder when a Http request is received, where there are multiple files, and sends it as an attachment.
However, the specific configurations required for each action may vary depending on your specific scenario.

Hope it helps.

Answer 2

Hi Aditya,

If I am reading this correctly, you are looking to check if a new blob is added (a trigger). Please see the following documentation:

Add a Blob trigger

https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-azureblobstorage?tabs=standard#add-a-blob-trigger

When going through the steps, you can see what types of tasks you can use:

Then Add an Action:

https://learn.microsoft.com/en-us/azure/connectors/connectors-create-api-azureblobstorage?tabs=standard#add-a-blob-action

Hopefully this helps.

If this is helpful please accept answer.