when saving data from many rows in a table, the bot send many mails for each rows instead of one

[Ruxandra]

Hello!

I have a table where user should modify some rows of the Table 1 by changing or adding data using Input().  When he saves data using "Save" button of the app,  the bot send many mails for each rows instead of single one, with .pdf file attached created for each row, and then, the last email contains the good .pdf file having all the rows user had selected.

In my pdf templates I use <<Start: Select(Table1[Id])....>>.columns..<<end>>, it works correctly, but my problem is that for each row between Start and End , the bot send one email, and, I suppose, after finalising the save process, it sends the complete pdf file.

How could I make the automation run only for all selected rows and not for every rows?

Thank you very much for your help!

Regards!

Ruxandra

[TeeSee1]

Showing your bot's definition would help community members to figure out what is going on.

If a bot is triggered on Data change (add, delete, edit), it processes each row separately, meaning email is sent for each row, and it is an expected behavior. However your last email containing all the changes actually is quite puzzling because that should not happen.

So again, showing what you have configured should help.

[Ruxandra]

Hello!

Yes, it is triggered on Add, and it send email for each row, and in the last email has, the pdf file has all rows... I changed the technical solution, but I am interested in finding out if there is a way to have only the last email sent.

Thank you!

Regards

Ruxandra

[TeeSee1]

What I do not understand is if your bot triggers on an Add event, then the last email listing all the rows should NOT happen. In order to understand what is going on, the community needs to know exactly how you have configured your automation.

Meanwhile if you have your requirements satisfied with a different setup, then that is great. Sometimes there are more than one way of achieving something and no need to be attached to only one way!

[Ruxandra]

Hello!

I need only the last email with the .pdf file containing all the rows; I think the insert is done in the db row by row, and not on bulk even if the rows are all selected using an action (LINKTOVIEW("Determinari")&'&selected='&ENCODEURL('["'&SUBSTITUTE(ORDERBY(FILTER(“Determinari”,[Nr]>=1),[_ROWNUMBER]),' , ','","')&'"]')); so, the automation is triggered on Add, then step 1 send emails.

Thank you!

Regards!

Ruxandra