Hello everyone and welcome to my blog. In today’s blog I will discuss on how we can retrieve the contents of DataVerse image column and send it as an attachment in an email.
We are going to use Power Automate for this. Power Automate DataVerse connector has actions to upload and download image and file data types. So let’s get started.
Below is an account record with an image.
The requirement is to send the record information with the image as an attachment in an email.
For this requirement, the flow should be available to run from an account record. So I have the used the ‘When a record is selected‘ action from the Legacy Dataverse connector.
The next step is to download the image content. For this I use the ‘Download file or image‘ action from the DataVerse connector.
The connector need the following inputs
- The name of the table – in our case it is account.
- Row Id which is basically the record id. I can get it from the previous step
- Image column name. In this case I want to retrieve the default entity image column. If you want to download the content of other image or field columns, select them accordingly in the dropdown.
The next step is to send the email. For this I use the ‘Send an email’ action and move to the attachments section. You need to specify the file name. For the Attachment content I used the ‘File or image content‘ output from the previous action.
All set and done. I execute the flow from the account record.
And below is the screenshot of the email received. As you can see, the record image is in the email.
Hope you liked this post. If this post has helped, you can buy me a coffee.
For similar topics on Microsoft.NET and Power Platform, subscribe to my blog using the Subscribe option on right pane.
Debajit Dutta
Business Solutions MVP