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

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How to email just the ...
Power Automate
Unanswered

How to email just the new item data created on a SharePoint list

(0) ShareShare
ReportReport
Posted on by

I am a newbie at Automate, I have a SharePoint list that I want an email to be sent whenever a new item is created.  So far I have the bones of the flow created but it's emailing the entire list.  My guess is I need to limit the Get Items or the Select step.

Most of the posts are going into SharePoint, I am trying to go the other direction.

Any help or direction would be great. Rusty

AddUser1.png

AddUser-Get-Item.png

AddUser-Select.png

AddUser-email.png

Categories:
I have the same question (0)
  • efialttes Profile Picture
    14,756 on at
    Re: How to email just the new item data created on a SharePoint list

    Hi!

    You just need the email to include info from the new item, right? If so, you can forget about 'Get items', since it will return all  items in your SP list

    Please confirm if my understanding is correct

     

  • Verified answer
    efialttes Profile Picture
    14,756 on at
    Re: How to email just the new item data created on a SharePoint list

    Wait, wait, wait...

    Forget about removing 'Get items'. Actually it's the fastest way to overcome your challenge, if you don't mind to 'spend' one extra API request. Just filter its results to get one single item -the one that triggered your flow- by adding this ODATA expression in 'Filter query'. Please be aware of the single quotes

    Flow_HTMLTable4OneItem.png

    Hope this helps

  • Community Power Platform Member Profile Picture
    on at
    Re: How to email just the new item data created on a SharePoint list

    Thanks that was exactly what I was looking for!  Rusty

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 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard