Flow when email with attachment arrives, create file in SharePoint library stopped creating file suddenly

[RSwork]

Hi All,

I created a flow to monitor a shared mailbox and when and email with an attachment from specific email address arrives the flow uploads the attachment to the SharePoint library and send notifications that a file with IDxx and filename xxxx has been uploaded.

The specific emails (with an attachment) is received once a day, so the flow runs once a day. The attachment is an .xls file.

The flow worked fine while testing and now after I have published the flow live, it run 12 times doing what is supposed to do.

Suddenly today the flow should've uploaded the 13th file, but it did not happen, although the flow result is success at first part.

The flow history showed that flow run OK  - no error messages.

But when it came to "Apply to each" action - uploading the attachment and then sending the notification after that, those actions are dimmed and no results:

I tried to resend the same email with the attachment again to the shared mailbox and the same result - did not create the file.

I uploaded the attachment manually and it uploaded successfully to the SP document library- so it is not the file the problem.

From previous history of the flow I see that there are 2 results per flow run within couple of minutes - one picks up the email with the attachment, second creates the file on Sharepoint from attachment:

First flow result:

And second part result:

"Create file" raw inputs:

Create file Inputs:

{

    "host": {

        "connectionReferenceName": "shared_sharepointonline",

        "operationId": "CreateFile"

    },

    "parameters": {

        "dataset": "https://xxxxxxxxx.sharepoint.com/sites/InfoPack",

        "folderPath": "/InfoPacks",

        "name": "2021-07-24T10:30:15+00:00_InfoPack.xls",

        "body": "0M8R4KGxGuEAAAAAAAAAAAAAAAAAAAAAPgADAP7/CQAGAA..........."

    }

}

Today, there is just the first part run in the history (see above). The second part did not happened - as per screenshots above.

I'm not sure what happened or aware if anything happened so the flow suddenly to stop creating the files in SharePoint - nothing has changed since before, no error messages ( I have an error notification set up in the "If no" branch). And why it run OK 12 times and then stop?

Any help, pls?

[eliotcole]

Not sure based on this, but you might want to look at SharePoint errors in the admin console, as they might hold more information on this.

We might need to see more of the flow, what the full conditions, and failure captures are. Additionally, is the user account that you used to upload the file to SharePoint the same account that runs the flow?

[RSwork]

Hi @eliotcole - thanks for looking.

I cannot see any errors in SharePoint Online. The service account running the flow is a site admin and site owner and also co-owner of the shared mailbox - so permissions should be OK.

Here how the flow is built:

Trigger:

IsFromFilterApplied variable:

Condition to apply "From" filter:

"If yes" side:

If the email is from specified email address in the condition above then "Apply to each" create the file and send notification:

Yesterday it failed on Create file action and did not send the notification after that.

The flow should be triggered again today at 11:30-ish today. will monitor it again.

Here is the history again:

Pls let me know if you need any more info.

Thanks again

[RSwork]

Here is the SharePoint Online document library:

[Powerplatform01]

Hi @RSwork ,

You can watch this video to resolve your issue,

https://youtu.be/GA_f5GX5H-Q

Please subscribe and like the video if it's resolve your issue

[eliotcole]

That's some good info, @RSwork , thank you!

I'll look in to it soon, and post back. 👍

[RSwork]

Hi again @eliotcole ,

Funny bit is that today at 11:34 the flow run as it should, as there was a new email send to the shared mailbox with the required attachment - and guess what - it run successfully and uploaded the attachment as a new file on SharePoint site.

How bizarre?!

Still not sure why it failed to create that file yesterday... 

[RSwork]

Hi @Powerplatform01 ,

Thank you for pointed to that video.

I have created my flow in a more simple way, but with conditions that the flow will process emails sender from specific sender, with specific keywords in subject line and also must have attachments.

Ans it worked great including today - except yesterday and still unable to find out why.

Best,

RS