Sending ONE email to managers with multiple SP List items

(0) Share

Report

Posted on by Chris74

PLEASE HELP!!

I created a flow that ALMOST does everything I need it to:

Get Items>Select (mgr email field from list)>Compose (specify unique mgr emails...no dupes)>InitializeVar (mgr name field from list)>InitialzeVar (select DueDate field)>Apply to Each>Set Var (MgrName)>Set Var2 (DueDate)>Apply to Each (Loop through unique mgrs)>Filter Array (MgrEmail=Apply to Each loop for mgr email)>Filter Array2 (MgrName = Null)>Create HTML Table (list multiple items from SP list)> Send V3 email

Everything works except - Im trying to use an expression in the email to greet the manager by first name only (e.g. Hi Chris). It's sending emails to the RIGHT manager email but greeting the WRONG manager's (first) name.

I have the same question (0)

All responses (3)

Answers (0)

lbendlin 8,332 Super User 2025 Season 2 on at

Like (0)

Report

Re: Sending ONE email to managers with multiple SP List items

You seem to set the ManagerName variable in a separate loop? Your screenshots are a little hard to string together.

Was this reply helpful? Yes No
Chris74 31 on at

Like (0)

Report

Re: Sending ONE email to managers with multiple SP List items

How can I show the flow differently/better? Its pretty large...I listed each step in the description and hope the screenshots would help for reference. Yes I set the ManagerName variable in a separate loop thinking I could recall and SPLIT out the first name in the greeting of the email body. Using this expression:
first(split(body('Filter_array_2'), ' '))

Was this reply helpful? Yes No
Chris74 31 on at

Like (0)

Report

Re: Sending ONE email to managers with multiple SP List items

Additionally I should mention, in the List (get items), there are 2 fields: one for manager name and one for their email. The first name I am splitting SHOULD be on the name (field) of the manager being reference by the "Unique" email address (output of the Select/Compose of the email).

Was this reply helpful? Yes No