How do I manage flow failures with the "extract from email" step?

1. When the failure message says: “The last email fetched did not contain a valid attachment”
   1. Reason: This occurs when you’ve selected “Pull data from email attachment” but then an email has not been sent in with an attachment.
   2. Resolution: Send an email to the provided email address with the correct attachment
2. When the failure message says: “There was a calculation error in “Extract from email”
   1. Reason:  Likely a result of an incorrectly selected file type.
   2. Resolution: This often occurs when an email is sent with multiple types of file attachments (i.e. PDF and Excel file) on the same email. If we are parsing a PDF and ONLY want to parse a PDF, then we can click into the “Extract from email” step and click on “View all flow email settings.” Within there, we can select “Only process.. Files.” In that drop down, we will select the file type we’d want (i.e. PDF).
3. When the failure message looks like: “There was an error parsing your CSV file: Parse Error: expected: ’ OR new line got: ”. at….”
   1. Reason: Likely a result of an incorrectly selected file type.
   2. Resolution: Click into the Extract from email step and adjust the file type (if we support). Most common resolution is that it needs to be parsed as an Excel file.
4. When the failure message says: “Cannot find ‘XX’ sheet in file”
   1. Reason: This occurs when you have set up a Extract from email step to parse a specific tab in an Excel file (i.e. “Open Orders” as the tab name). This error means that it was unable to find an “Open Orders” tab within the Excel that was sent in.
   2. Resolution: Either you need to send in a correct file with that naming convention for the tab you are looking to pull in OR you need to adjust your settings to change from “Sheet name is” to “Position is” and select the position of the tab that you want (1st sheet, 2nd sheet, etc. You can only select one tab).

​

Additional considerations