So I need to schedule an API workflow at the backend
( No front-end action needed, no click the button whatsoever).
So in the backend workflow:
1, I set up a “new database trigger event” called (DAILYRESET)
2, I set up an API workflow called "dailyreset)
3, In the Trigger’s step 1, I’ve chosen dailyreset as the API Workflow , and I’ve set a scheduled date (for testing purpose, I set it just 2 or 3 mins from my current time, so I can observe it).
But so far it is not working, the schedule change didn’t happen, it didn’t show in the log’s scheduler neither.
I’m not sure why you’re using a database trigger event for this?..
But assuming that is your intention (and you understand how Trigger events work)… has the required database change actually been made to trigger the event?
Also, are you sure you want to be running a workflow on a list, which then in turn is making changes to another list? (and what list is it making change to)?
Maybe explain your intended use case here…
also, isn’t it better to set the scheduled date in relation to the current date, for testing purposes (rather than to an arbitrary date)? Otherwise you’ll have to manually change it every time you want to test it.
But Adam, in this post you said I have to trigger it.
1, So where should I trigger this event ? ( I don’t want to have a front-end activity for it , I only want it to happen naturally when the time is mid-night). So there’s no other changes in Database to trigger the event , it is only that “mid-night” (i.e. 12am) the solo factor triggering the workflow
2, Yes I want to run a workflow on all Users when it is mid-night (the workflow is to change one field’s value on all users when it is mid-night)
3, Yes your point on current time is understood and will follow.