cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BrianCCampbell
Resolver I
Resolver 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
Resolver I
Resolver 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
Resolver I
Resolver 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
Resolver I
Resolver 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

secondImage

Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,407)