I want to send an automated e-mail with data from an excel sheet that is linked to a form.
Everytime someone fills in the form, an e-mail is to be sent. This works perfectly with most data from the excel.
I do add a number of columns to the excel with formulas to make it easier to lay-out the e-mail. The power automate editor creates way to many 'spaces' when dynamic content returns nothing because the correspongin answer is 'blank'..
I have quite a complex form.
Therefor I add columns to my excel in which I combine text from many cells into on 1 single cell with the Concatenate command.
Power automate allows me to add that dynamic content to my e-mail, but it is always blank in the e-mail.
When I open the excel-file on my computer, the concatenate command runs and when I run Power Automate with the same trigger again after that, everything works fine.
Why won't my excel calculate those columns everytime a row is added. Does it not update alle colums in every row automatically in the background.
Any workaround?
Share
Report
All responses (
Answers (
462
