OneDrive Output problem - Selected extension does not match with file

rfoster7

I am using OneDrive Output (tool version 2.2.1) It's been working. I have a workflow that worked yesterday and is failing today with the following error:

Selected extension does not match with file extension.

The tool is configured to use a field [File Name] for the name of the file to output. 

Is is configured to process the file as a CSV

And the filename is coming into the tool with the .csv file extension

As I said, it was working fine yesterday, then just stopped.

Nothing changed in the workflow. It fails both on Gallery and in Designer.

I have tried deleting and recreating the OneDrive Output, I've tried changing it to xlsx and yxdb. I've tried sampling a few different data to make sure it wasn't just bad data. Nothing seems wrong and it fails out even when I create a whole new workflow. 

Anyone have any experience with this error? It's NOT just me trying to write filename.xlsx as a csv or vice versa, that's already been checked. 

rfoster7

This problem is resolved. For anyone who finds this by searching for similar issues, the fix was that the Field that you feed into the OneDrive Output that contains the "file name" you want to name the new file can't have a space in it. So changing the field "File Name" to "File_Name" fixed the problem. Not sure why it worked originally with the space, then stopped working. Perhaps something happened to the XML by the process of saving to the gallery and reopening it? Can't really say.