Hello!
I've been working on this problem for a little while now and could use some advice.
I have a workflow and one of the steps requires assignment to one member of a list of employees.
The V7 Workflow I am converting from had a list field that was update by hand when there were changes in employment, etc.
I'd like to automate this for the new process.
At first I thought "Dynamic field" but my source is not in SQL. I'll go there if I must, but I'm looking at all my options.
I thought I almost had it licked, too. I had this little piece of workflow:
Where "Find Group" searches for the group in question in the AD. This would add any new users to the list, and I would set this to run periodically. This was fine but for two issues:
- The list was not alphabetical. This is the big issue for them.
- The field isn't updated for deletes.
I suspect that #2 is just not possible in Workflow as it stands - the only activity to affect list fields is the "Append list field Choices." So, no direct manipulation, removing, etc. I can live with not deleting users from the list
But... I wonder if #1 isn't possible with Scripting.
So... I suppose that is one of my questions - can you, with scripting, sort the values in a list field? I'm starting to look through the SDK docs, but I'm not sure if the "Sort" function of the client is done as a sub or done "by hand."
And then, jumping back, is there an easier way to pull an AD group into a list field?
(Sure would be nice to have Active directory/LDAP as another source for Dynamic fields... :) )
Thanks in advance everyone!
Mike