Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Unanswered

Dataverse Integration with Azure Blob Storage

(0) ShareShare
ReportReport
Posted on by 873

Hello everyone,
I have a custom table that is used to store attachments that is related to an account.


The requirement is for any file that will be uploaded to this table, it should be stored in Azure Blob Storage and it should not count against dataverse file capacity storage or even setting up a SharePoint integration.

The process should be the below:

In the custom table, I have a custom field of type (File Column) and a document URL field. When the is record is created, a Power Automate workflow should be triggered in the background and do the below:

-> get the file content -> create the file in azure blob -> update the record with the path link of the file in the form -> delete the file that exists in dataverse (To avoid consuming file capacity storage).

After the workflow process is finished and the user tries to access the record in edit mode, the file column will disappear (we can customize it through JS) and he will only see the document URL of this file and access it through the browser to check its content.

Could you please advise if the above is a good solution to proceed with or is there any other better approach? I am open to any suggestions.

Any help is highly appreciated.

Best regards,
EBMRay

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans