Flow runs successfully, but item level SharePoint list permissions not updated as it says they have been

[TinTinKatie]

Hi, this is my first ever post but I have found these forums invaluable for advice when needing an answer to an already answered question in the past. 

I am having a problem I don't understand. I have a flow which adds entries to a SharePoint List based on entries from another on a scheduled basis and then adds specific permissions to each item, for the staff member on the item to be able to edit, and the manager to be able to view.  This is as the list is used in a power app. 

Recently, having worked fine in the past, the flow has stopped accurately updating the permissions. It adds the entries, but doesn't update the permissions. However, when I check the flow history, it says it has run successfully for all items. 

To test the issue I created a new flow using the same steps (Grant access to an item or a folder) and used the get items function to get a set of items from the list and update them. This also seemed to work at first, but at the third attempt (I filtered by ODATA and checked each set once it had run) despite the flow being successful, the permissions again hadn't all been changed- some items were and some weren't, with no obvious pattern. 

I just can't work out why it's doing this?

TIA for any help, this is doing my head in!

[creativeopinion]

@TinTinKatie Could you post a screenshot of the flow you are having issues with? In the meantime you might be interested in this YT tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

[TinTinKatie]

Thank you so much for your suggestions and help. In the end, I copied the flow and deleted the old one and it is working absolutely fine now- very bizarre!