We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Getting no valid fields while using use fields for email subject

ealunkal
5 - Atom

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 subjectdynamic_email_sub_field.jpg

3 REPLIES 3
Jean-Balteryx
16 - Nebula
16 - Nebula

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
Alteryx
Alteryx

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
22 - Nova
22 - Nova

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:

atcodedog05_1-1626884915342.png

 

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

 

Hope this helps : )

 

Labels
Top Solution Authors