Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Email sent on the date shown in SharePoint

(0) ShareShare
ReportReport
Posted on by 2

Hello,

 

I am trying to build a workflow for an offboarding request. 

1. when a form is submitted (form has a last day)

2. create a list in SharePoint 

3. if the reason for offboarding is NOT equal to resignation, send a notification email to the specific staff on the employee's last day. 

Here is what I have done so far, but I could not get the last part right. Could someone please assist me? 

mhegge_0-1684516074132.png

mhegge_2-1684516256416.png

The error message I get is...

mhegge_3-1684516373348.png

 

  • wskinnermctc Profile Picture
    6,517 Super User 2025 Season 1 on at
    Re: Email sent on the date shown in SharePoint

    You don't need the "Apply to Each" section of the flow. An "Apply to Each" is used if there are multiple items/values that need to have the same flow actions happen to Each item, like it loops or restarts the steps for each item. Like if you had a SP List of 15 items/rows and used a Get Items action to pull in all of the rows, you could use an Apply to Each to check a value in each row or something. The flow would use the steps in the Apply to Each once for each item, therefore running/looping 15 times.

     

    In your example, you have a single Get Item, so all of your steps would just be for that item and not require an Apply to Each.

     

    So get the steps out of the Apply to Each and try your flow. 

     

    If you are clicking/adding a value in one of the steps that makes the Apply to Each automatically appear in your flow, then you are clicking the wrong thing, or there is something that needs to be looked at further. 

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1