Power Platform Community Forum Thread Details

I have a number of SharePoint libraries (about 10) that I'm phasing out. They consist of doc sets for projects and new project library links. The doc sets will be active for at least another year. I have the project library person posting links in the applicable site library after they create one. I'm trying to consolidate the projects to one master SP list so the users can see all their project links and status on one page (without having to go to each library). The flow is triggered by an item being added to a library.

My problem is the flow. A colleague put together a flow for me that would basically add new items from a SharePoint library to a spreadsheet and then pass that value to a SharePoint list. The flow only works occasionally, yet it usually "succeeds". It's designed to filter a spreadsheet and create a row on it, and then pass the data to the SP list. Yesterday, after we got it to work for one library, I tried to copy the flow and save it for a second library, and it has only worked once. The flow says it succeeded, but it actually stops short of writing to the SharePoint list. So at this point I have 2 flows that say they work that don't consistently add to my SharePoint list. The new items do get added to the spreadsheet. I don't know enough to tell what's needed to make this work consistently.

Can anyone suggest something that would make the flow work better? I can keep the trigger as "when an item is added or modified" or switch to a scheduled trigger. Items are only added a few per month, typically.

Here's the flow. There is no action if the condition returns No.