Send custom Sharepoint File list every day

[FlorentP]

Hi,

Maybe it's easy but i can't figure out how to send the complete filelist in just one mail...

If i use that flow , i get a mail for each file in the list ...

If i use "Create HTML Table" , i get illegible mail like " ...table><thead><tr><th>Id</th><th>Name</th..."

I just want this :

File1 = modified today at 10:00

File2 = no update today

File3 = modified today at 9:00

[ScottShearer · Accepted solution]

@FlorentP 

What Send an Email Connector are you using?

If you are using the old connector (not V2), then you need to click on "Show advanced options" and set "Is HTML" to yes.

[RezaDorrani]

Hi @FlorentP 

Your issue is you are using the send email action inside of the for loop

first create an array variable 

then inside for loop append to array variable - here you can add your fil1 modified or no update

after for loop you have all results in the array

Regards,

Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[FlorentP]

That's right thank you Scott

Here's the final result:

expression for last_update = 

if(equals(formatDateTime(item()?['LastModified'],'yyyy-MM-dd'),formatDateTime(utcNow(),'yyyy-MM-dd')),'Update OK','No change')