knowledgecenter-breadcrum

Knowledge Center

15 Oct, 2020

File Data Type of CDS with Power Automate

Posted on 15 Oct, 2020 by Admin, Posted in Dynamics 365 Power Platform Dynamics-365 Sales

File Data Type of CDS with Power Automate Blogs

File Data Type of CDS with Power Automate

Introduction

In this blog, we are going to see the details about the new addon added by the Microsoft in CDS.

During fields creation on CDS entities. We saw the below types:

So, in this blog we have explored the use of file data type field using power automate.

Before we see the example of file type field. Let see the few details about file and Image data type.

File and Image Type

  1. File: This type of field help user to upload the attachment of any type on a record.
  2. Image: This type of field help user to upload only image type of attachment.

After adding both fields on form, below UI will appears for above fields types.

Note: In both fields type user can upload only one attachment.

Example

In the below example we have uploaded the attachment using file type field into the SharePoint using power automate.

Steps Details

  1. Step 1: In this step we have added trigger point as update of account entity and proceed only when the custom File type field value gets updates.
  2. Step 2: In this step we have used the below CDS action to get the field value of Custom File type field.

The “Get File or Image content” action of CDS, help us to get the content of respective types of fields.

  1. Step 3: In this step we have created a folder under SharePoint site for account entity as shown below:

  1. Step 4: In the final step, we used the data retrieve in Step 2 to create record in SharePoint.

After uploading the attachment corresponding record gets created on SharePoint as shown below:

CRM

SharePoint:

Note: Just for demonstration purpose we have not added any kind validation in power automate

Comment

This is a Required Field

Loading

Recent Updates

Blogs
07 Sep, 2023

Optimizing Storage with SubscriptionTrackingDeletedObject Cleanup

What is SubscriptionTrackingDeletedObject? The "SubscriptionTrackingDeletedObject" table is linked to the "DeletionService," which handles two types of cleanup: organization-wide and record-specific.…

READ MORE
Blogs
05 Sep, 2023

How to create real-time customer journeys in Dynamics 365 Marketing

Introduction: This blog will show how to create real-time customer journeys in Dynamics 365 Marketing. Customer journeys can be either…

READ MORE
Blogs
30 Aug, 2023

D365 CUSTOMER SERVICE: CUSTOMER 360 COMPONENT

Introduction: In Dynamics 365 (D365) Customer Service, the 'Customer 360' Component provides a comprehensive view of information and enables users…

READ MORE