Unanswered

Send an email to owners of open items from a sharepoint list

(0) Share

Report

Posted on by AlanJB

Hi,

I'm trying to send an email to owners of open items from a sharepoint list and having referred to a couple of earlier posts I have tried the following approach but I get an error message. Please can you advise how I can clear the error?

Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The inputs of template action 'Filter_array' at line '1 and column '2022' is invalid. Action 'Apply_to_each' must be a parent 'foreach' scope of action 'Filter_array' to be referenced by 'repeatItems' or 'items' functions.'.

Flow is as follows:

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

fchopo 8,003 Moderator on at

Like (0)

Report

Hello @AlanJB

Could you share what are you doing in the "compose" and "compose2" actions? I mean, which information are you storing and the operation in Union...

Does the remediation owner column allow multiple values?

Regards,

Ferran

Was this reply helpful? Yes No
AlanJB 8 on at

Like (0)

Report

@fchopo - The union operator is as follows...

union(array(outputs('Compose')),variables('Owner Array'))

Was this reply helpful? Yes No
AlanJB 8 on at

Like (0)

Report

@fchopo this is the post I have worked from... https://powerusers.microsoft.com/t5/Building-Flows/Creating-Email-of-Open-Items-from-SharePoint-List/m-p/195013

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

And does the Remediation owner allow multiple values?

Was this reply helpful? Yes No
AlanJB 8 on at

Like (0)

Report

Only single values allowed in owner.

Was this reply helpful? Yes No
fchopo 8,003 Moderator on at

Like (0)

Report

Hello @AlanJB

I think that the mistake is in the apply_to_each actions. Your "apply_to_each_2" should be outside of the first "apply_to_each". Could you move it out?

Regards,

Ferran

Was this reply helpful? Yes No
AlanJB 8 on at

Like (0)

Report

Hi Ferran,

"apply to each 2" is already outside of the first.

Was this reply helpful? Yes No