?
Solved

Sharepoint workflow on list

Posted on 2016-10-04
7
Medium Priority
?
57 Views
Last Modified: 2017-04-08
I have created a rights changing workflow for sharepoint online (impersonation workflow)
which works fine when I manually trigger it or when I create new items.
the workflow is bound to a specific list.

However, when I want to upload the data to the list (first time bulk upload from excel), it will not allow me to use the created list (with the workflow).
so the catch 22 is that I need the list to be there for the workflow to be bound to it - so that it kicks in when uploading , but it can't be there to allow the upload...

any ideas ?

- update :

No one?  I can rephrase the question

How do I make a workflow run on all items of an existing list ?
0
Comment
Question by:Koen
  • 4
  • 3
7 Comments
 
LVL 21

Expert Comment

by:Walter Curtis
ID: 41830009
There is no way to make it run on all items of a list with one click, wish there was. There are some different way to do that that involve triggering a work flow when an item changes, but they are tricky to do.
0
 
LVL 21

Accepted Solution

by:
Walter Curtis earned 2000 total points
ID: 41830281
Reading your post again another idea came to mind. This might not work, but if it does, that would be great. Not sure what kind of list you have, but if it is a flat list, you could create the list in SharePoint, switch to the datasheet view, and then cut and paste from the excel file. The workflow would trigger on each item and set your permissions.

I have done this on smaller and simple lists and it works well.

Hope that helps...
0
 
LVL 9

Author Comment

by:Koen
ID: 41831267
that might work as a last resort...if it boils down to doing that, I'll grant you the points...
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 21

Expert Comment

by:Walter Curtis
ID: 41832017
Good luck, more important than points is your success!
0
 
LVL 9

Author Closing Comment

by:Koen
ID: 41852602
Not ideal but probably the best workaround
0
 
LVL 21

Expert Comment

by:Walter Curtis
ID: 41852692
Thanks, good luck...
0
 
LVL 9

Author Comment

by:Koen
ID: 42084695
I ended up solving it by create a vba script in Excel that uploaded the records one by one...thus kicking off the workflow to set the rigths
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question