{"id":33357,"date":"2022-12-15T15:54:05","date_gmt":"2022-12-15T10:24:05","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=33357"},"modified":"2022-12-19T12:04:15","modified_gmt":"2022-12-19T06:34:15","slug":"displaying-entity-image-in-ssrs-report-using-power-automate","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2022\/12\/displaying-entity-image-in-ssrs-report-using-power-automate\/","title":{"rendered":"Displaying entity image in SSRS report using Power Automate"},"content":{"rendered":"

In Dynamics 365 CRM, while working on one of our requirements we came across a scenario where we needed to display an Account entity image on an SSRS report. But, due to SSRS limitations, the report did not allow the usage of the OOB \u201centityimage\u201d attribute in the dataset.<\/p>\n

As a workaround we\u2019ve created a Multiline text field and mapped the \u201centityimage\u201d value (i.e. base64 string value) into that, so we can use that Multiline text field attribute in our dataset in order to display the entity image on the report. Also, to store the actual Entity Image in the custom field we have used the Power Automate Flow.<\/strong><\/p>\n

In this blog, we will go through the steps that need to be performed in order to achieve the requirement as follows:<\/p>\n

1<\/strong>. Create a custom Multiline text field on the Account<\/strong> entity<\/p>\n

\"Power<\/p>\n

2<\/strong>. Navigate to Power Platform Admin Center<\/a> -> Open your solution<\/strong> -> New<\/strong> -> Automation<\/strong> -> Cloud Flow<\/strong> -> Automated<\/strong> to create a Power Automate Flow<\/p>\n

\"Power<\/p>\n

3<\/strong>. Now add the Microsoft Dataverse Trigger for when a row is added, modified, or deleted and set the change type to Modified and set the Select Columns value to \u201centityimage\u201d<\/p>\n

\"Power<\/p>\n

4<\/strong>. After that add another step (\u201cGet row by ID\u201d) in order to retrieve the account entity image and only retrieve the Entity Image field<\/p>\n

\"Power<\/p>\n

5<\/strong>. Now add the condition to check if the Default image (i.e., entity image) contains data<\/p>\n

\"Power<\/p>\n

6<\/strong>. Then under the \u201cYES\u201d condition add the action to retrieve the records and update them<\/p>\n

7<\/strong>. In the Table name section, select the Entity\/Table name on which flow needs to be run (Executed)<\/p>\n

Row Id is a unique identifier of the Entity\/Table<\/p>\n

The select columns option is for filtering columns (i.e., to retrieve specified columns)<\/p>\n

\"Power<\/p>\n

In the update step we\u2019ve set the EntityImage value to the Multiline text field (which we had created in Step 1)<\/p>\n

\"Power<\/p>\n

\"Power<\/p>\n

8<\/strong>. Under the \u201cNO\u2019\u2019 condition we\u2019ve set the Multiline text field (which we had created in the 1) to Null<\/p>\n

\"Power<\/p>\n

\"Power<\/p>\n

9<\/strong>. Now in the SSRS report we\u2019ve added our Multiline text field to our dataset fetchxml and mapped that Multiline text field value to our image<\/p>\n

\"Power<\/p>\n

\"Power<\/p>\n

As a result, we are able to see the image on the report in the following manner-<\/p>\n

\"Power<\/p>\n

Conclusion<\/strong><\/h2>\n

Thus, in this way, we can display the Entity Image for any of the entities on the SSRS report in Dynamics 365<\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In Dynamics 365 CRM, while working on one of our requirements we came across a scenario where we needed to display an Account entity image on an SSRS report. But, due to SSRS limitations, the report did not allow the usage of the OOB \u201centityimage\u201d attribute in the dataset. As a workaround we\u2019ve created a\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[38,58],"tags":[1975,1666],"class_list":["post-33357","post","type-post","status-publish","format-standard","hentry","category-microsoft-powerapps","category-ssrs-reports","tag-power-automate","tag-ssrs-reports"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33357","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=33357"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/33357\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=33357"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=33357"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=33357"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}