Data getting Truncated at Text input tool

@sanketkatoch05 - I think I have it sorted now.

Your List Box tool should be configured as follows:

This will create a concatenated list of your emails separated by a semicolon.

Your Update Value tool should be configured to replace the specific string like this:

That will feed into the text input as you had it previously setup.

Then add in a Text to Columns tool to split the data to rows and feed it into your email tool.

Attached is a mockup where I connected it to a browse tool to see the output.

Results:

Let me know if that works for you.

Cheers!

Phil

Save From Truncating.yxzp

All comments

It could have something to do with the type of string field you're using. I'd recommend adding a Select Tool to the app and forcing it to a V_String set to a 10,000 char limit.

Hi @Maskell_Rascal,

Can you show me an example, please? Because, I tried adding a Select tool after the Text input tool but it did not work, only the truncated values are getting passed to the field even after changing the size.

atcodedog05

Guessing you are using an email tool as per my experience email tool recipient list has a size limit hence you won't be able to send emails to 20 IDs at a time.

We had faced this issue on a similar usecase 😅

Hope this helps : )

Any way you could provide a sample workflow for us to trouble shoot? If the issue is truly with the email tool, then the solution there would be different then if the problem is with the text input itself.

For example, you can email a near unlimited amount of people using the email tool, but its how you have your data configured that matters. Rather than sending one email to many recipients, you can set it up so the email tool will send an email for each record input. You could achieve this by adding a Text to Columns tool on the recipient list field, configured with a semi-colon delimiter, and splitting to rows (then updating the email tool to use the new field).

atcodedog05

Adding to the above points best way to troubleshoot will be to use an output tool at the same place where the email tool is and write the recipients list to a file.

If you were able to conclude that the issue is with the email tool itself you can ask your team whether it's possible to create a distribution list email (group of emails) that can be used instead of ~20 email ids

Hope this helps : )

@atcodedog05 - What is the exact number limit for email recipients?

atcodedog05

As per my experience, its was around 6-8.

Hope this helps : )

@sanketkatoch05 - there isn't a limit. its about how you are feeding your info to the email tool.

Instead of doing this:

john.smith@gmail.com; jim.smith@gmail.com; mark.jacob@gmail.com; ed.helms@gmail.com; blake.hanson@gmail.com

Keep your list in a column and feed it to the email tool.

@Maskell_Rascal

Here you go.

Recipient List.csv

Save From Truncating.yxwz

@sanketkatoch05 - are you uploading a file for this app when you run it, or is the data built into the app and you select/deselect the recipients via the list box tool?

@sanketkatoch05 - I think I have it sorted now.

Your List Box tool should be configured as follows:

This will create a concatenated list of your emails separated by a semicolon.

Your Update Value tool should be configured to replace the specific string like this:

That will feed into the text input as you had it previously setup.

Then add in a Text to Columns tool to split the data to rows and feed it into your email tool.

Attached is a mockup where I connected it to a browse tool to see the output.

Results:

Let me know if that works for you.

Cheers!

Phil

Save From Truncating.yxzp

Thanks, @Maskell_Rascal.

Your solution has worked well for me. Appreciate the prompt response.