cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Teresa24486
Post Partisan
Post Partisan

csv file to have a default template while sending as an attachment on the email

Hi,

I have an .csv template(with logo, some text) where it should go to the departmental users along with the data from the Select(HTML) controls. How can it be done?

1 REPLY 1
poweractivate
Community Champion
Community Champion

@Teresa24486  A "CSV" (comma-separated-values) file is technically just a text file with cells separated by a comma and rows separated by a newline character. It is technically impossible to have a logo inside a CSV table cell unless that image was just a base64 encoded text, or perhaps a text URL to an image hosted online, then it might be possible in that case. 

 

To answer your question, it is possible to do this in Power Automate, you can use split function inside an Action to split each row by a newline character, Apply to Each to iterate over it, then another split from inside another Action inside the Apply to Each, then an inner Apply to Each to iterate over each cell. Content can be extracted from each cell, and possibly placed into Variables Initialized at top of Flow, even something like a base64 encoded text can be converted to an image again in the Flow and used in Send an Email Action, etc. 

 

As for CSV Email Template, usually CSV are for importing datasets into Outlook.

I am not sure which functionality you are referring to, but let's suppose for example it might be a functionality only possible in Outlook Desktop Client.

If that is the case, you may want to look at Power Automate Desktop rather than trying it with a Cloud Flow. 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,209)