Power Automate Issue - Recurrence Mail Based on File Metadata

(0) Share

Report

Posted on 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

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

ScottShearer 25,278 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@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,';')

Was this reply helpful? Yes No
Rauties 7 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No