Can a logic app read/search a excel file from an azure storage account?

garthoid 21 Reputation points
2021-01-14T20:33:05.46+00:00

Is there any documentation on how a Logic App can read an excel file in an azure storage account container?

The Excel connectors in Logic Apps seem to be only for OneDrive and O365.

I have an excel spreadsheet residing in a container in an azure storage account.

I can use an Azure Logic App with the "Get Blob Content" to access the file. But I cannot find any documentation discussing actually reading the file within the Azure Logic App from blob storage. Note that there are connectors for accessing Excel files in OneDrive or Office365 but not from a storage account container.

Despite furious searching I have not found any discussion of this use case in Microsoft Documentation or otherwise. Any links would be appreciated.

My goal is to search a worksheet in an excel file in a storage account and return matching rows from within my Logic App.

Thanks

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,763 questions
Azure Logic Apps
Azure Logic Apps
An Azure service that automates the access and use of data across clouds without writing code.
2,899 questions
0 comments No comments
{count} votes

Accepted answer
  1. MayankBargali-MSFT 69,581 Reputation points
    2021-01-15T08:30:33.107+00:00

    Hi @garthoid

    Welcome to Microsoft Q&A! Thanks for posting the question.

    There is no azure blob connectors action that can help you to search the worksheet and return the matched rows.

    The workaround would be calling Azure Functions from the logic app to process your logic. You need to write your custom code/logic to get the data from the storage blob and return your expected result based on your input that you are passing to the azure function from the logic app.

    If you want to leverage the Excel Online (Business) and Excel Online (Onedrive) connectors then first I will suggest you review the limitation of both the connectors and if it fits your business logic then you can leverage create file action that will create the temporary file in your ondrive and then perform the excel operation to get the desired result.

    Your logic app workflow will be using Onedrive for Business :

    Get Blob Content (Gets the binary file content) --> Create file (previous binary file content needs to be passed in File Content paramter ) --> List Rows present in a table (having filter query) --> Delete File (delete the excel file from ondrive)

    Similarly, you can leverage OneDrive actions.

    Hope the above helps and feel free to get back to me if you have queries.

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

    3 people found this answer helpful.
    0 comments No comments

0 additional answers

Sort by: Most helpful