When you start a new project you often need to think about file storage. A good option is the SharePoint integration Dataverse gives us. However, there might be occasions in which you want to use the file storage Dataverse gives us out of the box.
Today, I want to show you two possibilities.
Option 1 - Dataverse attachments
First, when we create or edit a table we can check the checkbox that allows us to enable attachments. Now we can use the attachment column in our apps and flows.
This also gives us the possibility to upload several files. We only have one issue. The storage capacity of files in this case is limited to 5 mb. However, we can change this!
Here is how:
Go to Advanced settings.
Go to Administration.
Go to System Settings.
Click on Email and scroll down until you can see "Set file size limit for attachments". Here you can increase the limit up to 128 mb or 131.072 kb.
Now you can upload several files in the attachment column of the Dataverse table which can have a size up to 128 mb.
Option 2 - Dataverse file columns
The possibility to upload several files in one column is a big plus point for the first option and a downside for the next option. However, you can still zip your files and upload multiple files in this way as well.
Here's how:
Create a new column and select File as Data type.
Before you click on Save click on Advanced options. Here you can select the maximum file size limit. It will go up to 131.072. Do you remember this number?
You can create more columns of the file data type which gives you the possibility to upload several files in several columns if your use case has this necessity.
To sum it up
We have seen that we can use two ways to store our files in Dataverse. First, the attachment column after it is enabled and the file size increased with the big benefit to store several files in one column. Second, the file data type columns to store on file per column.
Of course, we could have used SharePoint or other file storage possibilities in this case as well. I just wanted to demonstrate the possibilities of Dataverse. It always depends on the specific business case.
Comments