Hello all,
Before I start - I have spent a week or so looking for a resolution to this issue but have to admit that my knowledge of the tool isn't good enough to implement the many solutions that appear across forums like these. No case is similar enough for me to understand the nuances, and so im here asking for a pointer.
The flow im creating should do the following: Notify multiple users by email, based on a ‘review date’ expiring (or due to expire) for a document sat in a library on a SharePoint Online site.
Setup:
I have two columns, Lead Author and Contact, both of which can contain multiple users. (See below). For example, in my SPO document library I currently have two test items (Fire and Flood .docx) - These match the review date criteria to trigger the flow for each, and therefore an email to be sent for each.
My flow is as follows:
Note: Ive used 'scoping' boxes to be able to quickly copy and paste the flow to work with a number of triggering time frames. For example, 3 months, 2 months and 1 month before the review date expires.
The Issue:
When i receive the email, each one contains my email address and the other test user email address multiple times. This seems to relate to the number of items that match the trigger criteria.
Expected Result:
Ideally, the Lead Authors and the Contact's should appear once in the To and CC fields of the email.
From what I've picked up so far, this may be due to the array operating in the wrong place or being immediately converted to a string? - Again im not familiar enough with the tool to see a way out of my specific example.
Any help would be much appreciated.
