Error during 'Apply to each' step / Sending an email to person based on a file name (Sharepoint library)

[bakstage]

Hey Guys!

I'm doing my best to bring into life a much more complex flow than I usually create, so a lot of concerns and failures here.

The concept is the following: flow should run from Mon-Fri at 1 PM and go through the items on SharePoint, checking whether there are any files that haven't been renamed to "...-signed".

The file names consist of several elements: "Repx_UserID_date". In case the above condition is fulfilled, I would like to extract the User ID part, to look for the particular user in Office 365, as well as bring the information on that person's line manager. Those details would be included in an email to that very user.

Currently, my flow looks as follows:

Unfortunately, I keep getting the notification:

as well as the "failed to fetch" error. Therefore is my request for your support, as I have no idea how to proceed further.

I wonder if the Sharepoint library setup is the issue. In the first step, I limited the inputs to one folder only, however the main folder contains months folders inside,

while those have subsequent folders with specific dates:

The file names (reports) that are concerned here, are located inside the above "specific date" folders.

I would truly appreciate your tips to make it work. 

Thanks a million for your help and time!

[David-]

Based on all of your screen shots, I don't think your get files action is actually getting anything since you are limiting it to a specific folder and the two screen shots of your folder structure don't list any files in them. I would change the folder to a folder that contains files or remove that altogether.