So I have a list, and that list is employees and their data. There is a workflow created to update fields in this list with data from Active Directory. Stuff like their job title and work phone and whatnot.
This workflow runs on item creation and item change, which is great.
However, I want it to run on the item once a day at 1 AM or so. So if AD changes are made, it propagates.
So I saw this: Schedule a workflow to run everyday
But the solution seems to be "create an infinite workflow". This would be bad to create an infinite one for each list item, I imagine.
Is my only option to run a powershell script on a scheduled time or something? If so, I'm going to have to work with an admin team to do it. Is that better than this kludge?