Send an e-mail to multiple SharePoint Metadata persons of a file in a Document library.

[StevenTeunissen]

Hi,

I have a document library on SharePoint and there is a metadata column with multiple persons. I want to use Power Automate to send an e-mail to these persons when the expiration date (another metadata field) is coming in 3 days. The last part is working and also when I use a single contact it's working properly. But now when I use the multiple person setting there is a Apply to Each within an Apply to Each and the following error appears:

ExpressionEvaluationFailed. The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@items('Op_alle_bestanden_in_de_bibilotheek_toepassen')' is of type 'Object'. The result must be a valid array.

This is the flow:

 

Hopefully you can help me out.

Looking forward for your replies. 

[PrasadAthalye · Accepted solution]

Looks like some glitch.. I got same issue. Change Current Item to actual Column name property... And Use email address inside user profile ... Refer Example below...

[StevenTeunissen]

Thanks, that works!