User Review( votes)
Microsoft Dynamics 365 professionals discuss Power Automate flows for moving attachments out of CDS to SharePoint, making sense of metadata, boosting social media analytics, conducting parallel approvals and assessing flow run histories.
Want to see your flow featured in a future edition of this series? Contact me with your example.
Moving attachments from CDS to SharePoint
Linn Zaw Win, writing on Linn’s Power Platform Notebook shared how to move an attachment from the File Field of CDS to SharePoint using Power Automate. Microsoft first added File and Image data types to CDS in 2019, which was initially only available for canvas apps. By storing files at the field level, the system is better able to parse different file types. Although useful for most situations, there are still some occasions where users may need to store files in SharePoint rather than the File Field, such as a misalignment of capacity.
For these scenarios, users can put Power Automate to the test. In the case outlined by Win, after triggering when a contact is updated, actions should get the contact record for the item, pull file contents, initialize variables for the SharePoint site, get the document location of the contact record, create a file and populate the new document file URL.
Using the file data type field gives you more control on file validation in your solution and by using the Common Data Service (current environment) connector and SharePoint connector in Power Automate, the file uploaded to the ‘file’ field of Common Data Service can be moved to SharePoint document library and removed from CDS.
Reading CDS metadata attributes
FREE Membership Required to View Full Content:
Learn more about us here