cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sudosaurus
Post Partisan
Post Partisan

Creating items in sharepoint from external email address

Hello,

 

I have a workflow setup that creates an item in SharePoint when an email is received in a shared mailbox.

 

I have a person picker / people column which is populated by the "From" of the Email address and when hovered over displays the users Office 365 profile information.

 

The problem I've now discovered is that if an email is received from either an external email address or a generic account that is not synced with Office 365 then the flow fails on the "Create item" step.

 

Is there any way I get get this to work and detect these external accounts and create the items in SharePoint?

The only way I've figured out so far is creating a new text column and this is filled by the email address however on default for this workflow I don't want all email addresses to use this method as want to be able to get O365 user information. Either that or populate the user information from the email and Get Profile (V2) into separate columns.

 

Thanks,

 

flow3-fail.png

 

flow1-fail.pngflow2-fail.png

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @sudosaurus 

 

You're using the email indeed, but you're requesting other fields from Office 365 (Display Name, Business Phones, etc.). Power Automate will still try to find the user to fetch that information, and since it's a Gmail user, for example, it can't find it displays the name on Office 365.

 

You need first to check if the user is an Office 365 user. If it is, then you can collect all that information. If not, you can only collect the email since it's the only information you have.

 

To check you can do the following. First, get the information about that email from Office. If it can receive it, then you have information to save; if not, then it returns an error, and you only have the email. Here's what you need to do:

 

Global check:

Screenshot 2020-08-18 at 17.26.38.png

 

Create a parallel branch:

Screenshot 2020-08-18 at 17.26.45.png

 

Select "Configure Run After"

Screenshot 2020-08-18 at 17.26.50.png

 

Then select it to run after errors.

Screenshot 2020-08-18 at 17.26.59.png

 

Can you please check if and let me know if you have any questions?

 

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

Cheers
Manuel

View solution in original post

3 REPLIES 3
manuelstgomes
Super User II
Super User II

HI @sudosaurus 

 

The issue is that Power Automate is searching for that email address in Office 365 because, as you said correctly, it's external to the organization.

 

I would recommend, instead of a Person field in your SharePoint List, to have a text field where you store the email in a string format. Then you can fetch if needed in other Power Automates the details of the person if it's internal to your organization and have an email ready to use if the person is outside your organization.

 

Can you please check if and let me know if you have any questions?

 

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

Cheers
Manuel

 

HI @manuelstgomes ,

 

I have created all the below as text fields but when sending from an external email its still complaining that it cannot find the user.

What am I doing wrong here?

 

sudosaurus_0-1597756594280.png

 

Hi @sudosaurus 

 

You're using the email indeed, but you're requesting other fields from Office 365 (Display Name, Business Phones, etc.). Power Automate will still try to find the user to fetch that information, and since it's a Gmail user, for example, it can't find it displays the name on Office 365.

 

You need first to check if the user is an Office 365 user. If it is, then you can collect all that information. If not, you can only collect the email since it's the only information you have.

 

To check you can do the following. First, get the information about that email from Office. If it can receive it, then you have information to save; if not, then it returns an error, and you only have the email. Here's what you need to do:

 

Global check:

Screenshot 2020-08-18 at 17.26.38.png

 

Create a parallel branch:

Screenshot 2020-08-18 at 17.26.45.png

 

Select "Configure Run After"

Screenshot 2020-08-18 at 17.26.50.png

 

Then select it to run after errors.

Screenshot 2020-08-18 at 17.26.59.png

 

Can you please check if and let me know if you have any questions?

 

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

Cheers
Manuel

View solution in original post

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors
Users online (2,990)