You’re offline. This is a read only version of the page.
I have a simple SharePoint list flow. When a new item is created it sends an email. The "To" field of this email flow is actually taken from a 'Person' column in a SharePoint list. This is a required field, so it certainly is not blank, however I'm receiving the following flow failure:
Share
ReportParameter 'To' cannot be null or empty.
The important takeaway is this only happens with a handful of users. Out of 150 users in the organization, only 7 of them have this flow failure every time their name is chosen in the Person column.
To attempt to troubleshoot this item, I created another flow that adds a row to a spreadsheet whenever a new item is created in the SharePoint list. Suspiciously this column is blank as well whenever I choose the user "Email Address". However, I added a column right next to it where it takes the user "Display Name" and the column contains data.
Can anyone explain this weird quirk? Is it possible our Admin missed filling something in when creating these Microsoft accounts?
The point is to choose the same dynamic content or function that you are using to fill in the To field in the email. The point is that then you will be able to check the value being used. The failed email action won't show you the input. But loading the same value in a compose first will.
@Pstork1 ,
Thanks for the quick response. I'd appreciate a little assistance on how to implement this.
I assume on the INPUT of this compose function I chose the Person column of the SharePoint list. I still get the failure, but no additional info on why. I've selected the employee's Display Name, Email, Department, Job Title. But how do I tell what is returned. What am I missing from this test?
add a compose just prior to the send an email. Add the person.email address to the compose. Then you will know exactly what you are getting when you access that field. If it is indeed null then you can start looking at that persons profile and Azure AD record to see if there is something missing.
For example in this list I have a person column called approver. So there is a dynamic content from the item called approver Email
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
All responses (
Answers (
