You’re offline. This is a read only version of the page.
Hi, I'm building a flow which sends an email when a new file is added in a SharePoint folder.
I'm having issues with the Email section. I have multiple email distribution list in separate excel workbooks which I was able to pull in via List rows present in table. However, when I added more than 1 output to the To/Send To section, the email gets sent in a loop.
Also, is there a way to not send multiple emails if a user is present in more than 1 email distribution list?
Hello @bliow7 ,
that's because the 'List rows...' action will return an array where each row will be a separate item, and since it's an array it wants to process all the rows one by one.
If you want to send only 1 email then you can 'Select' only the email addresses from each of the rows and then join(...) them together using ; as a separator to send the email as explained here.
I don't think there's an easy way to get all distribution lists for all the users, but if you send it as a single email then it shouldn't matter how many list the user is in, he'll get just one email anyway.
Share
Report
All responses (
Answers (
10,185
