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.
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
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
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
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
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
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
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?
Thanks
WarrenBelz
146,743
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,089
Most Valuable Professional