Single mail when performing one or more changes on a column

(0) Share

Report

Posted on by dottorni

Good morning everyone,

I have a flow that every day checks a column of a sharepoint called "DataAppuntamento" and if the date is less than or equal to the variable "DataChiusura" and the status is equal "Aperto" changes the value of another sharepoint column called "StatoApp" The flow works correctly but I would like that if it performs a change of state it sends an email to say that changes have been made.

I tried by inserting send mail after update element but rightly it sends me an email for each status change it makes, instead I would like a single email if it makes one or a hundred status changes.

How can I do?

Thank you all.

All responses (1)

Answers (0)

ScottShearer 25,208 Most Valuable Professional on at

Like (0)

Report
Re: Single mail when performing one or more changes on a column

@dottorni

I suggest the following:

Use a filter query so that only records that meet your condition are returned

You won't need your condition

Here is a link for more info on creating OData filter queries

Add a Create an HTML table action

Create the HTML table from the output of your Get items action

Send a single email and include the HTML table

Let me know if you need more help.