Email body column error

Hi,

I'm facing email body types error see below image. Table name and column name is correct but showing error . How can I fix this issue. 

Screenshot_20240216-215332.png

Solved Solved
0 26 729
2 ACCEPTED SOLUTIONS

Ok. In your email task under the table set it back to the table you originally had this set to "Email Report Process (slice)". If you get the error again that the event and process are not compatible then I suggest recreate the bot from scratch but do not yet set any variables in your email body. Something important to understand though, a scheduled event without the "ForEachRowInTable" does not pass any data to your process. Therefore, even if you choose a table in your email task it will not give you access to any of the columns in that table when using <<[Column]>> in your email body. This is a limitation within Appsheet associated with the scheduled event. Then if you can, in as much detail as possible explain what needs to be contained in your email body. Keep in mind that likely we will need to use FILTER()/SELECT() to possibly filter your data first (unless it already is filtered in the slice) and then you will still probably need to use ANY()/SUM() to summarize the data, which is what I think you are trying to accomplish.

View solution in original post

Ok but I'm not using filter slice rows data. Whithout expression slice I'm using. 

View solution in original post

26 REPLIES 26
Top Labels in this Space