cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianCCampbell
Helper I
Helper I

Using AzureBlobStorage.ListFolderv2 To list only items in a specific folder and Delegation

I have a PowerApp that utilizes Azure Storage (Blob). It is a bit backward from all the examples I could find as the file is not uploaded directly through PowerApps. The App is connected to a data source (on-premise SQL server) that provides back a list of files as a data source in the app. I display this list to the user in a gallery and they can select one of these files to upload it as a blob in Azure Storage. I had to really mouse-trap this up as the file is accessible by the on-prem SQL server and not necessarily the PowerApps user if they are not inside the corporate LAN when running the PowerApp. I created a PowerApp initiated cloud Power Automate to invoke a Stored Procedure on the on-premise SQL server that in turn runs Azcopy.exe to copy up the file to Azure storage as a blob in a specific folder in the container. Surprisingly it works very well for how many pieces are in the path for it to run.

The challenge I had was not knowing the ID of the blob since it didn't go through the PowerApp image or camera control which uses the appres://blobmanager to figure all that info out. However, I did find (after many hours of searching) a post by Peter Hefner @Lingualizer  that does what I need it to do. The code is this:

 for a Gallery:  Items = AzureBlobStorage.ListFolderV2(LookUp( AzureBlobStorage.ListFolderV2("containername").value, DisplayName="foldername" & "/", Id)).value

This works well and just as expected. The question I wanted to know from my fine PowerApps peers is this: Is the AzureBlobStorage.ListFolderContentsV2 control delegable? I don't see Azure Storage listed as a source on the page that speaks about it. The good (promising) view is that there are no delegation warnings in the PowerApps studio when using the code above, but wanted to know if anyone knows for sure before I get 500 folders in Azure storage to find out there is a problem.

1 ACCEPTED SOLUTION

Accepted Solutions
BrianCCampbell
Helper I
Helper I

I opened a support ticket with MS to get this answer and wanted to share it for future travelers....

The good news is that it does not seem to be impacted by the delegation as I tested lowering the delegation setting in PowerApps without issue and also from the MS response below.
 
----------------------------------------------------------

As per the last mail I got to know that “You wanted to know is there any delegation limit on Azure Blob Storage Related to PowerApps ? And the result of the formula
Items = AzureBlobStorage.ListFolderV2(LookUp( AzureBlobStorage.ListFolderV2("containername").value, DisplayName="foldername" & "/", Id)).value”
 
 
As per delegation till now there is no known limit on Azure Blob Storage. The only limits and delegation identified by Microsoft are listed in the below document.:
https://docs.microsoft.com/en-us/connectors/azureblob/
 
 
As per what I understood from the formula, I would say that the filtering happens on the BlobStorage side, therefore the narrowed/desired result set is coming from Azure.
 
----------------------------------------------------------
 
 
 
 

View solution in original post

2 REPLIES 2
BrianCCampbell
Helper I
Helper I

A thank you to  @RezaDorrani or @Shanescows for their videos on using the AzureBlobStorage connector and also a shameless way to see if they have anything to input about this question.

BrianCCampbell
Helper I
Helper I

I opened a support ticket with MS to get this answer and wanted to share it for future travelers....

The good news is that it does not seem to be impacted by the delegation as I tested lowering the delegation setting in PowerApps without issue and also from the MS response below.
 
----------------------------------------------------------

As per the last mail I got to know that “You wanted to know is there any delegation limit on Azure Blob Storage Related to PowerApps ? And the result of the formula
Items = AzureBlobStorage.ListFolderV2(LookUp( AzureBlobStorage.ListFolderV2("containername").value, DisplayName="foldername" & "/", Id)).value”
 
 
As per delegation till now there is no known limit on Azure Blob Storage. The only limits and delegation identified by Microsoft are listed in the below document.:
https://docs.microsoft.com/en-us/connectors/azureblob/
 
 
As per what I understood from the formula, I would say that the filtering happens on the BlobStorage side, therefore the narrowed/desired result set is coming from Azure.
 
----------------------------------------------------------
 
 
 
 

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (43,465)