Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!

Public Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Welcome to the Gallery!

Feel free to migrate your items from the former Public Gallery or post new ones. Got questions? Check out our FAQ!

Comments
Tybo
7 - Meteor

@VojtechT  Thanks for the reply. Upgrading is my next battle. I'm not on the IT side so I do not have visibility to the server side but is upgrading easy and relatively painless as far as having to re-do workflows, macros, etcetera?

MartWClimber
8 - Asteroid

@VojtechT, good to know that 21.3.4 is a hard requirement. then I will stick to the V1.1.1 version.

about the other question

do I understand correctly that you actually did provide the Client ID, Tenant ID and Client Secret values, but when your wf is saved, those values are not present? 

Yes I provided the V1.1.1 tool and later the V2+ tool variant with a Client ID, Tenant ID and Client Secret. after checking the saved WF it was gone. hence my Question if it was even tested because this is some unexpected behavior and that this, in my opinion, should not happen when tools are released and this bug (if it is a bug) should be found by testing the tool 

 

Hi @MartWClimber ,


the 21.3.4 is really a hard requirements, because it relies on a piece of code that is not present in the 21.3.3 Designer. 

And for the first question - yes, it was indeed tested. Do I understand correctly that you actually did provide the Client ID, Tenant ID and Client Secret values, but when your wf is saved, those values are not present? 

 

GloriousWater
8 - Asteroid

@MartWClimber Following above discussion. I'm experiencing a similar issue with tokens not being saved, but with  tool version 1.0.4 on Alteryx 2021.2.
In my case, the internet browser login tokens are saved with the workflow, until i run/open the workflow on a different computer/server, then the fields are blank and i need to manually reauthenticate. 

ben_hopkins
7 - Meteor

What is the limit to the number of Document Libraries read within a Site and is it possible to override the limit? If there is no limit, what is the reason that some Document Libraries would not be read?

 

Regards,

Ben

QuantumViridis
7 - Meteor

My goal is use my workflow to overwrite a tab of an Excel workbook stored in Sharepoint.

 

I am using version 2.1.0 of the SharePoint Files Output in Designer 2021.4.  I appear to be authenticating properly, as I can select the XLSX file in the configuration.

 

I do not see the option "Overwrite (Sheet)"

Capture.PNG

 

Trying "Append", I am am unable to get new content into the XLSX file.  I have tried both providing the name of a tab that does exist, and a name for a new tab.

 

Anything I should try?

franc1s
8 - Asteroid

I just installed the latest version that is available for the sharepoint files tool (2.1.0).

 

I have admin rights on my pc, so, my thinking is that this message relates to something else. Im connecting through the "sign in via internet browser" option. What admin access is required?

 

franc1s_0-1655890028674.png

When I connect through "Connect to url through windows account", I am getting the following error.

 

Failed to connect to SharePoint
Failed to connect to Sharepoint. Check the provided information and try again.

Error Code 403

 

 

When I connect through "Connect to url through username and password", I get this error.

 

Failed to connect to SharePoint
Failed to connect to Sharepoint. Check the provided information and try again.

Error Code 401

 

I have full access to the lists I am trying to access.

 

Can someone give me some clues as to that might be missing in terms of the access?

 

Thank you.

ben_hopkins
7 - Meteor

@franc1s , I had to get the IT team here to help with the sign on through the browser and it took some working out; the SharePoint permissions have to be set appropriately.

ben_hopkins
7 - Meteor

Dear @AlteryxProducts ,
The SharePoint output tool seems to overwrite a file in all circumstances, even when the dropdown box is set to append or rename. The circumstance in question is one where there is a SharePoint output tool working within a batch macro that reads a sheet in a local workbook that has many sheets and saves that data in an identical file on SharePoint. It sits within an ETL procedure. Please advise.

Rahul3
8 - Asteroid

@ben_hopkins @franc1s can you tell me what exactly IT team had to do in order to resolve the "Need admin approval" error. I'm also facing the same issue and I would like to know the reason for this before explaining this to IT team.

vickyblueice
5 - Atom

Hi all, 

I am trying to connect to SharePoint Files Input Tool through "Sign in via Internet Browser". No matter how many times I click on connect nothing happens, I also tried other authentication methods none of them work. Pls help!

smoskowitz
12 - Quasar

@vickyblueice --

 

Make sure you aren't blocking pop-ups. That happened to me.

 

Thanks,

Seth

ben_hopkins
7 - Meteor

@Rahul3 

 

Unfortunately, I can't, as it was IT who worked through it. All I know is that they had to 'allow' access to SharePoint on the SharePoint side. I suggest you involve IT as soon as possible, if you can; if not, get in touch with your Alteryx Support directly.

 

 

 

PeterAP
8 - Asteroid

Hi

 

I've just installed the sharepoint files and connected via internet browser which enables me to select the file I want to import, however, I get the following error when I try to run it.

 

pythonerror.JPG

lina_ayre
5 - Atom

[deleted]

lina_ayre
5 - Atom

@VojtechT Does the Sharepoint Files Input tool  have functionality like the Directory tool to pull multiple Excel files from the same directory (folder in SharePoint)? I am hoping to find a workaround to replacing a mapped OneDrive shortcut tied to my user account since updating to UNC did not work. Ultimately, I want other users (who do not have Designer) to be able to run the workflow. However, I am stuck and getting errors when running in the Gallery / server. Any other ideas?

ben_hopkins
7 - Meteor

I can answer this: yes. Like the directory tool configuration, the SharePoint Input tool would read a list of filepaths from a folder and its subfolders then those filepaths would be run through a batch macro's control parameter into another SharePoint Input tool that would input the actual data. This can be done for Excel files with multiple sheets in the same way. 

 

Incidentally, the SharePoint output tool works the same: a list of output filepaths can be fed into the SharePoint output tool and the output tool will save those to the various locations.

GloriousWater
8 - Asteroid

@AlteryxProducts 

 

Just gonna try again, as this was not answered previously.

 

I'm using version 1.0.4 of the tool and server version 2021.2


Authenticating with "Sign in through browser" which works. I can save the workflow on a fileserver, reopen it on the same computer, and run it without having to reauthenticate.

If I then login to my server, and open the workflow with notepad, the access and refresh token / metadata for the tool is there, but when I open the workflow in Alteryx, I can no longer see it in the tools XML. Its like the tool has reset and it requires my to re-authenticate/sign in through browser. 

 

Upon opening the workflow, and looking in the XML editor (not the tool specific xml), the access/refresh token is also there, but as soon as I click the SharePoint tool, it asks me to reauthenticate, and the tokens are wiped from the xml.. 


If I try to save the workflow on the gallery and schedule it, I get the "failed to authenticate" error, which is consistent with the tool resetting when opened on a different computer/server than what initially authenticated it. 



Can you please advise?

franc1s
8 - Asteroid

The questions around accessing sharepoint through the tool seem to cause many of us headaches in a corporate environment. I believe this needs to be addressed soon. In fact, for us it is a mayor obstacle in the further deployment of Alteryx.

ben_hopkins
7 - Meteor

@GloriousWater to get this tool to work on the Alteryx Server, the process I follow is to log in to the computer that the Alteryx Server is installed on (in our case, this involves accessing the Microsoft Virtual Machine via Remote Desktop) configure the workflow and authenticate the appropriate SharePoint connections, including those within batch macros, then save the workflow and packaged macros to the Server. Saving from the computer where the Server is not installed has always caused the 'failed to authenticate' error.

 

@franc1s is right, some assistance from @AlteryxProducts @VojtechT is long overdue. Nevertheless, Franc1s, your post from three weeks ago is solvable. The problem is that SharePoint is not authenticating the app connection. I have been through it myself by working with the administrators of the SharePoint instance to ensure that connections made by the Alteryx app are allowed. After they had made the appropriate changes at their end, the authenticator has worked excellently. 

GloriousWater
8 - Asteroid

@ben_hopkins Yeah, so I was lowkey hoping that I would not have to manage all workflows going to utilize the sharepoint input and reauthenticate them every x months for every user out there :) 

ben_hopkins
7 - Meteor

@GloriousWater It is difficult working with Alteryx. I think the main thing is that this isn't "official" functionality of Alteryx at this point  - in that it isn't included in the base product. We all have to be prepared to carry quite a lot if we want to get the software to the point that we're all hoping for. 

VojtechT
Alteryx
Alteryx

Hi @GloriousWater , I am completely with you. That's why the next version coming in 22.2 supports DCM, so the tokens are re-used and stored separately from the workflow, so once it expires, you can actually re-authenticate just once and that's it.  

VojtechT
Alteryx
Alteryx

Hi @PeterAP , that error seems like something got wrong during installation. Can you remove the connector from Appdata\Alteryx\Tools - all folders with "Sharepoint" in them and install the connector again? 

VojtechT
Alteryx
Alteryx

Hi @vickyblueice , that sounds like combination of incompatible versions of Designer and the Sharepoint Connector. Please check https://help.alteryx.com/designer/designer-compatibility-data-connectors#1aapfv-accordion . 

VojtechT
Alteryx
Alteryx

Hi @franc1s   and @Rahul3 , 

usually  this dialogue comes with input field to provide a justification and button "submit" to send request to your admin to approve the app. But that is happening only when the app is not approved yet. When that happens, only the subset of permissions required for that particular connector are approved. 

So next time you use different connector using the same oauth app, it's not asking for app approval anymore, but it requires some new permissions to be approved, but the screen doesn't provide the Submit request button anymore. 

 

There are 2 ways how to fix this: 

1) the easiest way is to let your Azure/Security admin log in via the "Have admin account?", e.g. via Remote control during Teams call. 

2) The other option is to ask your Azure admin to go to portal.azure.com -> Enterprise applications -> find Alteryx Analytics Connector and add the permissions the connector requires manually and grant them for the whole tenant. The permissions required are listed at each connector's Help page. The Delegated ones are sufficient. 

VojtechT
Alteryx
Alteryx

Hi @QuantumViridis , is it possible that you have multiple versions of sharepoint connector installed and for some reason this is not the latest 2.1.0? You can find out by investigating the xml of the workflow. 

VojtechT
Alteryx
Alteryx

Hi @mmonzon , we tried to replicate the issue, but are not successful - when we create a View filtering records and then select the View in the Sharepoint connector, we do get the results set limited only to the filtered ones. Could you please raise this with Customer support at support@alteryx.com ? 

mranade
5 - Atom

Still new to Alteryx. I installed the current version, realized my Designer is not compatible with it. So I downloaded and installed the 1.1.1 version. However, the SP File O/P version remains v2.1, the SP FIle Input version is now v1.1.1.

 

Any ideas how I can use SP FIie O/P v1.1.1?

MichelleL
Alteryx
Alteryx

Hi @mranade  - if you have multiple versions of a tool installed, you should be able to right click on the tool after you've dragged it onto your canvas.  From there you can choose the version of the tool.  See sample screenprint below:

MichelleL_0-1660069979926.png

 

ben_hopkins
7 - Meteor

Dear @AlteryxProducts,

@VojtechT 
The SharePoint output tool seems to overwrite a file in all circumstances, even when the dropdown box is set to append or rename. The circumstance in question is one where there is a SharePoint output tool working within a batch macro that reads a sheet in a local workbook that has many sheets and saves that data in an identical file on SharePoint. It sits within an ETL procedure. 

 

Is that normal behavior?

 

Kind regards,

Ben