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

Question

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

Answer 1

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.