SharePoint Input Tool - SharePoint Online

[DanielG]

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 

[DanielG]

There is also a SharePoint File Input Tool which should be able to handle it in one shot.  Would still need the Client ID, Secret and Tenant though.

This post has evolved a whole lot since the original question I asked 3 years ago...  😂

[Magneto_]

Did you ever solve this?

[DanielG]

@Magneto_  I have since changed jobs, but I think we were able to find the corresponding email address for that BatchID and then granted it permissions to the SharePoint list.  However, I dont recall the specifics at this point.  Sorry.  It will probably require some work with IT to find batchID's email or the creation of a batchID that has an email address to start.  Make sure you work with IT to avoid violating any rules on data access (depending on what type of data work you are doing ie PPI data.)

[NatSnook]

Hi @DanielG or @sean_bolte_dup_544 this solution works perfectly for sharepoint lists. however sharepoint files seem to be a different animal.

do you know of a solution to complete similar excersice for sharepoint files?

[DanielG]

@NatSnook -- sorry.  I am a bit removed from Alteryx these days but I do know the permissioning is the hardest part to figure out initially.  Ideally you are using SharePoint Online these days, as I think that is easier to deal with.  Set up your DCMs for SharePoint input and output then use those in setting up your workflows.  I believe allot has changed with SP and the SP Alteryx tools in the 5 years since this was originally posted, so I am not sure what is relevant or not any more.  I'd consider asking a new question in community to get the most up to date information from people who are more actively using it.  I dont know the other person you linked on your message, but it looks like it has been 4 years since they logged in.  :)