Flow Sending Duplicate Emails

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a flow that sends emails to the list item owners to ask them to review the item on a certain date.

Each owner is getting the same email 4 times.

How do I avoid this so the user gets one email per list item?

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

mjburley 370 on at

Like (0)

Report
Copy link

Link copied!

What is the length of the Get files array returned - throw into a compose something like:
length(Get_files_properties_only)
I assume it's only one (or use first() to get back the first if there 'should' only be one.

Only other possibility is the send email action has cc / bcc populated as well?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks,

How can I get the length without running the flow again? One user got 500 emails so I dont want to run it and trigger all of those again.

There is a CC in the email but its a different user to the "Document Owner" that is in the "To" field. (Document Owner Manager)

Was this reply helpful? Yes No
mjburley 370 on at

Like (0)

Report
Copy link

Link copied!

When you're building Flows use the Terminate action to break the flow before sending emails.

So do a compose with length after the get rows, and then add a terminate action.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks,

I ran a compose :
length(outputs('Get_files_(properties_only)')?['body/value'])

And I got 187 results

Was this reply helpful? Yes No
mjburley 370 on at

Like (0)

Report
Copy link

Link copied!

Ah.

Best is to cut the send email action to the end of the flow (outside of the apply to each) and precede by a Terminate action to save it but not use it, whilst you debug.

Then you can just run the flow and see how many times the apply to run runs. Or set up a integer variable and do an increment each time, but the flow run will let you see how many times it runs and what the content is.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks,

I have tried to separate the email section and it reverts and auto applies the "Apply for each".

Is there a way around this?

Thanks,
Niamh

Was this reply helpful? Yes No
v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Maybe you could try to optimize your Flow structure.

1. Try to use the Odata Filter.

2. Get unique value of owner email address using array variable and union function.

I have made a simple test for your reference.

1. Here is my list.

2. Here is my flow.

internalcolumnname ne '@{null}'
items('Apply_to_each')?['personcolumn/Email']
union(variables('OwnerEmailAddresses'),variables('OwnerEmailAddresses'))
item()?['field name']

Result Screenshot:

In addition, here is a link that might help you:

https://www.enjoysharepoint.com/power-automate-sharepoint-get-items-filter-query/

Best Regards,
Charlie Choi

Was this reply helpful? Yes No
Verified answer

v-yujincui-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

UPDATE:

Sorry for my misunderstanding. Maybe you just need to remove the Apply to each 2 and replace the corresponding Dynamic content with expressions.

items('Apply_to_each')?['Owner/Email']
items('Apply_to_each')?['{Name}']
items('Apply_to_each')?['FieldName']

Best Regards,
Charlie Choi

Was this reply helpful? Yes No