Connect Canvas app to Azure Storage account via Shared access signature (SAS)

Like (0) Share

Report

Posted on 6 May 2020 14:09:01 by thiago

Hi all,

Have you guys tried to connect Canvas app to Azure Storage account via Shared access signature (SAS)?

I was able to connect to the conventional model, via static Connector, but I have a scenario where this process needs to be validated via shared access signature and apparently nobody has done this yet, I'm suspecting this is not possible in the current version.

thank you in advance 🙂

All responses (3)

Answers (1)

Verified answer

v-siky-msft on 14 May 2020 at 02:11:39

Like (0)

Report
Re: Connect Canvas app to Azure Storage account via Shared access signature (SAS)

Hi @Thiago_L_Lima ,

Although the SAS token is not integrated to AzureBlobStorage.CreateFile function, I think you can add If function to check if the SAS token user entered is valid, then create the files.

For Example:

1. add a TextInput box for users to enter the SAS key

2. add a If function before AzureBlobStorage.CreateFile function.

If(TextInput1.Text=<Your SAS Key>, AzureBlobStorage.CreateFile("myfiles",TextInput1.Text,UploadedImage1.Image), Notify("Invalid SAS Token"))

Hope this helps.

Sik
thiago 7 on 13 May 2020 at 08:19:55

Like (0)

Report
Re: Connect Canvas app to Azure Storage account via Shared access signature (SAS)

Hi Sik,

I had a look at that article (which is really good), but what I am trying to do is actually create a file using SAS token.
So considering the explanation below, is there a way to use "AzureBlobStorage.CreateFile("myfiles",TextInput1.Text,UploadedImage1.Image)" and use the SAS token? this might fix my problem, I wanna prevent users to create files if they are not using a valid SAS token

Upload Files to Blob Storage
Your app can now display files from blob storage into a gallery, now let’s add a way for users to upload new files to blob storage.
Add an upload control to send a file to your blob storage by going to Insert > Media > Add Picture
Add a Textbox to your canvas app so you can name the file by going to Insert > Text > Text Input
Add a button to your app for the user to click on it to upload the file by going to Insert > Button
For the OnSelect property of the button add : AzureBlobStorage.CreateFile("myfiles",TextInput1.Text,UploadedImage1.Image)
v-siky-msft on 07 May 2020 at 05:37:13

Like (1)

Report
Re: Connect Canvas app to Azure Storage account via Shared access signature (SAS)

Hi @Thiago_L_Lima ,

Shared access signature is supported in PowerApps for Azure blob storage.

If you have set up the Shared access signature, this will assign a key to all the files in your container and will not allow them to be shown unless a special key is appended to the URL.

You need to copy the Query string to use it in your app. In your app append the query string to the end of any URL in a control where you are viewing an item.

For example, in the gallery that is showing images back to your users, you will need to change the image property of that image:

From: “https://YourStorageAccountName.blob.core.windows.net" & ThisItem.Path

To: “https://YourStorageAccountName.blob.core.windows.net" & ThisItem.Path & “?st=YourKey”

For more information, please read this blog: Upload files from PowerApps using the Azure Blob Storage connector

Hope this helps.

Sik