Get a screenshot of a cell range from an excel report and add that to the email body

Asingh01

I have a use case where I am downloading and sending an excel report automatically to some users in an email. Recipients want the email body to contain a particular table of the report. This table contains sort of summary and the items to highlight. I want to be able to automatically copy/get a screenshot of that table and include in the email body. Is there a way to do it in decisions? What steps can I use?

Asingh01

Can anyone help with this query? Is there a work around if not a direct step?

Tawanda_Decisions

Hi,

I've been looking into this and unfortunately there isn't a direct step that does this. We have an example project that demonstrates how an HTML table can be merged and sent in the body of an email. You can download the lab and import it into Decisions. As this does not perform your request exactly it will need to be reconfigured to work within your flow. You might need to start with importing the Excel file if that data is not already available as a part of your existing flow. You may also need a For Each Excel Or CSV Row Step to manipulate the Excel data into DynamicDataRows and from there with some additional configurations you can use the flow in the example lab download to get the excel data in the email body as an HTML table. 

Example lab project: https://documentation.decisions.com/projects/docs/merge-html-tables

Import Excel step: https://documentation.decisions.com/step-library/docs/import-excel-or-csv-step

For Each Excel: https://documentation.decisions.com/step-library/docs/for-each-excel-csv-row-step 

Hope this helps!

Tawanda | Decisions Support

Asingh01

Thank you Tawanda. This is helpful. I will take a look and update on this thread if I am able to find a different approach.