Sharepoint Output Error

[kathleenvance]

I am creating a flow where I am pulling from a daily file from a sharepoint site, with no issue. With no issue when I able to appropriately adjust the data. However, when attempting to do a sharepoint output, I am getting this error: "Error: SharePoint Output (38): Error: 'NoneType' object has no attribute 'fillna". BUT only sometimes. 

There is no discernable differences from each file (files are systemically ran as well from a quickbase program so formatting should be the same as well). There should be about 3200 lines that are output, I have looked at the data and there doesn't seem anything funny looking. but is just sometimes when the data fails to output. I did try to output to a local drive and it will. I also attempted to save the failing sharepoint file to a local drive and it will output via a sharepoint file as well.

So what can I do to always output the data? There is very little I can change in the input.  It should come from sharepoint and the output should be a sharepoint site as well. 

[dreldrel]

Did you run the exact same workflow, and the error only pops up occasionally?

[Dean4U]

Hi @kathleenvance,

Thanks for reaching out to us. This issue usually occurs when the connector receives no rows for at least one sheet, or when the sheet name value is null/blank or invalid (Excel sheet-name rules). Consequently, an internal step attempts to operate on a 'None'.

I also saw reports of intermittent failures on overwrite and permission blips that present inconsistently in the below KB link:

https://knowledge.alteryx.com/index/s/article/SharePoint-Output-error-file-name-or-file-name-by-fiel...

The error might occur when the connector encounters a missing/invalid sheet target or no rows and attempts to treat it as a table. You can try to check for uniqueness and skip zero-row cases by removing all paths that produce 'None' internally, while keeping your existing SharePoint configuration intact.

Let us know if this info and the KB article help you out.

Take care.