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
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,926)