You did not mention whether your data has a Table in it.
If it does not then your action will fail and it has multiple retries there.
Also, how many rows are you talking about, and did you turn on Pagination?
While I can see this action, I would need to see the proper flow to better understand your entire implementation.
However, as to why you couldn't run the script that could be for many reasons, such as other flows use a connection from someone else and they have permission and or its shared, where as the new one you create does not. It's honestly a handful of things that would need more information to find the root cause.
As for list rows, make sure you have pagination turned on under settings. Make sure you have a Do Until loop around the Apply to each so you can keep looping through each page.
More details on your flow, the data size etc would help.
If these suggestions help resolve your issue, Please consider Marking the answer as such and also maybe a like.
Thank you!
Sincerely, Michael Gernaey
