I have created a workflow to update an Sharepoint List by deleting old forecasts and adding new forecasts and latests results.
The trigger is a chat message on a specified Teams Channel including a keyword "Update Data."
When I turn it on and post a message to the channel myself, it works fine.
But in other cases involving other owners of the Sharepoint List, the workflow runs always fail at the "For each loop" of deleting items
from the List. And the error message is so simple as this to find the cause of the error:
ActionFailed
An action failed. No dependent actions succeeded.
The reason why I am always successful seems I am the creator of the items of the Sharepoint list, while others fail to delete items
of my creation. But all the workflow executors are given the same rights to edit the list.
Please advise,
Hisao