Skip to main content

Notifications

Community site session details

Community site session details

Session Id : Zkp5t3rDpoNqYM2mxs0Oqr
Power Automate - Building Flows
Answered

Create new SharePoint list item from an email

Like (0) ShareShare
ReportReport
Posted on 3 Mar 2017 17:38:37 by

Hi, can someone help me understand how to have an email create a new SharePoint list item?  Seems simple and built the flow in less than 5 minutes, but test emails are not showing up in the list. I have tried a variety of things and am starting to wonder if I need some SharePoint administrative feature for my site turned on.

  • m_from_za Profile Picture
    2 on 01 Feb 2024 at 08:53:28
    Re: Create new SharePoint list item from an email

    Would you mind posting the flow as well? I get support requests via mail and I want to create a flow which creates a line item in a list I created. Thanks in advance

  • Community Power Platform Member Profile Picture
    on 13 Jan 2023 at 17:30:18
    Re: Create new SharePoint list item from an email

    This is very  helpful. Thank you. I often have to modify flows and sometimes even delete them and start from scratch. Thought it was just me! - L

  • Verified answer
    Community Power Platform Member Profile Picture
    on 06 Mar 2017 at 05:24:22
    Re: Create new SharePoint list item from an email

    Hi, @telu,

     

    So I figured it out, it's not exactly what I wanted but it works, thanks to lots of trail and error arg.

     

    Here's how I got it to work:

    1) Switched to outlook.com app instead of Office 365 email.

    2) Simplified flow (no conditions), no subject filter, no more than 3 dynamic content fields.

    3) Had to make sharepoint list fields required for dynamic content.

     

    I also learned that modifying list and flow would break it. So if you need to make changes, seemed best to recreate flow from scratch every time.

     

    Not sure if these are all best practices, but worked for me.

     

    Thanks for your comments on the connection bit, that helped.

     

    -Pow

     

  • telu Profile Picture
    Microsoft Employee on 04 Mar 2017 at 01:04:04
    Re: Create new SharePoint list item from an email

    Hi Pow,

     

    Could you check using the ...on the right top of the card to see whether the email is using your email connection?

    And could you give me the url of the flow like this: https://ms.flow.microsoft.com/manage/environments/Default-72f988bf-86f1-41af-91ab-2d7cd011db47/flows/9a17e8cf-4a4c-4cc6-aaac-ed53a227beb5  for further investigation?

     

    Thanks

  • Community Power Platform Member Profile Picture
    on 03 Mar 2017 at 22:51:51
    Re: Create new SharePoint list item from an email

    @telu

     

    Not sure if it will help, but the flow is "skipping," looks like it doesn't get past the first "when new email arrives" step.  I get the below output when reviewing the "Checks (no new data)" log:

     

    { "Pragma": "no-cache", "Retry-After": "15", "x-ms-request-id": "542dcca4-6cb3-45ca-b451-74fd9ccda39e", "X-Content-Type-Options": "nosniff", "Cache-Control": "no-cache", "Date": "Fri, 03 Mar 2017 22:41:51 GMT", "Location": "https://msmanaged-na.azure-apim.net/apim/office365/shared-office365-7e49fe8e-0919-4381-ab4f-2873addae225/Mail/OnNewEmail?folderPath=Inbox&LastPollInformation=eyJMYXN0UmVjZWl2ZWRNYWlsVGltZSI6IjIwMTctMDMtMDNUMjI6NDE6NTEuODYzNzA1KzAwOjAwIiwiTGFzdE1lc3NhZ2VJZCI6bnVsbH0%3d", "Set-Cookie": "ARRAffinity=b72875202f78b3207e210dacc3385d4360e0779d57c0c23d1a3e3f5fd0a63571;Path=/;Domain=127.0.0.1", "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0", "X-AspNet-Version": "4.0.30319", "X-Powered-By": "ASP.NET", "Content-Length": "0", "Expires": "-1" }

     

    Because I am not using SharePoint Online, rather on-premise, do I have any pre-requisistes in terms of authorization or gateway that I should set-up before trying flow in general?  I did get another flow to work, a template, where I get an email notification when a new SharePoint list item is created fyi.

     

    -Pow

  • Community Power Platform Member Profile Picture
    on 03 Mar 2017 at 22:28:47
    Re: Create new SharePoint list item from an email

    Hi @telu,

     

    I think so yes, but I have created something already very similar and I am not seeing new items being created in the SharePoint list when testing.  The connection to the SharePoint Site URL and list seem to be valid, no errors, so I am confused as to what specifically I may have done wrong.  Can you help me understand more specifically how you created it?  When I go to the infomation on the flow, no new emails have run successfully or failed, all are skipped.

     

    -Pow

  • telu Profile Picture
    Microsoft Employee on 03 Mar 2017 at 20:29:42
    Re: Create new SharePoint list item from an email

    Hi @Anonymous,

     

    I have created a flow that When received email-> add item in sharepoint list. And the from and to email can go to the sharepoint list.

    Does it meet your need?

     

    email_spo.png

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,743 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,089 Most Valuable Professional

Leaderboard
Loading started