<\/p>\n
\u200b<\/strong>\u200bNow we need to build out the columns of the data we want to use<\/p>\n And then we need to Format as a table, <\/strong>check the box that your table has headers<\/strong>, and click OK<\/strong><\/p>\n \u00a0\u00a0 Ok, our Database is now created.<\/p>\n Head over to https:\/\/flow.microsoft.com<\/a> and register with your Gmail or outlook <\/strong>account. Once that’s done, click My Flows<\/strong> in the navigation menu then click + Create from blank\u00a0<\/strong>and then Search hundreds of connectors and triggers<\/strong> – from the bottom of the page<\/p>\n Where it says Add a trigger<\/strong>, lets search for Schedule <\/strong>and choose the Recurrence<\/strong>\u200b trigger.<\/p>\n We use Recurrence here for two reasons. 1. Because i want this flow to run only twice per day to save your Flow runs. and 2. Because the Excel connector doesn’t actually have native triggers, so this is a way for us to work around that and use Excel on OneDrive as our database effectively still.<\/p>\n Lets now set our Recurrence trigger to an interval of every 12 Hours\u00a0<\/strong>to take whatever actions we set up next.<\/p>\n Click on +New Step<\/b>\u200b and then Add an action.\u00a0<\/strong>\u200bSearch for Excel and choose Get Rows.\u00a0<\/strong>\u200bNext it will ask you to create a new connection to a file storage cloud service. For this demo I am using OneDrive and ill navigate to my RecruitingDatabase.xlsx and then select my table i made a few minutes ago.<\/p>\n Click + New Step <\/strong>and then Add a Condition –\u00a0<\/strong>\u200bfor the value of the condition, lets click on Add dynamic content+<\/strong> then use the column i made called Email Sent – <\/strong>\u200b(This is going to drop the condition into an Apply to Each)<\/em><\/p>\n I set is equal to\u00a0<\/strong>for the statement of my condition, and now i will write the word Yes<\/strong> into the right side value of the condition, like below: This ensures that if an email has already been sent to someone, they wont be sent another inadvertently. If you didn’t set up this step, every person on the list would get an email every 12 hours.. Not Awesome!<\/p>\n From here, I am going to now build out my next step in the IF NO column<\/strong> where i will choose …More<\/b>\u200b and Add a Condition<\/strong><\/p>\n \u200b<\/strong>\u200banother condition you ask? Indeed! This one will check to see if You, as the recruiter had a phone call with the potential candidate, since the last time the Flow checked for that same thing… Make sense? Hope so.. Moving on..<\/p>\n For the left side value of the condition, i will use the Add dynamic content\u200b<\/strong><\/strong>\u200b picker and select the column Contact Made<\/b>\u200b. I will then set the middle of the condition to is equal to\u00a0<\/strong>\u200band in the right side value i will write the word Yes\u00a0<\/strong>so it looks like this:<\/p>\n In the IF YES<\/strong> column of the condition click on Add an action<\/strong>\u200b and type Compose –\u00a0<\/strong>\u200bIn the compose box, we need to write “@utcnow()”\u00a0<\/p>\n Click Add an action and search for Convert time zone.\u00a0<\/strong>\u200bfor the base time, use the dynamic content from the Compose card called output.\u00a0<\/strong>\u200bFrom here customize the source time zone as (UTC) Coordinated Universal Time and the rest to whatever works for you.<\/p>\n Click Add an action <\/strong>and type Send Email. <\/strong>\u200bFor the purpose of this demo, and to complete her challenge of no money spent i will select Gmail – Send email\u00a0<\/strong>\u200band then customize the fields using Dynamic content and some of my own fancy language.<\/p>\n Next, lets build in a step that updates the database with a few things! But first, we need to get a little bit fancy and build an expression that will get us a date 30 days from now, automatically. This way we can use it to build some additional Flow actions to help us follow up on these conversations we are having with candidates.<\/p>\n Let’s click on Add an action\u00a0<\/strong>\u200band then lets add another Data Operations – Compose\u200b.\u00a0<\/strong><\/strong>Now lets click open the Add dynamic content<\/strong> selector and click Expression<\/strong> on the top right and scroll down to Date and Time <\/strong>functions. From here click on addDays(timestamp, days, format?)\u00a0<\/strong>\u200bthis will add the first piece of the expression which will be addDays()<\/strong><\/p>\n \u200bFrom here, click back over to dynamic content <\/strong>and click on the output<\/strong> from the first Compose<\/strong> action which will drop that info into your expression. Now click back on Expression and type “,30<\/strong>” after the Compose parenthesis and then click on OK<\/strong> to insert the expression into the compose action<\/p>\n Now lets build the step to update our database for us! Still working under the same IF YES<\/strong> column, click on Add an action –\u00a0<\/strong>\u200bSearch for Excel<\/strong> and choose the action Update Row.\u00a0<\/strong>\u200bPoint the action to the same database we have been using.<\/p>\n Lets have this step update a couple of things for us. First, since we now sent an email lets change that to say Yes<\/strong> in the database, we do that by simply typing Yes. Lets also update the Email Sent Date<\/strong> column by using the Output<\/strong> of our Compose action. and finally, Lets update the Follow Up Date<\/strong>\u200b column with the C<\/b>onverted time<\/strong> output we created by using the addDays expression.<\/p>\n For the final piece of this Flow, lets build a step that takes that Follow Up Date\u200b\u00a0<\/strong><\/strong>\u200band automatically sends us an email on that day telling us to follow up with this candidate.<\/p>\n Lets Add an action<\/strong> search for Delay Until\u00a0<\/strong>\u200band then in the Timestamp field, add the Output<\/strong> from Compose 2<\/strong><\/p>\n And for our last step in this Flow, lets one more time click on Add an action,\u00a0<\/strong>\u200bsearch for Notification<\/strong> and choose Send me an email notification.\u00a0<\/strong>\u200bI would assume that by this point in the tutorial you understand how to use Dynamic content, and so go ahead and create a custom email to yourself that will be useful and worthwhile, in the moment. So you don’t have to go look up additional details you could have given yourself. Something like this:<\/p>\n From here go to the top of the screen and write a name for your Flow and then click on Create Flow<\/strong><\/p>\n Voila!<\/strong>\u200b In less than 4 hours i came up with a concept and put it all together using Flow. To recap exactly what we accomplished here with this Flow lets break it down in some bullet points!<\/p>\n – We created a database for my friend to store her recruiting leads We have gained a huge jump in productivity. We saved time by automating email follow ups, as well as not needing to remind myself of the 30 day mark re-touch.\u00a0<\/p>\n All of this with ZERO cost in software or services, using only the Flow free plan, as well as free openly available software.\u00a0<\/p>\n \u200bIf you enjoyed this post, please let us know in the comments, the community or on Twitter. Same goes for questions!<\/p>\n Until next time!<\/p>\n – Jon<\/p>\n What is up, Flow Fans!?<\/p>\n \u200bThis week I am pretty excited about the Flow of the Week. I recently had a friend challenge me about Flow! She asked me what kind of value Flow could provide if she didn’t have an O365 or D365 Subscription and didn’t want to pay for Flow or any of its premium services. Lucky for her, you don’t have to pay for Flow, D365, O365 or any other services to get value out of the service. I told her that i could create her a system that would automatically help her with her recruiting and retention at work, That i could do it in under 4 hours, and that i could do it for 0 Cost. She bet me dinner that i couldn’t, and suffice it to say… she owes me some food, and I’m not a cheap date!<\/p>\n After proving it to her that this was not only possible, but easy to accomplish, I also decided that this would make an awesome Flow of the Week for those of you who may be wondering.. “What value could i get with Flow Free?”<\/p>\n Well, Lets jump in and see how i made this happen for her.\u00a0<\/p>\n First, You’re going to need an outlook.com or Gmail account. Ill assume that you have one of those, or can figure out how to get one. Now that you have those accounts set up and ready to go lets make some magic!<\/p>\n<\/p>\n
\u00a0\u00a0
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
<\/p>\n
\n\u200b- We created a Flow that checks every 12 hours who she has had phone calls with
\n\u200b- When it finds someone she had a phone call with that day, it sends them a follow up email with useful links to documents and information
\n\u200b- It then updates the database with some information, like the fact that it sent an email out, and notes the date that happened.\u00a0
\n\u200b- After that, it calculates a date 30 days away from when the first follow up email was sent, and it emails my friend, the recruiter a follow up reminder with pertinent details and information about the candidate
\n\u200b- It won ME dinner at a nice steakhouse of my choosing. *Fist pump*<\/p>\n
\n\u200bNext, You will need a free OneDrive account. I am going to assume you have this, or can also get it with the help of a Bing search or two.<\/p>\n