Can we able to display list of records in one dynamic email.. just like a form. In your example only one record is showing. Secondly, is there any possibility to trigger the email from Google sheets?
Dependent drop downs with data from a reference do work in Dynamic Emails. For example, if you have 2 tables, Dept and Emp, and you set up an Automation to send an email when a new 'Emp' record is added, a Dynamic Email can be set up to send the Emp_Detail System View in the email. You'll need enable the Quick Edit option for the Dept column reference to the Dept table though. Note: Ref column type support was added last week but we still don't support EnumList / Enum with base type Ref. Hope this helps!