0

I created a flow 'when item is created or modified' to send email to user who is listed in the 'Assign To' column in SharePoint. The flow worked fine until my manager asked me to make the 'Assign To' column in SharePoint multi-select. So I updated it. Now my flow does not work.

How can I set my flow to send email to all persons listed in the 'Assign To' column in SharePoint?

Thanks enter image description here

0

Please following steps:

1.Add "When an item is created or modified" trigger

2.Add "Initialize variable" action

  • Name: AssignedToUsers
  • Type: String

3.Add "Append to string variable" action

  • Name: AssignedToUsers
  • Value:Assign To Email;

4.Add "Send an email(V2)" action

  • To: AssignedToUsers

enter image description here

enter image description here

3
  • I am getting an error. Here's the error: ExpressionEvalualtionFailed. The execution of template action 'Apply_to_each_2 failed the result of the evaluation of 'foreach' expression '@triggerOutputs()?(body/AssignedTo']' is of type 'Object'. The result must be a valid array. Jun 1 at 15:25
  • Hi Aleshia Thompson. "Apply to each 2" error? Can you tell me your whole flow process? This can help us solve the problem better. Jun 2 at 0:46
  • After more searching, I found that I had to add the 'Compose' action to compose the output and return the json code. I added this to what you provided and it worked. Thanks so much for putting this in plain language. I appreciate that. Jun 5 at 20:15
0

Try this:

  1. Initialize a blank string variable
  2. Append the variable with the "Assigned To Email" field. This should add it into a new "Apply to Each" action.
  3. After the new Apply to Each action, add the variable to the "To" field of your "Send an email from a shared mailbox action.

enter image description here

1
  • this did not work for me. The answer above worked for me. Thanks for your help. Jun 5 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.