this part is FR for some people…not a
@ertan_ay1 , Could you show us the Expression in the Workflow ? Want to know what is the value you are using as the String.
It looks like you are passing a Hardcoded value into the Type into Activity.
If you are supposed to enter each value present in the Excel Column, then You would need to read the Excel as a Datatable using Workbook
Read Range Activities, Use
For Each Row Activity Then Inside
For Each Row Activity you would have to use
Type Into Activity with the Below Expression :
CurrentRow is each row present in the Datatable and
CurrentRow("IBAN").ToString will provide us the IBAN value of each row in Excel.
Yes. That is because you are using the Hardcoded value as the Input String.
We need to replace it with your dynamic row value from the Excel.
You are using this Expression :
You have to replace the String
"55199415284267214210047337" with your dynamic value from the
For Each Row in Datatable.
You would require to do the Solution Somewhat in the Below way :
In that case, Could you Explain what is your Process actually ? You could explain it Stepwise?
Earlier, You did share Screenshots of Excel Sheet, Hence was assuming that you had an Excel file from where you are retrieving the values.
First of all, I apologize for not being able to reply right away. @supermanPunch
@ertan_ay1 , Were you able to Automate the Downloading/Saving of the Excel in the Email Request?
What are the Steps you have already Automated ?
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.