web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error during 'Apply to...
Power Automate
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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:

bakstage_0-1658309822295.png

 

bakstage_2-1658308199632.png

bakstage_3-1658308275064.png

 

Unfortunately, I keep getting the notification:

 

bakstage_0-1658308038853.png

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,

bakstage_4-1658308742326.png

while those have subsequent folders with specific dates:

bakstage_5-1658308826732.png

 

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!

Categories:
I have the same question (0)
  • David- Profile Picture
    1,254 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 378 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 273 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 135 Most Valuable Professional

Last 30 days Overall leaderboard