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

Top Interview Questions and Answers for Dynamics 365 Development and Customization

-
  Top Interview Questions and Answers for Dynamics 365 Development and Customization Q: Can you explain the difference between Dynamics 365 CE (Customer Engagement) and Dynamics 365 Finance and Operations? A: Certainly! Dynamics 365 CE primarily concentrates on customer relationship management, encompassing sales, customer service, and marketing functions. On the flip side, Dynamics 365 Finance and Operations tackle enterprise resource planning, focusing on areas like financial management, supply chain management, and manufacturing. While CE revolves around nurturing customer interactions, Finance and Operations optimize an organization's internal processes and resource utilization. Q: What are plugins and how are they used in Dynamics 365? A: Plugins are versatile chunks of custom code that extend the capabilities of Dynamics 365. They spring into action when certain events occur in the system, and their role is to manipulate data and carry out custom business logic. Essentially,
Read more

Create folder on share point Microsoft dynamics CRM with document Location By Power Automate

-
Image
   1-Set Trigger Point According To Requirement         2-Set Your Share Point Site In Variable       3-Use Share Point Connector & take action CREATE FILE . In this Block Assign share point then select folder path ,  declare file format and file name  Both are temporary. (In this block , we can set folder name according to requirement)         4-Delete Temp.txt File From Previous Stage In this block we are deleting temp file which is created earlier After deleting file A folder With Ticket Number Will be Created on share point.  5-List Document Location 6-Create New Location In Regarding it will be (regarding (incident)) and in Relative Url it should be same as defined in step 3 after main path. We can Use This Flow For Creating Folder For Any Entity In Dynamics and we can set Folder name what ever we want. Over All Flow Structure                 Requirement: Share point Integration with individual folder structure format not hierarchal structure from Accoun t.  
Read more