Unanswered

DataTable Table send via email with all dynamic table content inside flow

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello Everybody,

I have ready data table with all dynamic content inside that table needs to be send as a table via email and send response to power apps as variable via responder flow.

Is anyone know What is the syntax to send table with column header and dynamic data inside?

This syntax send only headers with no data : %DataTable.ColumnHeadersRow.ColumnNames%

Categories:

Power Automate Desktop

I have the same question (0)

All responses (4)

Answers (0)

Sort by

momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hmm unless I am missing something you can't send variables via email as this is a text-based protocol.
What you can do is create a PA flow that will be triggered via rest where you pass the variable content, then parse it in PA to desired state.
Or if the table needs to be passed at the end of desktop flow just use the output variable and parse the table in PA.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Momlo,

There is no problem send this via email and is sends, the problem is sends only row headers without collected content data or collected data with rows in single line, need to send all the table.
Sorry i probably was not so clear, cannot send %DataTable% variable from PAD to powerapps as response.

Was this reply helpful? Yes No
momlo 1,527 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

So you want to send variable as a text? I thought yo uwant to send "dynamic" variable tht you can click and expand etc like inside the PAD.

To send text in email just use :%DataTable% direclty or first parse to text with for each or similar
To return the DataTable to Power autoamte use output variabe with DataTable type

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I'm assuming in this way is sends table in one single line only.

Was this reply helpful? Yes No