What do I need to fix my List Blobs (V2) action in my Logic App?

Question

What do I need to fix my List Blobs (V2) action in my Logic App?

Anonymous

I'm new to logic apps and I'm having an issue trying to get a list of blobs from my blob storage trigger. The blob trigger is working, so I know the connection is valid, but the List Blobs (V2) is erroring when I debug it in VS Code.

Here's my List Blobs action

User's image

And here's the error I'm getting when I attempt to debug it.
User's image

User's image

Then, I tried changing the connection to the runtime blob URL.

User's image

When I ran it in debug I got the following error.

User's image

Now, in the above case, the error may be correct, because the blob storage contains CSV files, not JSON files. So, this may be getting closer.

Anyway, I'd appreciate any suggestions. Thanks!

Sampath 3,875 Reputation points Microsoft External Staff Moderator

2025-06-06T03:23:56.8233333+00:00
Hello @Proctor, Chris ,

To implement this requirement, you can refer to my steps below:

1. Use "List blobs" to list all of the blobs in your folder in storage.

2. Then add "For each" loop in your logic app to loop the value from "List blobs". And in "For each" loop, use "Insert row(V2)" to insert each file name into your sql table.

By the way, before the step2 I have already created a table named FilesTable in my azure sql db like below screenshot:

And when you use "For each" loop to insert the rows, it's better for us to enable "Concurrency Control" and set Degree of Parallelism to 1 to escape concurrency issue.

Here’s a step-by-step explanation and implementation details based on the List Blobs (V2) action and the ForEach loop in a Logic App:

Create a Logic App (Consumption or Standard)

Go to the Azure portal.

Create a new Logic App (Consumption) or Logic App (Standard).

Open the Logic App Designer.

Add a Trigger

Choose a trigger that suits your scenario, for example:

When a blob is added or modified (properties only) (Azure Blob Storage trigger)

Recurrence (if you want to list blobs on a schedule)

Add the “List blobs (V2)” Action

In the designer, click New step.

Search for Azure Blob Storage connector and select it.

Choose List blobs (V2).

Configure the connection (provide storage account connection details).

Provide the Container name for which you want to list blobs.

Input for List blobs (V2):

Container: The name of your Blob container (e.g., mycontainer).

This action returns a list of blobs in the specified container.

Add a ForEach Control to Iterate Over Each Blob

Click + New step below the List Blobs action.

Search for and select ForEach from Control actions.

In the Select an output from previous steps box, choose value from the List Blobs (V2) output (this is the array of blob items).

Inside the ForEach Loop

Click Add an action inside the ForEach loop.

Choose the action you want to perform on each blob.

For example: Get blob content (V2) to read the contents.

Or Send an email with blob metadata.

Use dynamic content to access properties of each blob, like:

@items('For_each')?['Name'] for the blob name.

@items('For_each')?['Path'] for the path.

Example JSON Flow (For Logic App Definition)

Here’s a conceptual snippet of what the Logic App workflow’s JSON definition might look like:

{ "definition": { "actions": { "List_blobs": { "inputs": { "host": { "connection": { "name": "@parameters('$connections')['azureblob']['connectionId']" } }, "method": "get", "path": "/v2/listBlobs", "queries": { "container": "mycontainer" } }, "runAfter": {}, "type": "ApiConnection" }, "For_each": { "actions": { "Get_blob_content": { "inputs": { "host": { "connection": { "name": "@parameters('$connections')['azureblob']['connectionId']" } }, "method": "get", "path": "/v2/getBlob", "queries": { "path": "@items('For_each')?['Path']" } }, "runAfter": {}, "type": "ApiConnection" } }, "foreach": "@outputs('List_blobs')?['body/value']", "runAfter": { "List_blobs": ["Succeeded"] }, "type": "Foreach" } }, "triggers": { "manual": { "type": "Request", "kind": "Http", "inputs": {} } } } }

List Blobs (V2) documentation: Details on inputs like container name, prefix, and output schema.

ForEach loop documentation:

Share via

What do I need to fix my List Blobs (V2) action in my Logic App?

Add a Trigger

Add the “List blobs (V2)” Action

Add a ForEach Control to Iterate Over Each Blob

Inside the ForEach Loop

Example JSON Flow (For Logic App Definition)

Your answer