Not possibe to send Dynamic Email to email in parent table

[Joëlle]

Hey there

I'm building an approval app with parent/child relationships and wanted a bot to send an inforation email to an email adress in the parent table with a parent table view.

Now I get the following error: Error encountered in step with name [Mail to Smartsheet Owner]:
The row used to populate the embedded app view (dynamic email) was either inaccessible or not found.

Support said, that I have to use another key column, bot if I do that, my relationships aren't working anymore.

Does someone know a work around or is the only solution not to use Dynamic Emails?

[AleksiAlkio]

What view type are you trying to send? From which table you are trying to trigger the Bot?

[Joëlle]

I'm sending the Detail view from the parent table. bot triggers also from the parent table

[AleksiAlkio]

Now I'm confused. If you are trying to trigger a Bot from the parent record, and it should send the parent's detail view from that record, why would you need to change the key column? Does your app structure contain something else that is related to this challenge?

[Joëlle]

Support told me, that the bot can't send the mail, because of my key column. If I change it, the bot works, so I guess the problem is that I have a parent/child relationship in that table. 

[AleksiAlkio]

Would you please take a printscreen from your parent table (from the editor)

[Joëlle]

there you go

[AleksiAlkio]

Still I don't get it why you would need to change the key column if all rows have their unique value on it. Something is now missing.. 

[Joëlle]

Sorry I know it's confusing.
Main problem is, that the automation bot doesn't send out the email. This is the error I get.

maybe you have an idea what could be the problem?

[AleksiAlkio]

That doesn't give any hint either. Please take a printscreen from your Bot and its setup.

[Joëlle]

Thanks so much for trying to help me!

[AleksiAlkio]

You said in the beginning "bot to send an inforation email to an email adress in the parent table with a parent table view." What do you mean by that?

[Joëlle]

So i set up a bot to send an email with embedded app view everytime a new entry gets created to an e-mailadress in the parent table. But the email doesn't get sent and when I monitor the automations I find the error:  Error encountered in step with name [Mail to Smartsheet Owner]:
The row used to populate the embedded app view (dynamic email) was either inaccessible or not found.

[Joëlle]

Sorry last one wasn't correct