Receiving an error about type/format 'Array' is not convertible to type / format 'string/email.'

[cmspowerauto]

Hello-

I am trying to set-up a monthly reminder to owners to go into a list and provide updates to leadership on deliverables. The list has been created and the 'responsible persons' have been entered into the MS List. Here are the steps that I currently have, and I have tried it several other formats receiving the same error.

1) Recurrence- on the 28 of the month, run

2) Pull the list from the SharePoint

3) Get the items from the list

4) Send an email (V2).

Here is the picture of the automation, with the error at the top:

[Expiscornovus]

Hi @cmspowerauto,

It looks like you used the Responsible Person field (which is an object with the id, email and other properties of the person).

Can you try and use the Responsible Person Email field instead in the To field of your Send an Email (v2) action?

[cmspowerauto]

Hi @Expiscornovus 

Thank you for your reply. It took a few different tries to get Responsible Person Email to come up in the field, but it eventually did. Once I got it, the error went way, but the flow failed- and no email was sent. Any other ideas of what could be wrong? 

[cmspowerauto]

Here is a picture of the error:

[ManishSolanki]

Hi @cmspowerauto 

Please check if there is a value present in Responsible person field in the SharePoint list. The email action will fail if there is no value in that field.

Thanks

[cmspowerauto]

Hi @ManishSolanki 

Thank you for your reply. Yes, every line in the list has a 'Responsible Person' entry / value populated. After it has run, and no email is sent, this is what the error looks like on each email entry:

[Expiscornovus · Accepted solution]

Hi @cmspowerauto,

I see you have a nested apply to each. So, if I understand correctly your Responsible Person field allows the selection of multiple users?

If that is the case you need to make sure you use the correct fields in the two apply to each loop actions. Can you double check the below?

Apply to Each - Value

Apply to Each 2 - Responsible Person

To field - Responsible Person Email

@ManishSolanki, it if is empty it will simply skip the apply to each 2 loop. It shouldn't error in that case.

[cmspowerauto]

@Expiscornovus   Thank you very much, this solved the issue! I had the 'Responsible Person email' - not 'Responsible Person' in the middle nest. As soon as I adjusted that, it ran perfectly. Thank you!