Send a single email when rows are added to a table

(0) Share

Report

Posted on by ronnie_macleod

I have a dataflow in dataverse that copies new rows from table 1 to table 2. When 1 or more rows are added to table 2 I have a cloud flow that sends an email.

My issue is that the cloud flow sends an email for each and every row added to table 2 whereas I only want 1 email to be sent regardless of how many rows were added. I don't need to know how many or which rows were added (although that might be useful if its easy).

Spent ages searching for a solution and saw a piece about using the Filter rows option and $top to select only 1 row regardless of how many were added but this had no effect (maybe I did not do it correctly - $top 1 )

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (1)

Report

Hey @ronnie_macleod,

The way your flow is built now this wont be possible.
You used the trigger when a row is added or modified, so the flow starts for every record that is added or modified.
The different runs are not connected.

You could instead let the flow run every 15 minutes for example to see how many new records where created and send only if there where new records.
You could also say once a day or something like this.

You could also add the mail portion to your first flow that seems to copy several records at the same time.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
ronnie_macleod 8 on at

Like (0)

Report

Hi,

thanks for this - I wasn't using another cloud flow to start the dataflow but I think that might work and will give it a try and post back if it works...

Was this reply helpful? Yes No
Daniel Bocklandt 5,117 Super User 2025 Season 2 on at

Like (0)

Report

Perfect let me know if you need any further assistance.

Was this reply helpful? Yes No
ronnie_macleod 8 on at

Like (0)

Report

Well @DBO_FV I think I'm nearly there but I have a new issue with this approach:

I now have a parent scheduled cloud flow that only has 3 steps, the first step calls my dataflow to copy the data from table 1 to table 2 and the second step call a child flow that gets the new rows and filters the list to 1 row and then sends an email for that row.

The new problem is that it seems that the child flow is starting before the dataflow on the previous step has finished so there are no new rows when the child flow runs and no email is sent (if I run the parent flow a second time without changing anything the child does pick up the new rows and sends the email which suggest the problem is with the parent flow).

I tried inserting another child flow to do the dataflow step in the parent flow but that did not change the outcome...

Was this reply helpful? Yes No
ronnie_macleod 8 on at

Like (0)

Report

So I put a 5 minute delay step between the dataflow step and the child flow step and it now works as required, however this is a very unsatisfactory "bodge" fix as I now have to guess what the maximum time is that the dataflow needs to run and it will either be excessively long (this wasting time and system resources) or it will be too short and will fail.

Surely there is a exiting bit of logic that can be applied that fixes this properly?

It seems to me that this default behaviour is a bug (unless I have made an error somewhere) since if I wanted the subsequent step to be performed regardless of the status of the dataflow step I would have added the child flow step as a parallel step rather than a sequential one?

Was this reply helpful? Yes No