Using String.Format to send mails does not work inside a For Each Row activity

#1

Hello everyone,

has anyone encountered this before?

I have an excel file with some rows in it. I need to send an email for each row, sounds like a simple thing, actually.

I am using For Each row activity for this and this works for the TO and Subject fields (Send SMTP activity)

Since I have a customized text for the body (html) and parameterizing some entries, I decided to use String.Format(str_EmailBody, row(“display name”), row(“username”), row(“request id”))

somehow using this does not work for the body, it doesn’t move to the next row and keep on using the same information in the 1st row.

Any solution anyone can share is highly appreciated! :smiley:

#2

Hi @Twits_Rombaoa,
Can you show your workflow example?

#3

something like this…
image

image
image.png469×556 9.75 KB

image
image.png456×583 10.8 KB

#4

Hmmm indeed it’s strange. Try maybe experiment with using row(index) instead of row(column name). Eventually you can try row.item(index) as well.

#5

thanks, i tried those but no luck

1 Like
#6

You could for the test build similar table using Create Table activity. And write to it couple of rows from excel. Then based on this table in debugging process you will see which values are taken. Maybe this will help somehow.

#7

Fine
may i know what is assigned to str_EmailBody variable
if possible can i have a screenshot of it
we need to have three place holders like this {0} {1} {2} only then the values i.e., the arguments we have passed like row(“display name”), row(“username”), row(“request id”) will be placed in that place holder

Cheers @Twits_Rombaoa

#8

hi @Palaniyappan, was hoping to get your attention as i saw some of your posts related to this one. :smiley:
this is what i have for str_EmailBody:

image
image.png896×197 6.59 KB

1 Like
#9

This one looks good
but i have a small query like are we trying to send this text as HTML
if not kindly remove the html tags and try once if possible
Cheers @Twits_Rombaoa

#10

yes, the email must be in html, but for testing purposes i unchecked isBodyHTML properties, unfortunately, it’s still the same, the To and Subject is working fine but body for all emails contains only the 1st record.

i think this is a bug already :slight_smile: wondering if UIPath is even aware of this hehe

1 Like
#11

did we try on removing the tags and send that simply as a text
Cheers @Twits_Rombaoa

#12

yup my text file contains only the following:

{0}
{1}
{2}
{3}

#13

i wonder why it didnt work
the values will surely be placed in the respective place holders mentioned in string.format method
hmmm. strange
Cheers @Twits_Rombaoa

#14

the values were placed in the right order, that is correct, but the thing is it doesn’t move to the next row to fetch the next set of values, just keep on using the values of the 1st row.

#15

can i have a screenshot of it if possible
Cheers @Twits_Rombaoa

#16

OMG! i just fixed it hahaha

instead of using Assigned Activity, just do the String.Format right in the Body field of the SMTP!

:smiley: :smiley:

2 Likes
#18

yah remove the assign activity of str_emailbody and mention that directly in the BODY property of the send mail activity
Cheers @Twits_Rombaoa

#19

haha, that is still really strange, why Assign activity doesn’t work :wink:

this gave me the headache the whole day!!! :smiley:

#20

@Twits_Rombaoa

Yes String_Emailbody is replaced… you have set one Constant Temp Variable…

1 Like
#21

but the Assign activity is also inside the For Each Row, so it is supposed to be overwritten by the value of the next row