Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

flow to send Email for Onboarding Requests

Like (0) ShareShare
ReportReport
Posted on 1 Mar 2024 08:23:43 by

 First I'm completely new to this and have been tasked with automating a very outdated onboarding process for a very large hospital that onboards approx. 100+ hires a month.  I've successfully automated much of the process utilizing MS Forms for the request which flows into a SharePoint list which i then automates into an Excel Spreadsheet for staff to use to assign HR Reps and Schedule DocuSign Send Outs. I realize the Excel Spreadsheet is just an added layer that isn't needed however the staff prefer it over the SharePoint list and management wanted one list that was a true master in case of an emergency which we've had a few times so we leave SharePoint list inaccessible to everyone except myself and

management.  With that said -  there are 2 important automatic emails that I need to have sent automatically to the requestor and the specified hiring manager for each request we receive 

 

1) an automatic email notifying the Requestor and the Hiring Manager that we recieved thier onboarding request for (name of hire) & (requested hire date)  

 

2) an automatic email notifying the Requestor and the Hiring Manager that the DocuSign packet has been sent to their New Hire and that the assigned HR Rep is  (name of HR Rep)   

Below is an example of the excel spreadsheet - green indicates information that auto populates into from MS forms. Yellow is what our staff enters.  I'm assuming the yellow fields would be my trigger for the 2nd email but for the life of me i can't figure out how to do it. . 

 

2024-03-01_00-15-19.gif

 

 

 

I'm a totally visual person so if you could provide snap shots of what i need to do to make this work i would forever be grateful 

 

thank yo u in advance 

 

  • creativeopinion Profile Picture
    10,406 Super User 2025 Season 1 on 02 Mar 2024 at 17:37:41
    Re: flow to send Email for Onboarding Requests

    @danamarie95020 Not sure how you plan to trigger your automation. I would recommend maybe once a day or maybe every couple hours if you need it to be that frequent. You can utilize the Recurrence Trigger. However, while you are building your flow. I would recommend using a Manual Trigger so you can easily run tests. 

    Excel Table Prep

    The List Rows Present in a Table action does have a Filter Query field, however you can only use a single argument. The Filter Query field also only accepts column names without any spaces.

     

    For that reason. I would recommend adding an additional column to your spreadsheet with a formula that will evaluate your columns and output a value. This value is what you'll use in your filter query. Your formula should include a check for the following:

    • Assigned HR Rep column is not empty (you only want to send out a notification if an HR rep has been assigned)
    • Send out Date column is empty (if it's filled—this means a notification has already been sent out)

    Additional Considerations: Since you are sending out two notifications—you might need to add another column to track when the second notification has been sent out. You may also need another column to indicate when the training needs to take place by—maybe it's calculated from the Start Date?

     

    Note: Adjust the formula to suit your requirements. My formula suits my test list. In my example I'm checking for the following:

     

    • Task Due Date is not empty
    • Assigned To is not empty
    • Notify Date is empty

    If the row meets the criteria above, the Notify column will display a Yes. 

     

    creativeopinion_6-1709400207934.png

     

    Get Your Rows

    Add a Manual Trigger to your flow. You can replace it with the Recurrence Trigger once you've confirmed your flow works and you are ready to go live.

    creativeopinion_1-1709399398591.png

    Add a List rows present in a table action. In the Filter Query field, enter a query that checks for a specific value. In my case it's the Notify column. I'm checking for the rows where the Notify column is equal to Yes. Remember that the value must be entered between single quotes.

     

    Whenever working with Dates and Times in Excel, make sure you select ISO 8601 as the DateTime format.

    Limit the Number of Items Returned (optional)

    Depending on how many items you have in your Excel table, I would recommend limiting the Top Count to a smaller number than the total number of items in your table.

     

    This will increase the speed of your flow runs. Instead of returning all rows from your table—it'll limit the List Rows Present in a Table action to the number entered into the Top Count field. I have a small list—so I've left this empty.

     

    Return Row Count

    Whenever I use a Filter Query in a List Rows Present in a Table action, I always like to return the count of items returned in a Compose action. This is helpful when building a flow and can also be used to troubleshoot your flow.

     

    Insert a Compose action. Add an Expression. Use the length() function.

    creativeopinion_2-1709399430838.png

     

    Select the Dynamic content tab and insert the body dynamic content from the Filter Array action into the length() function.

    creativeopinion_3-1709399445618.png

    Run a test. Review the output and confirm it's correct.

    creativeopinion_7-1709400876227.png

     

    ... more to come. Hopefully this can get you started.

     

    In the meantime, you might find these YT Tutorials helpful.

     

    5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

     

    IN THIS VIDEO:

     How to troubleshoot a false Condition action result

     How to get dynamic content when it isn’t selectable from the list of dynamic content

     How to troubleshoot an Apply to Each action that isn’t looping through

     How to troubleshoot a skipped Apply to Each action

     How to troubleshoot a Filter Query

     How to use a SharePoint yes/no column in a Filter Query

     How to use Compose actions to troubleshoot a Power Automate flow

    How to troubleshoot multiple emails being sent

     How to troubleshoot multiple Teams messages being sent

     

    ------

     

    Send Emails Based on a 📆 Date Column in SharePoint with Microsoft Power Automate

     

    In this Microsoft Power Automate tutorial, I’ll show you how to build a flow that will send a Happy Birthday email to a user based on a date column in a SharePoint list. The SharePoint list also contains a column with a Manager’s name which we’ll use to send a three-day and day of reminder to the user’s manager.

     

    This automation will use the Filter Array action to filter out all SharePoint list items where the user’s birthday is today or in three days. This flow can apply to a variety of scenarios such as:

    📅 Student Birthdays

    📅 Project Due Dates

    📅 Contract/Membership Renewals

    📅 License Expirations

    📅 Client Anniversaries


    IN THIS VIDEO:

    How to Send an Email based on a Date Column in SharePoint

    Using the Recurrence Trigger in Power Automate

    How to Use the Filter Array Action with multiple conditions

    How to Get Dynamic Content from a Filter Array Action

    How to Get a Date Three Days from Today

    How to Create a Dynamic Date Based on utcNow()

    How to Return a Count of Items

    How to initialize and set a variable

    How to use the Send an Email (V2) action

    How to send test emails

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
     

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 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,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started