powerapps azure blob storage connector 

You rock - not only in the content and knowledge part, but also in its delivery. I am new to PowerApps and your videos are helping me so much.

Awesome. Evernote says I took 853 words of notes from this video, not counting the screensnaps. I have a lot to work with now. I'd have spend 3-4 hrs minimum and still not figured it all out. Thanks for the work on this!

Hi Shane, I used your technique here for that last 5 weeks with the blobs whereby I could save them and then retrieve them from two separate buttons in the app. AND IT WORKED FANTASTICALLY!!! But last, week, for no apparent reason, I could not retrieve the files anymore using that File SAS technique (around 25:58) and code you demonstrated in this video (and I had not changed anything.) I realized at 25:58, that in the video, you clicked on the Generate container-level shared access signature URI. Now it is no longer there in Storage Explorer! and I think the functionality is no longer there either (at least from my investigation) and therefore the SAS key no longer works for all my files, but only the one I set it up with. I need it to retrieve any file I have stored. How I got it to work again was to right click on the container name itself, then select "Get Share Access Signature" at the container level (not the file level.) Once I used that container SAS key in my code, instead of the SAS at the file level, it solved my problem. I wanted to share with you and people watching this. I am sure it was working the way you described up to a week ago, maybe Azure changed something (of course it could also be something in my system or myself.) Please let me know, if you see the same. Thanks for all the great material.

Great Video Shane, lot of new concepts, thanks for the same!

🤺Master class for Jedis ! Thank you Shane from Spain

Thank Shane for sharing! I have a better understanding of Azure Blob Storage. (also thanks for your time last week at the App-in-a-Day session as I learned so much and getting more confident with PowerApps ... it was your session and Daniel's (Christian) video that reminded me about this video on blob storage) ... en route to becoming a #PowerAddict 😂

You my Sir are a good person. Holy in my eyes, I learn so much from you. I really want to be an expert some time in PowerApps and Flow. I just started 2 weeks ago and still need a LOT to learn. Could you make a video of the Most common used functions used in Power App? Thank you!!!

Thanks for sharing, Shane! Will try that with the pen input.

thanks for the help bro !! this helped me a lot ❣️

You are the GOD of powerapps. Be proud - be very proud..................

Simply brilliant - Thank you !

Great video Shane. Thank you

Another Great Tutorial!!

Brilliant video, it really helps me!

This is such a useful vid - I LOVE using azure blob especially as it's so fast.

Thanks for the video! Was extremely excited because we are totally looking for a solution for a problem we are facing right now with file sizes... I was excited till I read that you need a premium license to use this connector. Such a shame. For big companies those license costs might be peanuts, but for smaller sized companies (50-200 employees) where everyone should be able to use the PowerApp once in a while and where there is a tighter budget those extra costs on top of the normal O365 license is too much. Microsoft is really missing out because I've had to switch away from PowerApps for multiple companies now because of those license costs.

Hi Shane, thank you for the video. I just wonder about data privacy, so when we Change access level in the Storage account >> Containers to the Private (no anonymous access) level we get an error message when we try to open the files "The specified resource does not exist". Do you know why?

Thanks Shane😇

Hi Shane, great video! would you be able to let me know how to use ForAll(Collection, AzureBlobStorage.CreateFile...? i want users to collect all images in a gallery and then post all of them to the blob but getting an error here: ForAll(LocalCollection, AzureBlobStorage.CreateFile("AzureFolder",LocalCollection.Name,LocalCollection.Image) ) many thanks Tom

Shane, awesome video, I have a question though, if I store the AzureFileID in SQL along with an ExpenseTypeID I need to be able to retrieve that record for all expensetypes of say entertainment and show just those pictures relevant to that expensetype. How would you do that? Thanks!

Great Video Shane! Quick Question - is there a way to add metadata to the file? Ideally I would like to an a unique identifier to each file added so that I can filter it within an app.

Great video Shane - thanks so much - I'm sure you had to scratch your head a few times to get this all working! Are we able to use the Remove() function to remove the file from the blob storage?

Thank you very much for your videos. I have a question: I want to upload pictures captured from PowerApps app to my D365 NAV table. Can Azure Blob Storage be used for that?

Hi Shane, Thank you for yet another great tutorial. Is there an API which allows PowerApps to manage the blobstore folder structure and file access? ie. AzureBlobStorage.Root("Id").CreateFolder("/NewFolder") and something similar for the access level, as I believe setting up the access through the manager with the time restricted token is going to limit user acceptance.

That was cool. Thanks Shane. I have a question, how can we save Forms responses in Azure Blob Storage with questions?

Hey Shane, thanks for this can you also do a video on using the offline capability for power apps

thx for a great video! :) I have build an app and it is working great 👍 I have one question though. When I upload a picture (both horizontal and portrait) they have the same height&width (that is corrected by exif in PowerApps and my pc). But when I link (http to blob) to the pictures from Power BI all the pictures are shown horizontal. Do you have a trick for a: Correcting the height&width b: Ensure Power bi reads the exif Hope you can help :)

Hi Shane, great video tutorial. Thanks a lot for this. Is there an option to display text data of a blob on power apps? Or is downloading the file the only option to view it? I've tried PDF viewer and that works well, but if I want to display a text file or a JSON file, how should I go about doing that? Also I don't see an option for "Get Shared Access Signature" in my Storage Explore, any idea why that might be happening? Thanks

Hi Shane, what happens if the user shares the URL appended with the shared access signature key to the people outside the organisation. Presume its still accessible via public

Hi, is it possible to list files from a sub folder using ListFolderV2? My challenge is a blob container called “powerapp”, a folder for each case and a sub folder called “images”. So “powerapp/caseX/images”, “powerapp/caseY/images” etc. Is it possible to add the files in folder “images” to a collection so they can be shown in a gallery? The caseNo can be achieved from the actual record. I have tried almost everything 😏

Shane, great video! I am not a programmer, but still find this stuff very interesting. I assume that Azure Blob Storage is exclusively available to programmers for storing resources. As a someone who is not a programmer, but is has a great interest in learning how to program (just for my own enjoyment - yeah, I am a weird Dad/Grandfather), where would you recommend that I begin. In other words, if you were just starting out today, where would you begin? Thanks in advance!

Great video as always; for the file sector where you have the "add picture", is there any way to make it so it could add an entire folder? We have been uploading a folder and all files/subfolders within it using the Azure Storage Command Line application aka AzCopy, and this demo would be perfect except it only uploads one file at a time.

Hi Shane, as always really great video. While running it, I was able to pass information to the blob, but was not able to get it back into the App, using the AzureBlobStorage.ListFolderV2 function is giving the error : status: 404 error, message : specified container does not exist. Thanks.

Great video Shane!!! How do you control the filename before storing in the Blob? We notice that if a duplicate filename is stored, a version number is added. At retrieval time, how do you know which file to bring back? We're using the attachment control, do you recommend using the image control? Thanks!!!

Really cool video. Thank you. Shane, Other than speed, any disadvantage storing images to Azure sql vs Azure blob?

Great tutorial! My only complaint is with the ridiculous pricing of using the Premium blob connector. $10/user/app/month is a pretty hefty fee to try and justify, on top of the (minimal) blob storage fees. Unfortunately, we may have to go a different route entirely, even though I really like what you helped me build. I was even able to figure out how to automate the name to add a timestamp. Is there any possibility of adding image properties like geotagging? We'd like to use this for getting photos of assets, and they may want extra details.

Hi, is it possible for PA to recognize the fileformat when the user select from “all files”? I think it is non-dynamic that my user has to enter file name and extension manually. I would like to use GUID to make file name but I struggle with the extension.

Is it possible to view data from a file (.xlsx, .json, etc.) in a blob container in power apps? (ie. view the json object in the blob in a text field in power apps) So I can use the new function ParseJSON on that(?).

Hi Shane, thanks for another great tutorial. Is there a way users are not prompted for 0365 permissions when launching an app for the first time. It kind of make the users suspicious. A video in that regards will be great.

Hi Shane, Is it possible to store pdf/ excel file in SQL database? i don't have the option to use AzureBlobStorage. Thanks in advance your videos are really helpful

Hi Shane, Can you create a tutorial on uploading a file from local drive to azure data lake gen2?

Does this work with .msg file types. I've recreated solution and seems everything is working as designed, but .msg files wont open and i receive public access error (even those pdfs and xlsx files work fine)

Hi Shane, is it possible to add csv file content that is stored in azure blob storage to collections ?

Hi Shane! I'm now a serious follower of your videos. I'm trying to build an app (powerapps) for reporting with my little knowledge on this kind of stuff so yours videos are really precious. I'll have to creat forms with downdows, galleries, shearch, photos, etc., lists connected to sharepoint, excel files, storage pictures (azure), export to pdf, login to multiple users... so diferents tipe os things that o have to use. One question that I would like to ask you (sorry if it's too basic) is: 1 - Can I creat (storage) list on Azure blob like on Sharepoin and then acess them throught Powerapps delete, edit or add new data? Which is better, considering lists with around 30k lines? Many thanks from Portugal.

That button "Add Media" is extremely ugly. Is there any way to use a prettier button?

Great tutorial! One question what if I don’t have a storage connector? How can I do this without it? Is it possible to follow this tutorial without a storage connector?

Thanks Shane, is there an easy way to use the blob storage and upload larger file sizes like 200mb from PowerApps?

Hi Shane, Thanks for the awesome video. I want to know that can I store 4 input texts, create a json object of those and save that json as a file on blob storage? Please help. lets say my 4 inputs are name,age,gender and height, can you please tell me the query for file creation of this type of object.

Nice vídeo, Shane! Congrats and thanks for sharing this content! I would like to know about the security of using blob storage when we need to download the documents inside blob storage through the Power Apps: For now, it seems that it’s not secure to download or launch a file from Blob storage because for that we need a SAS token (public sharing) and we would expose this url. And if this url is shared any person, anyone can access the file, right... Is there a way to permit the access to allowed people only? ...thank you!!!

Hi Shane, great videos on Power Apps. Is it possible to show the contents of an excel file stored in a container on Blob Storage?

Is there a way to have the "add file" in a gallery? I cannot seem to get it to work.

Hi Shane, I'm trying to upload files greater than 100 MB. It doesn't work. Canvas app get stuck and have to refresh the app to use and files are not getting uploaded. Any other solution or suggestion ?

Hi Shane , how to Transfer a file from one folder to another file in azure blob storage using powerapps

Hi, this is a great tutorial. I have a question though if you are trying to load a CSV file data into a gallery and the file has a path of container_name > folder1 > folder 2 > folder 3 > filename.csv. I cannot load it based on your tutorial.

Any idea how to do something similar with FileShare?

What is the approach for automatic filename generation?

Hi, I want to upload file to Azure Data lake. Have you created any video so that I can refer.

Hello Shane, your video are awesome 🎉💐 .. I need your help my powerapps using blob storage but recently private endpoint is enabled on azure blob storage and due to this I am not able to connect powerapps with blob storage please help 🙏🙏 .. thank you 🍁 Is there any option available to setup gateway for private endpoint on powerapps

is there a file size limit for the blob?

Hi Shane, Super Top! We are using Azure SQL from PowerApps for thousands of asset data. With images my problem is that full res images are slow for showing in catalog view. So I was thinking of using C to make and store a thumbnail and a 600px image parallel in SQL for fast response use. Now seen this Blob storage my question to you is: does the collection download the image just as big as needed or does it download the full res and only show a thumbnail in the collection. If the latest is true then we need a fast respons solution. Note we need the full res image sometimes, but not for a regular quick view. How can we improve the speed in this case? …. this will be the cherry on the cake, Shane. ;-) Thanks, Gr. Lex

How does speeds compare to sharepoint?

Can we unzip files?!

Can you please help me with updatefile()

Can we upload more than 100mb ?

Now Azure Blob Storage is a Premium Connector :(