cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Send a email with a excel table as .csv

Hey Guys,

 

here is what I want to do.

 

If the User click a button I want to send a excel Table (allready connected to the app) as a .csv via email.

I tried it in FLOW but I cant figure out.

 

maybe you can help me

thanks and best regards

1 REPLY 1
Highlighted
Community Support
Community Support

Hi @DanNik,

 

Well, currently I don't think this is available in an easy way.

What I could think out the way that should work is that we take use of concat function (with forall function) to make all the data from the Excel table into one string, then use it with the Office365.sendEmail function, this might work.

Mostly this should be restricted by the table column value, which we need make it to obey the CSV format.

Formula reference for PowerApps

For Microsoft Flow, we could take use of the Excel get rows action, then use the value a the Email body, this woud allow Microsoft Flow to send the Excel table content in a CSV like format.

But currenlty I can't find a way to trigger this within PowerApps, as thetable name from the Excel Get Rows action is based on the file name selected.

 

In addition, please consider submit this as an idea, to allow the Office365user.SendEmail function to be available to accept table value as the Email body field.

 

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (9,751)