In general I will store my files in SharePoint. As SharePoint’s document management capabilities of SharePoint match what I need. Document Libraries offer the option to store files and manage my files better than most other document stores. I do however sometimes need to store files in a different location, away for SharePoint. Today I had a look at storing documents in the Common Data Service using Microsoft Flow.
I started by taking a file stored in SharePoint.
Before I go any further it is important to understand what the Get file content action returns.
The File Content returned contains two pieces of data. The type of the content and the actual file content.
Store your files
We need these to create the file in a Note in the Common Data Service.
Now when we check in Dynamics the data is there.
Or when I have a further look at the note that I created I can find my file back:
Just to make sure that I can get my file back out of the Common Data Service I’m going for the reverse process. I am getting the note back using the Get record action and then I create the file in SharePoint with a new name.
When I now look in SharePoint my new file can be opened.