Why can't I use the result of a query in a following step?

[ben]

I have the scenario where I have the details of the organisation in a database table. I want to use the values to populate the sender fields of an email as illustrated.

However, the values don’t seem to be transferred, i.e. the fields remain empty.

{"status":"500","message":"mail.send: fromEmail is required.","stack":"Error: mail.send: fromEmail is required.\n    at App.parseRequired (/var/www/vhosts/bunchokids.org/app/lib/core/app.js:473:19)\n    at App.send (/var/www/vhosts/bunchokids.org/app/lib/modules/mail.js:18:30)\n    at App._exec (/var/www/vhosts/bunchokids.org/app/lib/core/app.js:435:57)\n    at App._exec (/var/www/vhosts/bunchokids.org/app/lib/core/app.js:406:28)\n    at processTicksAndRejections (internal/process/task_queues.js:89:5)\n    at async App.exec (/var/www/vhosts/bunchokids.org/app/lib/core/app.js:375:9)\n    at async App.define (/var/www/vhosts/bunchokids.org/app/lib/core/app.js:365:9)"}

Please help me to understand.

[mebeingken]

Assuming the column is Eml, shouldn’t it be

queryOrganisation.Eml

[ben]

Hi Ken, thanks for the reply. I wish it was that simple. This is the table:

[ben]

Thank you Ken, you have made me think about what I have done, And stupid me, I renamed the query without applying the rename to the fields.

All solved.