Hi!
Having an issue with send email returning blanks values. This happens in all my flows, can anyone help with this ?
Basically I have a form which my flow add the responses to excel, excel table already has formulas in it but Send email is not picking these up.
Accepted Solutions
Hi @TerryM ,
It can be found that Total field is not included in the Output of 'Add a Row into a table' action in Flow Run Result since Total field is the aggregate field.
Please try to add a 'Get a row' step under that to retrieve all data of the new row which includes the Total field, and re-reference these Dynamics Content from 'Get a row' Step in Email body.
Hope this helps
Sik
Hi @TerryM ,
It can be found that Total field is not included in the Output of 'Add a Row into a table' action in Flow Run Result since Total field is the aggregate field.
Please try to add a 'Get a row' step under that to retrieve all data of the new row which includes the Total field, and re-reference these Dynamics Content from 'Get a row' Step in Email body.
Hope this helps
Sik
Helpful resources
Global Power Platform Bootcamp
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Power Platform Community Conference On Demand
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
Power Automate Community Blog
Check out the community blog page where you can find valuable learning material from community and product team members!
