Power Automate Issue - Recurrence Mail Based on File Metadata

Like (0) Share

Report

Posted on 2 Nov 2022 08:47:35 by Rauties

Hi All,

I am struggling to create a flow that sends an email based on the value of a specific metadata column value.

Condition part runs fine until I add the part that has to send the email.

The problem seems to be the dynamic content I add in the "To" field. When doing this an "apply to each" is created with an output of "current item". The dynamic content is a "Person" metadata column.

Any assistance would be appreciated.

Thank You

All responses (2)

Answers (1)

Rauties 7 on 02 Nov 2022 at 12:59:08

Like (1)

Report

Re: Power Automate Issue - Recurrence Mail Based on File Metadata

Hi

Thank you for the response.
You are correct, it was set to multiple responses. I will go and turn that off.
I will test if my flow works then and if not use your suggestion here.
Verified answer

ScottShearer 25,212 Most Valuable Professional on 02 Nov 2022 at 12:39:54

Like (1)

Report

Re: Power Automate Issue - Recurrence Mail Based on File Metadata

@Rauties

I suspect that the person or group column allows for multiple entries, and you want to send a single email. Since the column can have multiple entries it returns an array. When you reference an array, it puts you into a loop.

You need to create a semicolon delimited string containing all of the emails addresses and use that string for the email address. The easy way to do this is by using a join() expression:

join(column ref for email address goes here,';')