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 / Send weekly email with...
Power Automate
Unanswered

Send weekly email with attached link to last modified item in a SharePoint Folder

(0) ShareShare
ReportReport
Posted on by 3

Hello, 

 

This is my first time posting in here, and I'm fairly new to using PA. 

I have recently been asked to send an weekly email (every Tuesday at 1 pm) containing a link to a file (PowerPoint). This file is located in a SharePoint folder, that contains all the previous weeks PowerPoints. I want to automate this task as I have already forgotten to send the email a few times, and the way I have tried to this is the following: 

FsraL_0-1707815295152.png

The Recurrence parameters looks like this: 

FsraL_1-1707815348129.png

The Get Files (properties only) parameters looks like this:

FsraL_3-1707815467449.png

The For each parameters looks like this: 

FsraL_5-1707820952309.png

 

and finally the Send an email parameters looks like this:

FsraL_4-1707815550764.png

 

When I use the flow checker it says that No errors are found but when I test the flow, I get the error BadRequest. but I dont know what to do to fix it.. So is there anyone that can help me with this?

 

 

 

 

Categories:
I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,091 Super User 2025 Season 2 on at

    Hi @FsraL 

     

    In 'Order by' parameter, pls pass the internal name instead of 'LastModified':

    Modified desc

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

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…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard