Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Sharepoint Output error

a4665zz
5 - Atom

I am getting the error "The columns are different in file..." trying to use Sharepoint Output tool to output to different tabs in the same Excel file on Teams. The other Sharepoint Outputs work fine, but this one continues to throw this error. In general, the Sharepoint Input and Output tools seem quite buggy.

 

a4665zz_0-1652804091820.png

 

2 REPLIES 2
oly
Alteryx Alumni (Retired)

Hi @a4665zz,

Is that an existing page that you are updating? Do the fields line up in the exact order?

 

Make sure you are using version 21.4 - there were many good changes/fixes in Sharepoint tools. To narrow down the problem - use Select tool to divide and concur: Keep say first half of the records only, and see if that works. Then continue to divide on the half that's not working.. I've seen issues for example with completely empty columns. Sorry, no exact solution, you have to go trial and error with your data.

Best,

Oly

ELLobo
5 - Atom

Hi,

 

Great workflow you have there!

 

 I been trying to write to a SharePoint Online Excel file like you are presenting, would you be able to share on how you made this possible please?

 

thanks,

 

Ed

Labels
Top Solution Authors