i have Append data table activity in While loop , and i insert the data table in mail body , but the data table appended with each other each run time ,so how to stop this appending at each run time and take only the new data table?
Have you tried with Clean data table activity before Appending the data again ?
Build Data Table (Initialize an empty data table with the same structure as the one you want to append)
While Loop:
-Clear Data Table (Clear the data table at the start of each iteration)
-Append Data (Use “Add Data Row” activity to add new data to the data table)
Send Email (Use the data table outside the while loop to send the email)
i tried clear data table after sending the email, but still send the old table with new table in the next mail
Can you share the SS with us? @Ahmed_Hussien