I have a flow set up to create a sharepoint item and attach an email, whenever an email arrives. It works sometimes and not others. Every time it fails, I get this error. Below is a screenshot of my flow as well.
Can anyone help me?
Thanks for providing the detailed error message.
From the screenshot, it seems action Add attachment2 is being used to save email attachments to the list. While the error message says that the provided value is of type ‘Null’. Please make sure the email arrives does contain attachments.
If an email without attachments arrived, the dynamic contents Attachments Name and Attachment Content will return null value, then the error message would be returned.
Please enable Yes for both Has Attachment and Include Attachments fields so that the flow would be only triggered when an email with attachments arrives.
I have made the following test, please check it for a reference.
Thanks Mabel. I noticed yesterday that it looks like the flow will still create a sharepoint item and attach the email, even when there are no attachments and that's exactly what I want to happen. So from what I understand of what you've said below, it's saying its 'failed' because the email doesn't actually have any attachments, yeh? I want all emails to go into the list, so if that's the reason, then it's not actually a problem!
Thanks for updating.
I have reproduced the issue. It seems that when an email with more than 2 attachments arrives, it will return the error message.
Please check the following configuration for a reference. I assume that it will work for you.
My flow doesn't look like yours so I'm a bit confused. I just tested it by sending an email to the shared mailbox with 2 attachments. The flow says that it's failed, but when I check the SharePoint, the email is there and so are both the attachments!
Step 1: When a new email arrives in a shared mailbox
Step 2: Create item in SharePoint
Step 3: Export the email
Step 4: Add attachment
Step 5: Add attachment 2
Whilst I've got you Mabel, how do I make the string return the Melbourne, Australia time usig the UTC expression below? I want the name of the SharePoint item to be the time the email was received, is there another way to get that?
Please try to use the convertTimeZone function which can help convert a timestamp from the source time zone to the target time zone.
Please check more details about the function at here:
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!