Upload Email Attachments To share point and Delete from Dynamics CRM Through Power Automate Flow - Power Automate

-

 Upload Email Attachments To share point and Delete from dynamics CRM Through Power Automate













Set Flow Triger Point and store share point site Url in variable


List Cases having attachments in Emails

<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
  <entity name='incident'>
    <attribute name='title' />
    <attribute name='ticketnumber' />
    <attribute name='createdon' />
    <attribute name='incidentid' />
    <attribute name='caseorigincode' />
    <order attribute='title' descending='false' />
    <link-entity name='activitypointer' from='regardingobjectid' to='incidentid' link-type='inner' alias='aa'>
      <link-entity name='activitymimeattachment' from='objectid' to='activityid' link-type='inner' alias='ab' />
    </link-entity>
  </entity>
</fetch>


























List Activities Related to case



<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>
  <entity name='activitypointer'>
    <attribute name='activitytypecode' />
    <attribute name='subject' />
    <attribute name='statecode' />
    <attribute name='prioritycode' />
    <attribute name='modifiedon' />
    <attribute name='activityid' />
    <attribute name='instancetypecode' />
    <attribute name='community' />
    <order attribute='modifiedon' descending='false' />
    <link-entity name='incident' from='incidentid' to='regardingobjectid' link-type='inner' alias='ad'>
      <filter type='and'>
        <condition attribute='incidentid' operator='eq' value='Here pass Guid of the record'/>
      </filter>
    </link-entity>
  </entity>
</fetch>


























List Attachment Related to Activities


<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
  <entity name='activitymimeattachment'>    
    <order attribute='modifiedon' descending='false' />    
      <link-entity name='activitypointer' from='activityid' to='objectid' link-type='inner' alias='af'>
        <filter type='and'>
          <condition attribute='activityid' operator='eq' value='Here pass Guid od the record'/>
        </filter>
      </link-entity>
    </link-entity>
  </entity>
</fetch>


















Site Address: pass share point url
Folder Path : give folder path (i have created separate blog for this)
File Name : provide file name from dynamically from attachment
File Content : provide Body Content from attachment and covert it int base 64 to binary (base64ToBinary(items('Apply_to_each_4')?['body']))

Upload attachment to share point in respective folder




























Delete attachments form dynamics







Note : I have used fetch Xml But you can use other tool for retrieve and create Power Automate Query. 























































Over All Flow Structure






Comments

Post a Comment

Popular posts from this blog

Create Folder On Share Point by using Power Automate In Dynamics CRM

-
Image
  1-Flow trigger When contact is created 2-Declare two variables one for storing SharePoint site URL and the other one is for the Sotring Entity name. 3-Use SharePoint Connector and take create a new folder action. In the Site address and Library pass the variables and in the folder, the path gives the folder name, whatever you give the path will create a folder accordingly. (here I have given FULL NAME_GUID ) In replace expression I have replaced Guid '-' with ' '.( replace(toUpper(triggerOutputs()?[ 'body/contactid' ]), '-' , '' ) ) 4-After Creating the folder we need to retrieve the parent site document location for the contact for creating a new document location. 5-creating new document location.in this, we provide the site name whatever you want and In the  Relative URL pass the folder path the same as we have given for folder creation action in step no 3. In regarding(contacts) pass contact GUID and  Parent Site or Location (Document Locat...
Read more

Duplicate Detection Plugin code for Microsoft dynamics CRM

-
 using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.Xrm.Sdk; using System.ServiceModel; using Microsoft.Xrm.Sdk.Query; namespace MyPlugins {     public class DuplicateCheck : IPlugin     {         public void Execute(IServiceProvider serviceProvider)         {             // Extract the tracing service for use in debugging sandboxed plug-ins.               // If you are not registering the plug-in in the sandbox, then you do               // not have to add any tracing service related code.               ITracingService tracingService =                 (ITracingService)serviceProvider.GetService(typeof(ITracingService));           ...
Read more