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 / Please help with 'Send...
Power Automate
Answered

Please help with 'Send a customized email when a new SharePoint list item is added'

(0) ShareShare
ReportReport
Posted on by 18

So the actual Flow is not complicated, however I am looking to achieve the following and running into an issue:

 

  • Objective: SharePoint List used as Intake Form for users. The entry sits as 'New' until we change to 'Completed'. 
  • Flow 1: Assign "Intake ID" using 'When an item is created' and 'Update item'. This works and assigns an ID to the entry as REQ00001, etc. The ID field is marked as 'Generating Intake ID' and then changes to 'REQ0000X' once Flow runs.
  • Flow 2: Send e-mail thanking them for submitting the intake, SLA, along with fields such as: 
    • Intake ID: (example REQ00001)
    • Requested Action: (example Add XYZ)
    • Name: (their name)

So whenever I run Flow 2, it generates the e-mail with intake ID as "Generating Intake ID". I tried adding a 'Delay' step and delayed it to 5 minutes to allow for Flow 1 to run and then Flow 2 to capture the field as REQ0000X but it still comes up as 'Generating Intake ID'.

 

Additionally, I haven't tried this yet but I would want a Flow 3 which kicks off and sends an e-mail to the same user + 2-3 more (e.g. their manager) to say the request was completed. 

 

Please help!

 

Categories:
I have the same question (0)
  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @FZK  on the second flow which runs on item update, i suggest that you add a trigger condition as below

    @not(equals(triggerBody()?['IntakeID'], 'Generating Intake ID'))
  • FZK Profile Picture
    18 on at

    Sorry I tried this but did not work. Am I putting this in the first 'When an Item is Created' ? See below my flow

     

    Capture.PNG

  • FZK Profile Picture
    18 on at

    My apologies - I realized after there was a space between Intake and ID so once I added that it works, thank you!

     

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

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard