Alteryx Designer Discussions

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

SharePoint Input Tool - SharePoint Online

DanielG
9 - Comet

Hi,

 

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.

 

Dan 

4 REPLIES 4
JakeS
Alteryx Alumni (Retired)

Hi @DanielG 

 

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

 

SPAppOnly.png

 

Can you make app credentials for your process? 

 

Jake Samuels

Principal Support Engineer
Alteryx, Inc.
DanielG
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!!!

 

 

sean_bolte_dup_544
8 - Asteroid

@DanielG 

 

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.com/sites/sitename(your 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 "www.localhost.com" for App domain and " https://www.localhost.com" for Redirect URI as shown in the screenshot.

Step5.PNG

6. Click on create as shown in the screenshot.

Step6.PNG

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

Example - https://(your company name).sharepoint.com/sites/sitename(your 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.

Step8.PNG

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.

Step_9-5.PNG

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

Step10.PNG

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 !! 

 

 

DanielG
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.  🙂

Labels