Unanswered

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

(0) Share

Report

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

All responses (8)

Answers (0)

VictorIvanidze 12,536 on at

Like (0)

Report

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

Show your output where AssignedTo is visible.
AbraxasKing 22 on at

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.
AbraxasKing 22 on at

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.
VictorIvanidze 12,536 on at

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.
AbraxasKing 22 on at

Like (0)

Report

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

@VictorIvanidze
VictorIvanidze 12,536 on at

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?
AbraxasKing 22 on at

Like (0)

Report

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

Do you need more?
VictorIvanidze 12,536 on at

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?