How to get blob URL using Logic App Standard

Question

How to get the blob URL from Azure Blob Storage?

The trigger is when a blob is added or modified. The blob content could be read and I was very happy as I could insert the content into an Azure Table property, so using PK and RK the file content would be quickly retrieved.

However with larger blobs it did not work due to 32k max size for a property. The approach to overcome this limitation seems to be to save the URL blob into the property but for my life I cannot figure it out how (tried almost all actions, even those that did not make sense, perhaps the url was somewhere in the output)

Answer 1

As your trigger already watches a specific Storage Account, why dont you simple concat the base URL (https://"StorageAccountName".blob.core.windows.net) with the "File Path"-Parameter of the Connector? As far as i know there is no connector (yet) that gives you that information ..

Answer 2

I found the solution. one drive wont allow share a video link. it shares a office 365 link i recommend using blob storage for connection.

https://learn.microsoft.com/en-us/azure/logic-apps/logic-apps-gateway-connection