cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
irondinges
Advocate II
Advocate II

SharePoint Created By user has no email associated

Good day,

 

I have a flow that generates an email alert when a list item is created.

This uses the "Created By - Email" dynamic content item from the trigger body.

 

One of my users has an issue where they do not receive emails when creating items. The flow works fine for other users (I have used this same pattern on dozens of flows with success).

 

Upon closer inspect of the flow's run, I noticed that the "Email" field for the "Created By" user is null. See below:

created by email null.png

 

Some background information on my company's structure.

We have two tenants:

Tenant 1 - This is the tenant in which the flow lives. I have an account in this tenant.

Tenant 2 - This is the tenant of the user above who is having the issue.

 

The SharePoint site that the flow is connected to is a Team site created in Tenant 1. The user is part of this Team ("guest" user).

 

I investigated a bit further by querying the "User Information List" using Power BI, where indeed this user's email field is blank.

Note that other users from Tenant 2 do have an Email address, and presumably the flow would work fine for them.

 

I am not sure if this issue is beyond the scope of this forum, and where I should go if this is more a SharePoint related issue.

Is there a way to "edit" the user on the SharePoint user information list to resolve this?

 

Or will I have to split the Created By - Claims field to "build" the email address?

I want to avoid this as it adds unnecessary complexity for what I believe should be a simple system.

1 ACCEPTED SOLUTION

Accepted Solutions
v-bacao-msft
Community Support
Community Support

 

Hi @irondinges ,

 

You can complete the corresponding user information in the Office 365 admin center.

Or you can split the Created By-Claims field to get the email address. Like:

9.PNG

last(split(triggerOutputs()?['body/Author/Claims'],'|'))

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

Hi @irondinges ,

 

You can complete the corresponding user information in the Office 365 admin center.

Or you can split the Created By-Claims field to get the email address. Like:

9.PNG

last(split(triggerOutputs()?['body/Author/Claims'],'|'))

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-bacao-msft ,

 

Thank you for the suggestion.

 

I did have to extent the split logic a little bit.

 

The claims string is in the following structure:

"i:0#.f|membership|name.surname_tenant2.com#ext#@tenant1.com"

 

So I did a split by |, then by #, and finally replaced the _ with @.

 

jvdlinden
Kudo Collector
Kudo Collector

I have found that this could also happen when there is no Exchange plan enabled for the user account that had created the item. That also causes the Email property to be null.

In my scenario, the user was assigned a Office 365 E3 license, but Exchange Online (Plan 2) within it, was not enabled.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (2,136)