{"id":110813,"date":"2017-04-14T06:43:56","date_gmt":"2017-04-14T13:43:56","guid":{"rendered":""},"modified":"2025-06-11T08:14:42","modified_gmt":"2025-06-11T15:14:42","slug":"managing-new-hire-onboarding","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/managing-new-hire-onboarding\/","title":{"rendered":"By Industry – Human Resources: Onboarding made easy"},"content":{"rendered":"

In this post, we\u2019ll walk through a new hire onboarding scenario. We\u2019ll use Flow to manage new hire information in Excel and SharePoint, then send emails to department heads when their employees are ready to start. Along the way we\u2019ll use some cool features in Flow, including: running a flow on a schedule; applying an action to each row in an Excel file; testing for multiple conditions in our data; and using a switch case<\/em> statement to control who we send email to.<\/p>\n

Reviewing data in Excel and SharePoint Online<\/h2>\n

In this scenario, Bill (one of our HR reps) likes to track everything in Excel, but other folks like to use SharePoint Online. Flow keeps everyone happy! Bill can maintain his Excel file, and Flow ensures that the right information is periodically added to a SharePoint list. The following table shows Bill’s data in the New Hires Excel file. You can copy this data if you want to follow along.<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

FullName<\/b><\/p>\n<\/td>\n

\n

Department<\/b><\/p>\n<\/td>\n

\n

HireDate<\/b><\/p>\n<\/td>\n

\n

Status<\/b><\/p>\n<\/td>\n

\n

AddedToList<\/b><\/p>\n<\/td>\n<\/tr>\n

\n

Angel Garcia<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/3\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Aubury Smith<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/17\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Bharat Mirchandani<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

4\/5\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Christine Koch<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/10\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Eduard Dell<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

3\/10\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Eric Gilmore<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

4\/3\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Gail Erickson<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

3\/9\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Isaiah Langer<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

3\/13\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Greg Akselrod<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

3\/15\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Hatim Aiad<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

4\/10\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Heidi Steen<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

4\/6\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

No<\/p>\n<\/td>\n<\/tr>\n

\n

Jamie Campbell<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

4\/6\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

No<\/p>\n<\/td>\n<\/tr>\n

\n

Jason McCue<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

3\/20\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Jesper Herp<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/22\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Judy Lew<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

3\/17\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Julia Ilyina<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/24\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Justin Harrison<\/p>\n<\/td>\n

\n

Finance<\/p>\n<\/td>\n

\n

3\/23\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Kamil Amireh<\/p>\n<\/td>\n

\n

Operations<\/p>\n<\/td>\n

\n

3\/20\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n

\n

Kim Abercrombie<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

4\/3\/2017<\/p>\n<\/td>\n

\n

Pending<\/p>\n<\/td>\n

\n

No<\/p>\n<\/td>\n<\/tr>\n

\n

Vivian Atlas<\/p>\n<\/td>\n

\n

Sales<\/p>\n<\/td>\n

\n

3\/22\/2017<\/p>\n<\/td>\n

\n

Complete<\/p>\n<\/td>\n

\n

Yes<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The New Hires list has the same data for name, department, and hire date. We don’t include the other two columns here because in this scenario Flow uses those columns to determine which rows to copy to the SharePoint list.<\/p>\n

\"01-list\"<\/p>\n

Building the Flow<\/h2>\n

We’ll look at each step in more detail shortly, but here’s the gist of what we’re building:<\/p>\n

1. Every hour, read all the rows in the Excel table.<\/p>\n

2. Check for rows where the status is complete, and the row hasn’t been added to the SharePoint list already.<\/p>\n

3. For each row that meets the conditions above:<\/p>\n

\n

a. Add a row to the SharePoint list.
\nb. Update a tracking field in Excel.
\nc. Send an email based on the new employee’s department.<\/p>\n<\/blockquote>\n

Now that we’ve seen the data and an overview of the steps, let’s build the flow. If you haven’t built a flow from scratch before, you can check out Create a flow in Microsoft Flow<\/a> first.<\/p>\n

1. At https:\/\/flow.microsoft.com<\/a>, click My Flows<\/b>, then Create from blank<\/b>.<\/p>\n

2. Add the Schedule \u2013 Recurrence<\/b> trigger, then set the recurrence to one hour.<\/p>\n

\"clip_image001[7]\"<\/p>\n

Flow has actions for Excel but not triggers, so we use a recurrence trigger to check our Excel file every hour.<\/p>\n

3. Add a new step, using the Excel – Get rows<\/b> action. Select the Excel file from One Drive, then select the appropriate table.<\/p>\n

\"clip_image002[6]\"<\/p>\n

4. Add a new step, using the apply to each<\/b> loop (under . . . More<\/b>). Select value<\/b> from the Excel dynamic content. Flow will loop through all the rows in the table and check the condition that we’ll define next.<\/p>\n

\"clip_image003[5]\"<\/p>\n

5. Add a new step, using condition<\/b>. By default, you can test for one condition in basic mode.<\/p>\n

\"clip_image004[5]\"<\/p>\n

6. Click Edit in advanced mode<\/b>, then enter the following formula: @and(equals(item()?[‘AddedToList’], ‘No’), equals(item()?[‘Status’], ‘Complete’)).<\/p>\n

\"clip_image005[5]\"<\/p>\n

This condition ensures we only continue to process rows where the status is complete, and the row hasn’t been added to the SharePoint list already. The condition block should look like the following.<\/p>\n

\"clip_image006[5]\"<\/p>\n

Now we’ll add steps for the case where the condition is met. If the condition isn’t met, there’s nothing more to do.<\/p>\n

7. In the Yes<\/b> branch of the condition, add a new step, using the SharePoint – Create item<\/b> action. Select the SharePoint site, then select the appropriate list. Use the Excel dynamic content to populate the fields of the list.<\/p>\n

\"clip_image007[4]\"<\/p>\n

8. Add a new step, using the Excel \u2013 Update row<\/b> action. Use the Row id<\/b> from the Excel dynamic content to identify the row to update, and set the AddedToList<\/b> field to “Yes”.<\/p>\n

\"clip_image008[4]\"<\/p>\n

9. Add a new step, using switch case<\/b> (under . . . More<\/b>). Flow will look at the value of the Department<\/b> field for each row that satisfies the earlier condition. It will then perform a different action based on which department the new employee belongs to.<\/p>\n

\"clip_image009[4]\"<\/p>\n

10. Create a case for each department (Finance, Operations, and Sales). Click ( + )<\/b> to add cases. The default case handles any values that aren’t specified in a case, for example if someone includes a department not usually tracked in the Excel file or list.<\/p>\n

\"clip_image011[4]\"<\/p>\n

11. For each case, add a new step, using the Office 365 Outlook – Send an email<\/b> action. The following images show all four cases, each with a slightly different email sent to a different department head.<\/p>\n

\"clip_image013[4]\"<\/p>\n

\"clip_image015[4]\"<\/p>\n

This is a fairly simple example with different emails, but you could add all sorts of interesting actions as part of each case. The completed flow should look like the following image.<\/p>\n

\"clip_image016\"<\/p>\n

Now that the flow is complete, let’s run it and see what happens. The flow is set up to run hourly, but we will trigger it directly, so we can see the results.<\/p>\n

    \n<\/ol>\n

    Running the Flow<\/h2>\n

    1. Before you run the flow, look at rows 12, 13, and 20 in the Excel file. You see that they all have a value of “No” for AddedToList<\/b>, but only rows 12 and 13 have a value of “Complete” for Status<\/b>.<\/p>\n

    \"clip_image001\"<\/p>\n

    These rows satisfy the condition in the flow, so they should be copied to the list; then an email should be sent for each.<\/p>\n

    2. In My Flows<\/b>, click the ellipsis (. . .<\/b>) for the new hire flow, then click Run now<\/b> and Run flow<\/b>.<\/p>\n

    \"clip_image003\"<\/p>\n

    3. Look at the last two items in the list; they correspond to rows 12 and 13 in the Excel file. Success on this step!<\/p>\n

    \"clip_image004\"<\/p>\n

    4. Finally, look at the email that the flow sent; following is the email sent to Allan DeYoung in Finance, with a new hire notice for Jamie Campbell. It’s sent from Megan Bowen, becasue she created the flow.<\/p>\n

    \"clip_image005\"<\/p>\n

    The flow sends a second mail to Alex Wilber in Sales, with information about Heidi Steen.<\/p>\n

    That brings us to the end of this scenario – we hope you learned something about handling new hire scenarios, and how to incorporate features like apply to each, switch case, and testing for multiple conditions. Please leave comments below with feedback, and let us know if there are other scenarios you would like us to cover.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In this post, we\u2019ll walk through a new hire onboarding scenario. We\u2019ll use Flow to manage new hire information in Excel and SharePoint, then send emails to department heads when their employees are ready to start. Along the way we\u2019ll use some cool features in Flow, including: running a flow on a schedule; applying an action to each row in an Excel file; testing for multiple conditions in our data; and using a switch case statement to control who we send email to.<\/p>\n","protected":false},"author":141,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ms_queue_id":[],"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","_alt_title":"","ms-ems-related-posts":[],"footnotes":""},"audience":[3378],"content-type":[3423],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2113],"class_list":["post-110813","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-tips-and-guides","product-power-automate"],"yoast_head":"\nBy Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"By Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"In this post, we\u2019ll walk through a new hire onboarding scenario. We\u2019ll use Flow to manage new hire information in Excel and SharePoint, then send emails to department heads when their employees are ready to start. Along the way we\u2019ll use some cool features in Flow, including: running a flow on a schedule; applying an action to each row in an Excel file; testing for multiple conditions in our data; and using a switch case statement to control who we send email to.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/managing-new-hire-onboarding\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2017-04-14T13:43:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:14:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png\" \/>\n<meta name=\"author\" content=\"Michael Blythe\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Blythe\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/michael-blythe\/\",\"@type\":\"Person\",\"@name\":\"Michael Blythe\"}],\"headline\":\"By Industry – Human Resources: Onboarding made easy\",\"datePublished\":\"2017-04-14T13:43:56+00:00\",\"dateModified\":\"2025-06-11T15:14:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\"},\"wordCount\":1117,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\",\"name\":\"By Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png\",\"datePublished\":\"2017-04-14T13:43:56+00:00\",\"dateModified\":\"2025-06-11T15:14:42+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.webp\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.webp\",\"width\":633,\"height\":353,\"caption\":\"graphical user interface, text, application, email\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"By Industry – Human Resources: Onboarding made easy\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/28f169c029d7649dd38d68ab34c1afb9\",\"name\":\"Michael Blythe\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g2a2e6667523437a3bd97ccd4be578d82\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g\",\"caption\":\"Michael Blythe\"},\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/mblythe\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"By Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/","og_locale":"en_US","og_type":"article","og_title":"By Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog","og_description":"In this post, we\u2019ll walk through a new hire onboarding scenario. We\u2019ll use Flow to manage new hire information in Excel and SharePoint, then send emails to department heads when their employees are ready to start. Along the way we\u2019ll use some cool features in Flow, including: running a flow on a schedule; applying an action to each row in an Excel file; testing for multiple conditions in our data; and using a switch case statement to control who we send email to.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/power-automate\/managing-new-hire-onboarding\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2017-04-14T13:43:56+00:00","article_modified_time":"2025-06-11T15:14:42+00:00","og_image":[{"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png","type":"","width":"","height":""}],"author":"Michael Blythe","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Michael Blythe","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/michael-blythe\/","@type":"Person","@name":"Michael Blythe"}],"headline":"By Industry – Human Resources: Onboarding made easy","datePublished":"2017-04-14T13:43:56+00:00","dateModified":"2025-06-11T15:14:42+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/"},"wordCount":1117,"commentCount":0,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/","name":"By Industry - Human Resources: Onboarding made easy - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage"},"thumbnailUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.png","datePublished":"2017-04-14T13:43:56+00:00","dateModified":"2025-06-11T15:14:42+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#primaryimage","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.webp","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/mb1.webp","width":633,"height":353,"caption":"graphical user interface, text, application, email"},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/2017\/04\/14\/managing-new-hire-onboarding\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"By Industry – Human Resources: Onboarding made easy"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/#\/schema\/person\/28f169c029d7649dd38d68ab34c1afb9","name":"Michael Blythe","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g2a2e6667523437a3bd97ccd4be578d82","url":"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5c8d5577331fae92dcba533f60f7118161feeba4bfa2f4ccb7037293ac1b95be?s=96&d=mm&r=g","caption":"Michael Blythe"},"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/author\/mblythe\/"}]}},"bloginabox_animated_featured_image":null,"bloginabox_display_generated_audio":false,"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110813","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/141"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110813"}],"version-history":[{"count":1,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110813\/revisions"}],"predecessor-version":[{"id":131299,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110813\/revisions\/131299"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110813"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110813"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110813"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110813"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110813"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110813"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110813"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}