Table in email

sfd_pl
Participant II

Hi all,

Seek guidance to create simple table in email body. All data can be found on single table - PoD_Data

App sheet email table.pdf (84.1 KB)

Thank you in advance

Solved Solved
0 4 877
1 ACCEPTED SOLUTION

Hi Aurelien and Rafael_ANEIC-PY,

Thank you for guidance.

Solution: <<Start: PoD_Data[Ref ID]>><<[TimeStamp]>>

Thank you

View solution in original post

4 REPLIES 4

Hello, @sfd_pl, try using this as your expression under TimeStamp:

<<Start: [Ref ID]>><<[TimeStamp]>>

Hi Rafael_ANEIC-PY,

2 error become 1!

Error: โ€˜Handle new Proof of Delivery recordโ€™ task โ€˜Send an emailโ€™ Body template. Start expression โ€˜[Ref ID]โ€™ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โ€˜Keyโ€™ column of the referenced table.

Column [Ref ID] type is Number not Ref.

Hi @sfd_pl

The idea in the @Rafael_ANEIC-PY 's suggestion is to loop on the key_column of the table.
In the screenshot you provided, this is the key_column.
3X_3_8_38e31c5df8d0977ea0e9edbf41f649918314ee5a.png

If you changed it, you may want to replace [Ref ID] with the new one.

For reference, if you didnโ€™t read it yet:

Hi Aurelien and Rafael_ANEIC-PY,

Thank you for guidance.

Solution: <<Start: PoD_Data[Ref ID]>><<[TimeStamp]>>

Thank you

Top Labels in this Space