Recurrence flow "Send an Email" 'To' is failing because of "Null"

Like (0) Share

Report

Posted on 30 Jan 2024 19:42:39 by AbraxasKing

Good Afternoon everyone

I'm having an issue with a recurrence flow. I've created my flow, but the 'To' section in the Send an Email action keeps coming back as 'Null'. Now the list that is connected to this flow, the column where the flow is pulling the email address for the Send an Email action is a Person or Group type, allowing for multiple persons. I don't know if that is the issues. Below is my flow:

The formulas here is simple: body('Substring_2_Days')

The formula in the 'To' section is: first(body('get_items_2_days')?['value'])?['AssignedTo']

Error I get:

Parameter 'To' cannot be null or empty.
clientRequestId: 41688d6a-d812-4b04-9fa5-36640800ce09

I can't figure out how to fix this error.

Can anyone help?

Thank you in advance

Abraxas

I have the same question (0)

All responses (8)

Answers (0)

VictorIvanidze 12,558 on 31 Jan 2024 at 14:59:23

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

Show your output where AssignedTo is visible.

Was this reply helpful? Yes No
AbraxasKing 22 on 31 Jan 2024 at 14:23:29

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

Looks like if I use an actional email address, the flow works fine. But if I try using an expression, such as,
first(body('get_items')?['value'])?['AssignedTo'] it doesn't work.
I need the flow to extract the emails from the from my lists "AssignedTo" column.

Was this reply helpful? Yes No
AbraxasKing 22 on 31 Jan 2024 at 14:09:48

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

Funny thing is, when I delete the action 'Send an Email v2' completely and test it. I have no problem with Get Items.

Was this reply helpful? Yes No
VictorIvanidze 12,558 on 31 Jan 2024 at 13:03:51

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

It looks you haven't got right to execute "Get Items" from this source.

Was this reply helpful? Yes No
AbraxasKing 22 on 31 Jan 2024 at 12:59:16

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

@VictorIvanidze

Was this reply helpful? Yes No
VictorIvanidze 12,558 on 31 Jan 2024 at 08:29:12

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

I've asked for output of "get_items_2_days'" action.
Where is the JSON array of items?

Was this reply helpful? Yes No
AbraxasKing 22 on 30 Jan 2024 at 19:57:19

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

Do you need more?

Was this reply helpful? Yes No
VictorIvanidze 12,558 on 30 Jan 2024 at 19:54:59

Like (0)

Report

Re: Recurrence flow "Send an Email" 'To' is failing because of "Null"

Could you show the output of "get_items_2_days'" action?

Was this reply helpful? Yes No