Answered

Issue When Trying to Send an Email to Staff Using a SharePoint List as a Routing Table

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I'm trying to use Flow to send an email to staff members if when the user filling out the form, indicated their department.

List 1: Ideas (contains the submitted forms from users with an Affected Department field)

List 2: Routing (contains the list of departments (Title) and the list of contacts for each department (Contact)

Error:

InvalidTemplate. Unable to process template language expressions in action 'Send_an_email_(V2)_2' inputs at line '1' and column '2707': 'The template language expression 'items('Apply_to_each')?['Contact']?['Email']' cannot be evaluated because property 'Email' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.

Workflow Details

I'm using Get Items to get the list of departments and contacts from the Routing list in SharePoint (List 2)

Get Items.JPG

Then I'm using a Send an email (V2) after a condition to send an email to each contact for that department.

Conditional Email.JPG

What am I missing?

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Sort by

RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

where are you using 'items('Apply_to_each')?['Contact']?['Email']' in your Flow
where is the error? can you share screenshot of Flow run with the error

'items('Apply_to_each')?['Contact']?['Email']'

Contact itself might be a multi peoplepicker field
hence running 'items('Apply_to_each')?['Contact']?['Email']' will run in error

you will have to also loop through your contatcs to generate the email id list

example Loop
'items('Apply_to_each')?['Contact']

within loop item()?['Email'] will give you the individual email

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I'm not a programmer, and just trying to get this task completed. We don't use Flow very often, so please understand my ignorance in this regard.

Here is a flow run with error. The error is only at the end of the flow. The Get Items section does not have an error.

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

screenshot of flow in edit mode please
and the send email V2 action expanded (you can make sure u hide information if confidential)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Here is the entire workflow in edit mode. Thanks!

Was this reply helpful? Yes No
Verified answer

RezaDorrani 12,145 on at

Like (1)

Report
Copy link

Link copied!

Hi @Anonymous

Your Contact column is a multi select people picker column
hence you will need a double for loop

this will send individual emails to every contact

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I hope that I did it right. Here is what I did:

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

I get this error:

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

do a test run

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks. The test run was not successful.

Was this reply helpful? Yes No
RezaDorrani 12,145 on at

Like (0)

Report
Copy link

Link copied!

@Anonymous

remove contact.email in your second for loop

and re-add it from dynamic content

Was this reply helpful? Yes No