Getting no valid fields while using use fields for email subject

I have a simple workflow in which the email subject needs to contain the count of records,

When I try to click Use field in the email it says No valid fields, see screenshot below

attached a simple workflow, which has two text inputs, then it gets a count, wanted the count to displayed in the subject

email_subject_dynamic.yxmd

Developer Tools

Accepted answers

atcodedog05

Hi @ealunkal

You would need to bring the count at the end by adding it through append tool and send the field to subject.

Workflow:

You can also use formula tool to create a proper text subject.

Hope this helps : )

email_subject_dynamic.yxmd

All comments

Jean-Balteryx

i think you need a String type field for the subject. is your count a numeric field ? If so, a Select tool should do the trick !

BrandonB

Does the count of records exist in the table? In order to use it as the subject you have to have it in its own column. You may want to use a count records from wherever you need to count them from and then use an Append tool right after the table tool where you append the count. That way you will have the table in one column and the count of records in the second. Then you should be able to use the count of records as the subject.

atcodedog05

Hi @ealunkal

You would need to bring the count at the end by adding it through append tool and send the field to subject.

Workflow:

You can also use formula tool to create a proper text subject.

Hope this helps : )

email_subject_dynamic.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703