Skip to main content

Notifications

Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Using Flows / Please help with 'Send...
Power Automate - Using Flows
Answered

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

(0) ShareShare
ReportReport
Posted on by FZK 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!

 

  • FZK Profile Picture
    FZK 18 on at
    Re: Please help with 'Send a customized email when a new SharePoint list item is added'

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

     

  • FZK Profile Picture
    FZK 18 on at
    Re: Please help with 'Send a customized email when a new SharePoint list item is added'

    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

  • Verified answer
    annajhaveri Profile Picture
    annajhaveri 8,531 Most Valuable Professional on at
    Re: Please help with 'Send a customized email when a new SharePoint list item is added'

    @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'))

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

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸
Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,658 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,999 Most Valuable Professional

Leaderboard

Featured topics

Restore a deleted flow

Product updates

Microsoft Power Platform Community release plans