When item is modified send only one email

(0) Share

Report

Posted on by milky_bar_may

228

Hi,

My datasource is a Sharepoint list.

In my PowerApp I have a dropdown where the user can select a name to escalate the item to.

This will trigger an email asking the person to log into the tool.

However, if the PowerApp user selects 10 items to escalate to the same person I still just want only 1 email to be sent, not 10.

Can anyone help with this please?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @milky_bar_may

Could you please post a screenshot of your flow?

Thanks

Was this reply helpful? Yes No
sudharsan1985 1,325 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @milky_bar_may
Since there is no screenshot on how or what are all the details that you are trying to send in the email, I assume the details are just the item id or title. Before send an email, you have to construct the html table or array and try to use that output in the send email so that only one consolidated email will be sent to the user.

Hope it helps, please like it or mark it as a solution if it resolves your clarification or issue
-Sudharsan K...

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @milky_bar_may ,

When Flow is triggered, what data can be passed to Flow?

If we can get the item id, then we can filter the user info contained in the item, group them and summarize the information. Then we can send an email reminder to the individual users.

Please provide more details so that we could provide a proper workaround for you.

Best Regards,

Was this reply helpful? Yes No
JimmyW 2,567 on at

Like
a
(0)

Report
Copy link

Link copied!

In the flow you can have "Apply to each" where you use "Append to array variable" and append all the data you need and collect it. Then create HTML table from the Array and send it as an email.

Was this reply helpful? Yes No
milky_bar_may 228 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @abm , @sudharsan1985 , @v-bacao-msft , @JimmyWork

Thank you all for your responses. I am a complete novice with Automate so my apologies.

This is a screenshot of my flow:

As you can see, if 10 items are modified and to the same user then they will receive 10 emails.

Ideally I would rather they just received one email, rather than 10 clogging up their inbox

Thanks

Ed

Was this reply helpful? Yes No
JimmyW 2,567 on at

Like
a
(1)

Report
Copy link

Link copied!

I'm not really sure how you can solve this.
The trigger will always be triggered when a new item is created or modified.

Is it always the same user that gets the email or do you use a column that specifies the user?

Maybe you can use the Recurrence in flow and check every hour for all items that have been edited/created within that hour and send an email to the user every hour of new items have been edited/created.

You would need a condition or recurrence to solve this i belive.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @JimmyWork

Create a new column called send email. Once the email is send then update the column as 'Yes'. Before sending the email do a List Items filter against the records whether it's already send email or not?

Thanks

Was this reply helpful? Yes No
JimmyW 2,567 on at

Like
a
(1)

Report
Copy link

Link copied!

@abm Something like that would work, the solution is for @milky_bar_may

Was this reply helpful? Yes No