You’re offline. This is a read only version of the page.
Announcements
17
Hi everyone,
I would like to create a flow that get every items created on a Sharepoint List in the past 30 days and send an email with the datails about them.
I've tried with "Get items" function but I can not get it work.
Thank you.
We can use a number of actions to get the current time in the local time zone, and then calculate the date 30 days ago:
We can then use the current time and the calculated time in the Get Items filter query. We search for items that have a created date greater or equal (ge) to the calculated time (30 days ago), and with a created date less than or equal (le) to the current date:
Next, we use the Select action to select the columns we want to include in the email, the results from the Select action are converted in to a HTML table and then emailed:
You can refine the content of the email (such as formatting the dates) or add some HTML styling to improve the look of the HTML table.
Hope this helps.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Share
Report
All responses (
Answers (
