cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Roselin
Helper I
Helper I

Data Table to Email using Power Automate flow in power Apps

Hi,

 

Can we send a Data Table data through Email using Power Automate flow.

Please guide me on this.

 

In Button-Onselect we can use the mail connector & achive this task. But I want this through power automate flow. The flow should grab the data table values and send it through a mail to users.

 

 

Regards,

Roselin

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @Roselin :

If you want to pass a table to Flow, then you need to convert it to JSON text first, I've made a test for your reference:

1\I assume there is a table:

ClearCollect(
   TheTable,
   {Column1:1,Column2:"A"},
   {Column1:1,Column2:"B"}
)

2\My flow(Bof1210):

vbofengmsft_0-1639117988946.png

3\Send an email:

Bof1210.Run(JSON(TheTable))

The Result:

vbofengmsft_1-1639118053714.png

 

Best Regards,

Bof

 

View solution in original post

2 REPLIES 2
CNT
Super User
Super User

@Roselin You can do it with a Flow but you don't have to. You can use the Outlook Connector and use the SendEmailV2 function to do it directly from Power Apps. Much simpler!

v-bofeng-msft
Community Support
Community Support

Hi @Roselin :

If you want to pass a table to Flow, then you need to convert it to JSON text first, I've made a test for your reference:

1\I assume there is a table:

ClearCollect(
   TheTable,
   {Column1:1,Column2:"A"},
   {Column1:1,Column2:"B"}
)

2\My flow(Bof1210):

vbofengmsft_0-1639117988946.png

3\Send an email:

Bof1210.Run(JSON(TheTable))

The Result:

vbofengmsft_1-1639118053714.png

 

Best Regards,

Bof

 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (4,755)