Flow to Send One Email instead of Multiple Emails

[theBrianL]

My flow is this:  Get Items from SharePoint List, Create HTML table, Condition inside For Each Loop that when evaluated to Yes, It inserts rows into excel table on SharePoint.  I then have an  Get File Metadata using path, and Get File Content Using Path.  I then send email with excel attachment using Attachment Name, and Attachment Content.  It is sending an email for each item where condition evaluates to Yes(for each row inserted into table).  Makes sense since this is inside For Each loop, but I moved the Email section out of For Each loop and still get multiple emails.  How would I modify to just get one email?   Couldn't paste image of flow. 

[v-duann-msft]

Hi @theBrianL 

Thank you for posting.

According to your description, you would like to copy items to an Excel file and send it as attachment via email. Normally, it will send several emails due to loop, but you want to combine them to one email sending to several recipients. If any misunderstanding, please feel free to let me know.

We can use variable to grab the email address for each user chosen in the people picker and then put that string of multiple email addresses into the TO: field for the email.

Thus, I tried to simply your flow without condition part and it won’t affect the major steps. Here you are:

My SPO list:

My flow overview:

Flow in detail:

Pay attention to red-circled part. The semicolon is necessary to separate emails.

Once tested, I’m able to get only one emails sent to several users.

Hope the content above may help you.

Best regards,

Anna

[theBrianL]

Thank you for explanation.  But it's just one email address that I put in statically.  It was sending the email multiple times to same users.  Will that change the flow you made?   Also I realized the Create HTML table was unnecessary, so I removed that part.  

[theBrianL]

Also I need the condition, because the condition to insert rows is based on whether the Modified field is equal to today's date.  formatDateTime(utcNow(),'yyyy-MM-dd').  

[v-duann-msft · Accepted solution]

Hi @theBrianL 

Thank you for your further explanation. Sorry for the misunderstanding.

If the email address is static with grab 'send email' outside of loop. We will receive one email. But it's weird from your end. Thus, I recommend you can change flow from the beginning.

Flow details:

formatDateTime(utcNow(),'yyyy-MM-dd')
formatDateTime(addDays(utcNow(),1),'yyyy-MM-dd')

Filter query is used to reduce returned items based on modified date. It will make a query between today and today +1 with the ge and lt. It functions as condition.

The delay action is used to spare some time for flow to write data into excel. For how long we need to configure, it depends on the actual data from ‘get items’. I set up a 5 minutes delay here. If you have plenty of data needs to copy, you can set up it longer.

Once tested, only items modified today are filtered and wrote to excel. Meanwhile I only receive one email as you required.

Hope it helps.

Thanks

Anna

[theBrianL]

Anna Thank you for walk through of flow.   I'm using flow with Dynamic Content now, but when I get to the section of add rows into table, the only dynamic content available to put into the fields are the ones with 'ID' on the end of each name.  E.g. Address ID.

If I put this in its just going to add the field with the ID and not the physical address.   Seems like I initially tried this flow using Dynamic Content, and that was the problem I ran into.  How to proceed?   

[theBrianL]

[theBrianL]

I got the dynamic content loaded by doing a search for each field.   Now I'm getting this error on the Get Items section.  

[theBrianL]

I got it to run after correcting my formatting errors.  However,  the records that get added to the SP Excel file contain all of this extra string odata information:    {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":20,"Value":"MS"}

How would I just get the value to populate in all of the fields?

[theBrianL]

I put in an expression to extract only the values from the lookup fields.  Thanks for all the help!