Answered

ExpressionEvaluationFailed Error

Like (0) Share

Report

Posted on 18 Oct 2023 00:55:03 by Vee07

This error keeps reoccurring to my flow. I had it working before. Changed a few things but now I can't get it working again.

Essentially what I am building is a Sharepoint List Calendar with automated email reminders sent to people listed in the item. Email to be sent individually.

I think the error is coming from the "Output" selection for 'Apply to each 3' but unsure how to fix. I tried changing it to 'value' as well.

All responses (10)

Answers (1)

Vee07 25 on 18 Oct 2023 at 05:34:09

Like (0)

Report

Re: ExpressionEvaluationFailed Error

Thank you!
I swear that's what I had the first time round. I deleted the "Convert Time Zone" Action and rebuilt the action as you have shown above. Tested it and confirmed it worked and then added the "Convert Time Zone" action back in.
Verified answer

v-bofeng-msft on 18 Oct 2023 at 05:26:13

Like (1)

Report

Re: ExpressionEvaluationFailed Error

Hi @Vee07 ,

I've made a test for your reference:

1\My SP list

2\The flow

Best Regards,

Bof
Vee07 25 on 18 Oct 2023 at 05:20:50

Like (0)

Report

Re: ExpressionEvaluationFailed Error

As mentioned above

It's the list of people from the Sharepoint Column (Person or Group type column). Yes, it allows multiple selections.
v-bofeng-msft on 18 Oct 2023 at 05:19:29

Like (0)

Report

Re: ExpressionEvaluationFailed Error

Hi @Vee07 ,

Could you please tell me what 'Paper submis……' is? Is it a person column? Dose 'Paper submis……' allow multiple selections?

Best Regards,

Bof
Vee07 25 on 18 Oct 2023 at 05:13:54

Like (0)

Report
Re: ExpressionEvaluationFailed Error

I'm getting a different error now:

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'emailMessage' validation failed in workflow operation 'Send_an_email_(V2)': The parameter with value '"@items('Apply_to_each_2')['PaperSubmissionsBy']"' in path 'emailMessage/To' with type/format 'Array' is not convertible to type/format 'String/email'.'.
v-bofeng-msft on 18 Oct 2023 at 05:10:23

Like (0)

Report
Re: ExpressionEvaluationFailed Error

Hi @Vee07 ,

Please remove the 'apply to each 3' and send an email in 'apply to each 2', set the 'To' property to:

items('Apply_to_each_2')['PaperXXXX']

Best Regards,

Bof
Vee07 25 on 18 Oct 2023 at 03:36:16

Like (0)

Report

Re: ExpressionEvaluationFailed Error

It's the list of people from the Sharepoint Column (Person or Group type column). Yes, it allows multiple selections.
v-bofeng-msft on 18 Oct 2023 at 02:40:34

Like (1)

Report

Re: ExpressionEvaluationFailed Error

Hi @Vee07 ,

Could you please tell me what 'Paper submis……' is? Is it a person column? Dose 'Paper submis……' allow multiple selections? Could you please show me the expression of this dynamic content?

(Hovering the mouse over it will display an expression for a while)

Best Regards,

Bof
Vee07 25 on 18 Oct 2023 at 02:10:53

Like (0)

Report

Re: ExpressionEvaluationFailed Error

I've tried that but each time I put the Dynamic content in the "To" section, it creates a new "Apply to each" container.
v-bofeng-msft on 18 Oct 2023 at 02:09:09

Like (1)

Report

Re: ExpressionEvaluationFailed Error

Hi @Vee07 ,

Just remove the 'Apply to each 3' and send the email in 'apply to each 2' , the issue will be solved.

Best Regards,

Bof