Alteryx Designer Discussions

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

SharePoint Input Tool - SharePoint Online

9 - Comet



We have had workflows with connections to a SharePoint List running for year's on our Prod Server because we have used SharePoint 2010 and we can utilize our Batch ID and password to gain access to the list.


We are moving to SharePoint Online and the SharePoint Input Tool's configuration asks for an email address...  My BatchID doesnt have an email address, so I am at a loss for what to do.


Anyone know how to gain access to a list like this with a BatchID in use?


Thanks for any assistance that can be provided.



Alteryx Alumni (Retired)

Hi @DanielG 


There are only two options for connection to SharePoint online - using an email address, or using app creds:




Can you make app credentials for your process? 


Jake Samuels

Principal Support Engineer
Alteryx, Inc.
9 - Comet

I am not sure if I have the capability to create app credentials.  I have never had to do that before, so I will need to work with some of our more technical folks to figure that out.


Thanks for the information!!!



8 - Asteroid



Here is what you do to obtain SharePoint credentials.

1) You need to be elevated to "Owner" status for the site in question.


2) Utilizing a browser, go to your tenant (your company) SharePoint site with the following appended to the end: "_layouts/15/appregnew.aspx"

Example - https://(your company name) SharePoint groups name)/_layouts/15/appregnew.aspx


3. Click on "Generate" for both Client ID and Client secret as shown below in step 5


4. Give title as shown in the screenshot.


5. Give "" for App domain and "" for Redirect URI as shown in the screenshot.


6. Click on create as shown in the screenshot.


7. Add _layouts/15/appinv.aspx at the end of URL in yuor browser

Example - https://(your company name) SharePoint groups name)/_layouts/15/appinv.aspx


8. Give App id which is already generated and click on look up as shown in the screenshot.


9. Repeat 4 and 5 steps for the remaining fields.


10. In Permission box, enter the below code


  <AppPermissionRequests AllowAppOnlyPolicy="true">       <AppPermissionRequest Scope="http://sharepoint/content/sitecollection" Right="FullControl"/> </AppPermissionRequests> 


11. Click on create button.


12. In next dialog, Click on trust it as shown in the screenshot.


13. Now with generated Client Id and Client secret , one can connect to SharePoint Online through app only authentication.


These are what you have to use to be able to pull from a Sharepoint365 list. Make sure that you are pulling the correct View - there are often several ones that have been created by users of the site !! 



9 - Comet

Thanks for writing up that solution.  Much appreciated.


In my particular situation, we realized that our batchID was being blocked by our SSO process, so once we remedied that, the email and password worked.


I had just forgotten to write about it on here until your post reminded me.  🙂