Hi all,
I have a strange issue with a power automate flow connecting to a SharePoint list.
In brief:
1. A SharePoint list holds some items. For each new item, a flow is triggered to break inheritance and set explicitly edit permissions to the item's owner only.
2. Then, the owner fills-in some fields and "submits" the list item for approval by invoking another flow. This flow does several things. At a specific point, it removes all permissions from the item, then grants the approver with edit permissions and goes on. It then sends an approval email to the approver.
The problem is that *sometimes* the approver clicks on his approval email to see the list item and doesn't see the list item.
It seems that the previous step of granting edit permissions hasn't worked.
Most of the times it does and the link works as expected.
I haven't found any logical explanation for this behavior, other than some sync issues, meaning that SharePoint may not complete permission changes in a timely manner and the flow has created the approval in the meantime. So I added an explicit delay of 10 min between 2 steps. Nothing changed, the issue occurs sporadically.
To tackle this problem, we cancel the running flow and re-run it and then it magically works as expected.
Any ideas on what to further check?
