Solved

Sharepoint workflow on list

Posted on 2016-10-04
6
29 Views
Last Modified: 2016-10-20
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
  • 2
6 Comments
 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
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 14

Accepted Solution

by:
SneekCo earned 500 total points
Comment Utility
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 8

Author Comment

by:Koen
Comment Utility
that might work as a last resort...if it boils down to doing that, I'll grant you the points...
0
Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
Good luck, more important than points is your success!
0
 
LVL 8

Author Closing Comment

by:Koen
Comment Utility
Not ideal but probably the best workaround
0
 
LVL 14

Expert Comment

by:SneekCo
Comment Utility
Thanks, good luck...
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

We had a requirement to extract data from a SharePoint 2010 Customer List into a CSV file and then place the CSV file into a directory on the network so that the file could be consumed by an AS400 system. I will share in Part 1 how to Extract the Da…
I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now