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

Send a collection to email

Hello.

 

Help me, pls. I have a collection with 5 rows and 3 columns as follow:

MyCollection{Col1; Col2; Col3}

 

I need to read row by row and concatenate into a E-mail Body splitted by ";" as follow:

 

Row(1) Col1.Result; Col2.Result; Col3.Result;

Row(2) Col1.Result; Col2.Result; Col3.Result;

Row(3) Col1.Result; Col2.Result; Col3.Result;

Row(4) Col1.Result; Col2.Result; Col3.Result;

Row(5) Col1.Result; Col2.Result; Col3.Result

 

Does anyone know how to do it?

 

thanks.

Paulo.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Apps
Power Apps

Re: Send a collection to email

You can use the Concat function to convert your collection into a string that can be sent via e-mail, something along the lines of the expression below:

Concat(
    MyCollection,
    Col1 & "; " & Col2 & "; " & Col3,
    Char(10))

Where Char(10) is the character that represents a new line (enter).

View solution in original post

1 REPLY 1
Highlighted
Power Apps
Power Apps

Re: Send a collection to email

You can use the Concat function to convert your collection into a string that can be sent via e-mail, something along the lines of the expression below:

Concat(
    MyCollection,
    Col1 & "; " & Col2 & "; " & Col3,
    Char(10))

Where Char(10) is the character that represents a new line (enter).

View solution in original post

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Robotic Process Automation

Let's talk about the solution provided by Microsoft for Robotic Process Automation (RPA)

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

Top Solution Authors
Top Kudoed Authors
Users online (7,458)