How to check whether the notes attachment are stored in dataverse or not?

[Amruthavarshini]

Hello everyone,

I am using azure blob storage to store all the note attachment in dynamics 365.

I configured azure blob for power apps portal as mentioned in the below link

https://docs.microsoft.com/en-us/powerapps/maker/portals/enable-azure-storage

I can see that all the note attachments are storing in azure blob. But i want to make sure that the files are not storing in both Dataverse and Azure blob.

So how can I check whether the files stored in dataverse or not?

Thank you... 

[cchannon]

Query your annotation table and (generally speaking) if the rows include a huge encoded string, they include an attachment.

[Fubar]

Don't know if this is still the case or not (could possibly have been a bug), you used to be able to query the notes file size attribute and it would be Zero if the file had been moved to blob (but in the user interface, views etc you would see the file size displayed).

Also, be aware that Notes attachments now go into file storage also - behind the scenes from Microsoft.

[EricRegnier · Accepted solution]

Hi @Amruthavarshini,

You also can check by the storage used in your environment. Go to Admin center (https://admin.powerplatform.microsoft.com) --> Resources --> Capactity and check the file storage. More info: https://docs.microsoft.com/power-platform/guidance/adoption/resource-usage#monitoring-storage-capaci... 

Note: note (annotation) records will still be created for Blob attachments to map Blob files to your records.

Hope this helps!

[Amruthavarshini]

@EricRegnier

Thank you for the information, its very helpful.