Skip to main content

Posts

Showing posts with the label Common Data Service

Working with email attachments in Power Automate

CDS connector There are many blogs explaining how to fetch email attachments from CRM and uploading them to Sharepoint using the old Dynamics 365 connector. But since this connector has been announced as deprecated in April 2019, I tried to achieve the same using the Common Data Service connector. My use case is to upload e-mail attachments to sharepoint, in case an e-mail contains attachments and it is linked to an opportunity. So first we define the following trigger: Then we add a condition to check, weither the e-mail is linked to an opportunity: As a next step we query all attachments related to this e-mail, but wait there are two entities called "attachment" offered: So let's try the first one: And what we get back is some metadata about the attachment, but not the filename and the body of the attachment, we are looking for: But at least we are a step closer to our attachments. Lets try the second "attachment...

Working with Optionset lables in Power Automate

Connector Types Power Automate currently offers 3 different connectors, to connect Power Automate with your Dynamics 365 instance: Dynamics 365 Common Data Service Common Data Service (current environment) Today we will look on ways how to retrieve option set labels via the different connectors, for our sample accounts: Dynamics 365 This connector should not be used any more , since in April 2019 it has been announced as being deprecated. https://flow.microsoft.com/en-us/blog/nine-new-connectors-in-april-and-improved-visibility-into-trigger-failures/ With the Dynamics 365 connector it was quite easy to work with optionsets, since it offered both the optionset value (int) and the optionset label (name) in the dynamic content: And here we go, these are our results: Common Data Service Since the Dynamics 365 connector has been deprecated, this is the connector you should use. If you perform a "Get record" or "List records...