So I have a sequence that filters data from an excel file sheet based on the current date but now I need to extract the data from that data table and type it into the body of an email. I am unsure why when the for each row activity is being called it is not being accessed.
Here are all the files:
Main.xaml (13.4 KB)
SaldoBancosIndividual.xlsx (9.5 KB)
Thank you
Do you mean like you want to insert the datatable as a table along the mail body
If so did we check with this thread
Cheers @ramon.gonzalez
I mean have it as text inside an email.
Example:
Bank: ***
Account Number: ***
Available Balance: ***
Fine
This would surely help you resolve this
Cheers @ramon.gonzalez
I already did it that way to format the string, the problem is that the “For each row” activity is never called so I can’t access the values of the rows in the data table unless I’m forgetting something to get the data inside dt_out and pass it as a string.
@Palaniyappan the problem is not my string formatting though, the problem is that the “For each row” activity is never called so I can’t access the values of the rows in the data table unless I’m forgetting something to get the data inside dt_out and pass it as a string.
It does access to the for each…
But i don’t unterstand why using two for eachs… and inside the first one, using data table from the read range ?
one is a for each to filter the data table based on bank and date the second is a for each ROW to get the data and be able to type into the body of an email message.
If you debug with slow step on you can see the ‘For each Row’ activity is never accessed, this is true also if you remove the first for each it still doesn’t enter the loop.
Fine
Is it’s throwing any error when getting to FOR EACH ROW activity
If not make sure that the filter datatable activity gives us a datatable as output with data in it
To validate that before for each row activity use a writeline activity and mention like this
dt_output.Rows.Count.ToString
Where the dt_output is the variable from filter datatable activity with default value as New System.Data.Datatable defined in the variable panel
If that shows us any value in the output panel then fine with the datatable else we need to check the conditions mentioned in the filter datatable activity
Cheers @ramon.gonzalez
Ok, I validated it and this is my output:
And this is my filter, which worked on another workflow (have tried date filter with Today and Date.Now.ToShortString):
kindly check once what is the condition mentioned in the filter datatable activity
if possible canyou share that screenshot
@ramon.gonzalez
I edited the post to show the screenshots. Sorry about that.
