cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Drogon
Frequent Visitor

Parameter 'To' cannot be null or empty. (but it's not empty!!)

Hi all, I have a flow that's been working great for the last 2 months, until today. Today it refuses to execute the "send email" action, citing a missing "To" address (see below images). 

 

There is a value in "To", I even deleted it and typed it in again at the source - it's typed into the SharePoint list this triggers off of as plain text. And this was working as recently as yesterday. 

 

 

Drogon_0-1647453760434.png

Drogon_1-1647453781977.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Drogon
Frequent Visitor

It definitely had a value in it:

 

Drogon_0-1647460928463.png

 

 

I tried deleting then re-adding the UPN, and that didn't work. 

 

Ultimately I got it to work by deleting the entire list item and re-adding it. Seems like a bug. 

View solution in original post

Drogon
Frequent Visitor

Finally figured this out, and boy is it user error!! But it may be something other folks run into. 

 

The issue was that the flow is triggered by the addition of an item to a list. 

 

I was adding two items to the list, and to be efficient, I opened the list in grid view and began adding both at the same time - so jumping back and forth between the two rows, populating information. Then at the end, EXIT GRID. 

 

But apparently what SharePoint does is begin processing the first new row the second you click down to the next row, even if it's all still in edit mode. So because the UPNs were one of the last columns I entered, the flow was triggering well before the data was available. 

 

So lesson learned: if you trigger off a new item, enter in one item at a time!!

View solution in original post

8 REPLIES 8
ekarim2020
Super User
Super User

The error message is saying that the Hiring Manager UPN field does not contain any data; it is empty.

 

Please check that SharePoint list item and confirm that the Hiring Manager UPN column contains a value. All Hiring Manager UPN items will need to contain values.


Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.

Drogon
Frequent Visitor

It definitely had a value in it:

 

Drogon_0-1647460928463.png

 

 

I tried deleting then re-adding the UPN, and that didn't work. 

 

Ultimately I got it to work by deleting the entire list item and re-adding it. Seems like a bug. 

Well done on fixing the issue. Yes, sometimes simply deleting an action and re-adding it can solve a number of weird problem in Power Automate. Similarly, saving a new copy of the flow can fix issues too when all else seems to fail.

 

Ellis

Hi @Drogon ,

 

Glad to see you solved the problem.
You could mark your answer as a 'solution' to close the case.

 

Best Regards,
Charlie Choi

Drogon
Frequent Visitor

I actually don't consider this closed. In my earlier post, I hadn't deleted and reinstated the action, I had to delete and then reinstate the entire list item. This week, I added another entry, and the Hiring Manager UPN field was absolutely filled in on the list, and I get the same error: "Parameter 'To' cannot be null or empty. clientRequestId: ab0d81ba-ab5c-48d1-a3b5-0265bc55e477".

 

So today I deleted and reinstated the entire action in the flow, same error. I've tried making the email field in question plain text (so a string field), and I've tried making it an O365 person, and either way, the flow keeps failing, claiming the field is empty. 

 

This has got to be a bug - this field is not empty. 

 

Hiring Manager UPN is a single line of text in the SharePoint list: 

Drogon_2-1648810845936.png

 

We send TO the Hiring Manager UPN:

Drogon_3-1648810861304.png

 

Field Hiring Manager UPN is filled in on the SharePoint list with a valid email address: 

Drogon_4-1648810898188.png

Flow fails, claiming the field is empty: 

 

Drogon_1-1648810614595.png

 

Drogon
Frequent Visitor

I got so frustrated that I added every singe iteration of the Hiring Manager UPN to the TO field (as text, as a person, as a hyperlink, etc.), and still get the same error, that TO is empty. Below I tried using a different "send email" action, to see if it made a difference. It doesn't.

 

Drogon_5-1648811807130.png

 

Drogon_6-1648811855276.png

 

What do address do you see in the raw outputs of the Send an email action?

ekarim2020_1-1648823659111.png

 

Please show us entire flow and the runtime outputs - to ensure that these fields are actually populated with values:

ekarim2020_2-1648823929558.png

 

Ellis

 

 

 

Drogon
Frequent Visitor

Finally figured this out, and boy is it user error!! But it may be something other folks run into. 

 

The issue was that the flow is triggered by the addition of an item to a list. 

 

I was adding two items to the list, and to be efficient, I opened the list in grid view and began adding both at the same time - so jumping back and forth between the two rows, populating information. Then at the end, EXIT GRID. 

 

But apparently what SharePoint does is begin processing the first new row the second you click down to the next row, even if it's all still in edit mode. So because the UPNs were one of the last columns I entered, the flow was triggering well before the data was available. 

 

So lesson learned: if you trigger off a new item, enter in one item at a time!!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (6,410)