{"id":110903,"date":"2018-01-25T09:30:11","date_gmt":"2018-01-25T17:30:11","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/"},"modified":"2025-06-11T08:10:07","modified_gmt":"2025-06-11T15:10:07","slug":"flow-of-the-week-using-flow-to-create-internal-microsoft-solutions","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/","title":{"rendered":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions"},"content":{"rendered":"<h3><strong>Hello Flow Fans!<\/strong><\/h3>\n<p>Today for the Flow of the week I am going to bring you something a little bit different!<\/p>\n<p>Not only is this an instructional Flow, The Flow i am going to share with you today is a Flow that is being used in Microsoft internal, currently. This Flow powers a pilot program partnership between Microsoft and UpWork to bring Freelance designers into the Microsoft ecosystem to help us get projects done more quickly and efficiently. This may not be your use case, <strong>BUT<\/strong> this same application of technology can be used in TONS of other situations.<\/p>\n<p>So to start framing the story a bit, I receive an email from my boss asking the team, &#8220;Does anyone want to help on this project?&#8221; I dive into the email a bit more and learn that Microsoft and UpWork have reached a partnership and they need a workflow to power a good portion of the user experience &#8211; the problem being.. We have people who complete a training over here&#8230; and we have this request form over here.. with no idea how to connect the two. Oh and one Minor detail.. <strong>We need this solution built in 10 days<\/strong>, as we have a major press event to talk about all of this.<\/p>\n<p>Myself and my coworker <a href=\"https:\/\/twitter.com\/wearsy\">Kent Weare<\/a> volunteered to help the internal Microsoft team out!\u00a0<\/p>\n<p>We met with the team and learned of a few more problems we were to face&#8230; And this is where it really became interesting&#8230;\u00a0<\/p>\n<p><strong>Problem 1 <\/strong>&#8211; The only way to get access to the list of who completed the training was a daily email report&#8230;\u00a0<img loading=\"lazy\" decoding=\"async\" alt=\"no\" height=\"23\" src=\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\" title=\"no\" width=\"23\"\/><\/p>\n<p><strong>Problem 2 <\/strong>&#8211; The Daily email report, wasn&#8217;t a report of the new people that joined since yesterday&#8230; oh no, it was the entire list, every single day, with new participants pasted to the bottom&#8230;\u00a0<img loading=\"lazy\" decoding=\"async\" alt=\"no\" height=\"23\" src=\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\" title=\"no\" width=\"23\"\/>\u200b\u00a0<img loading=\"lazy\" decoding=\"async\" alt=\"no\" height=\"23\" src=\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\" title=\"no\" width=\"23\"\/><\/p>\n<h3>Really?!<\/h3>\n<p>Ok, so we get an email report that we can have emailed to us daily but doesn&#8217;t give us new responses.. it gives them all to us every time. &#8220;How the heck are we supposed to get data out of the attached report and do something meaningful with it?&#8221; we asked ourselves.<\/p>\n<p>Suddenly an email we had received from a Microsoft Flow Partner came to mind! <a href=\"https:\/\/parserr.com\/\">PARSERR<\/a> had joined our platform a few weeks prior and this is exactly what they do!<\/p>\n<p>And &#8211; That&#8217;s where we jump into this tutorial!<\/p>\n<p><strong>1st<\/strong> &#8211; Head on over to <a href=\"https:\/\/parserr.com\/\">www.parserr.com<\/a> with me and go ahead and start a free trial account and then make note of the email inbox that they assign to you, we will need this soon.<\/p>\n<p><strong>2nd<\/strong> &#8211; Forward the email with the report attached to the email inbox you were assigned when you signed up. I am not going to show you any images of mine, i don&#8217;t want any rogue emails messing up my process!<\/p>\n<p><strong>3rd<\/strong> &#8211; I am going to assume you completed steps 1 and 2 successfully. Now lets open up Parserr and choose <strong>+Add a new Rule<\/strong> and then choose <strong>Attachments<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"202\" src=\"https:\/\/dtyxrg-dm2306.files.1drv.com\/y4m8uB_0N8MaMWZtLMsiWXwpID4W7qddUYvRvNrk9pyVTjj4QSDTBV0EMq9kfTi-ZQQh3uU0SIncnQMM399YHo2aH2_lIifsgCECQnLwzsGBJcKQxm9_9gBKOeuVn_EHifhzQzyNf9jDOdNthyDT_L97wQFSUqlIMv5BckyYD5zPJJed0-kwcOsIAgnk8SkAp99Hr82Jttr90aQ7o3iPFw1ZQ?width=1443&amp;height=202&amp;cropmode=none\" width=\"1443\"\/> <img loading=\"lazy\" decoding=\"async\" height=\"336\" src=\"https:\/\/3pmnlg-dm2306.files.1drv.com\/y4mpv2mazW94dGcfbANmQlJty9uC9DMlFhEEMu6-1tHHlZRqqNVbZ0fQAvMaHxb4MWXxCbSZucOcPbfKUizxMTrXnBI0lNNUsIRBkMFcMfjxH5dKiC1O_IyuU5A7KMCp5jCx31dsPCiqfyCPlOfAih4KZNIkgR--WsD0ZWmkUJD1IlsAZjA3AsKlic14-aHOSo3Ih6M_g3apDOBvsj1LFpgNA?width=955&amp;height=336&amp;cropmode=none\" width=\"955\"\/><\/p>\n<p><strong>4th <\/strong>&#8211; Add a filter that removes the rows you don&#8217;t need until you have the data you want. As you can see below, I remove rows 1,2 and then once that&#8217;s filtered I remove the new row 1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"805\" src=\"https:\/\/qx9m8w-dm2306.files.1drv.com\/y4m161KhAETtETqEmiWkGEUH5enkjRiJRUd0TQ3e6f9cvkdW7tqKUL0wQAT48W-K7Dwxll37uNhPFHcsMz3talX7DOC4iXf3EkxLtmvMoetDAkZaGJTmkvYEfGpzd8etIwI4XsvubuBICbwYkLquiOJxnXjzC8qCOaCW0ZqPlIHUhOZ84ZESBYAhxlp9b51jabhduqKIOuUL9hVZbyjxZg7jQ?width=980&amp;height=805&amp;cropmode=none\" width=\"980\"\/> <img loading=\"lazy\" decoding=\"async\" height=\"795\" src=\"https:\/\/fh1c2w-dm2306.files.1drv.com\/y4mq0PbqgXTEDbPIJQ_f73yVX34jF42v7zP-BdL3UCG99WOeWfxiYuE_zwZyBTeC4eCkQACF0NdF48d8HYIySKm5rFC19tfWzfKPpgUzzOx2Xy17Di--3eKZr_TfbyufMOjs0_3TZTDlj7u6CmzJxJVY5jjT8xkKhwpyrcmvGwxGUmDoZ3AnUwI9lzs3QMqAHyItO9eF9dVAMKpJqQ7gp_Www?width=960&amp;height=795&amp;cropmode=none\" width=\"960\"\/><\/p>\n<p><strong>5th &#8211;<\/strong>\u200b Now that we have our data being parsed properly, lets go over to <a href=\"https:\/\/flow.microsoft.com\">Flow.Microsoft.com<\/a> and click on <strong>My Flows<\/strong> and then <strong>+Create From Blank<\/strong><\/p>\n<p><strong>6th <\/strong>&#8211; Choose Parserr and then choose <strong>When an Email is received\u00a0<\/strong>\u200band then choose the email inbox from step 1 and step 3<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"78\" src=\"https:\/\/smaria-dm2306.files.1drv.com\/y4muwiX17FjkCOf72SWzpJge9_SDm781mhOr5QPp2obXpxbngcdFjn2fIVf1zzDid1IyG6MOQB2lmnwchgU5xDHnSSTo7cAbNzRQVndO_vT_1JntoOYAJQOoWQx8HlCFSpHhcf35k-1Er3TCJWKN3DrVQaQbk29nnhneQIKOLiay0mcnt8ItGPOLg08Xhi1rwSHC6RetduJ6dwr81xhYwNEPA?width=656&amp;height=78&amp;cropmode=none\" width=\"656\"\/><\/p>\n<p><strong>7th <\/strong>&#8211; Choose <strong>+Add an action<\/strong>\u00a0\u200band type in <strong>Initialize Variable\u00a0<\/strong>\u200band select it. Im using this variable to get the user UPN so we can do a check to see if the member is already in our approved list or not.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"194\" src=\"https:\/\/eqi1oa-dm2306.files.1drv.com\/y4mq6yid2af0rphzodXkCxtnrzdra8mvo1sHRlEJRIbdb05lhJSc825LuKqJdcI0WALhVx9RoLfdvHe5IqA4YrNfhtgl0VO06AaNSFbCP2DDgsqPFfmA4EQW6XwFGyVubHPHtj3iMBvwU5IxY2xBkoC0LAGawGzuMV3_qX0uQLueJarMZc5Ry-GA4PisFu8Kxs7HKRMZy1DNszQaPpuRAE-Fg?width=639&amp;height=194&amp;cropmode=none\" width=\"639\"\/><\/p>\n<p><strong>8th &#8211;\u00a0<\/strong>\u200bChoose <strong>+Add an action<\/strong> and type in <strong>Search for Users\u00a0<\/strong>\u200band select it &#8211; Choose the column from your <strong>Grab Columns<\/strong> dynamic outputs &#8211; For me it happens to be <strong>Column 2<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"127\" src=\"https:\/\/rqedfg-dm2306.files.1drv.com\/y4mSf_xR78w3O1q7L4Ql9ke4Dr5HuomCs3I_7qE3SCOVFERWiFI463qgxnzSxMm-LCPRY55xCwBQQa55V1_HBDBGbzLPyFVnCr9sfcNIdPfnbjJLYLPcDiWUr7JAb1dbuqrcT3Mr_ECVln9S1i08lZQveRwxrg8z1me1R9IR71N0lE7WxLnRuzUp7GarMkzDgkrB6E7jui6-cwISzyWKor9Zg?width=648&amp;height=127&amp;cropmode=none\" width=\"648\"\/><\/p>\n<p><strong>9th &#8211; <\/strong>Choose <strong>More<\/strong> and then <strong>Add an Apply to Each<\/strong>\u200b and then add the <strong>body<\/strong> output from the search for users step above to the apply to each selection box.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"257\" src=\"https:\/\/0awdow-dm2306.files.1drv.com\/y4mpXahnWXnNua03_NI8wDpZVeeszXnurX7hGf4C9Cvws5y6m0W6gDRn5wnPW9JKmUdumzpLaVOLguJQ97i1Gc_gugM41y-alY2Ndqd9JnL3pxFDdGctDIDQLPxW5BB0F74uwMrTDoybASjn5m2CzrolsD2mTPy7v6rCkSqwim73KzSoFfCnJE95bgqA1ltouWYNm_VhFrxEzpTFXJgB72sBQ?width=627&amp;height=257&amp;cropmode=none\" width=\"627\"\/><\/p>\n<p><strong>10th &#8211;\u00a0<\/strong>\u200bInside of the Apply to Each add the action <strong>Set Variable. <\/strong>\u200bSet the name as UserUPN and select the <strong>User Principle Name (UPN) <\/strong>From the Dynamic content for the value.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"462\" src=\"https:\/\/nzhbma-dm2306.files.1drv.com\/y4mz-0DfIshF6COV-_I0AY7p7OXsujKg_-RGaPpbLee4ukhiFVoMX8hHf1HgmO7NTcsuFD9J7wi1_gh96LAUQTZdw450sittoCoMQkZT26uqat5pcZ1tOmcEShefPqQIRxEU2HKgATctzBK7ihoXtHshIIi3ojYWjVTE8XcjjdtbwIDIX4TuO2V8LtG1VA5Q058ALPjAx-mRPmVbPBCObEB1A?width=699&amp;height=462&amp;cropmode=none\" width=\"699\"\/><\/p>\n<p><strong>\u200b11th &#8211;<\/strong> Add an action \u200bType <strong>Get Items<\/strong>\u200b and select <strong>SharePoint Get Items\u00a0<\/strong>\u200band choose the SharePoint list where all of the user information should be held.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"79\" src=\"https:\/\/qkrfua-dm2306.files.1drv.com\/y4mqbttvQ8jsa-rTYJubzGPSLQPlBlo1RuTK5PIrIKTDCsmpK-7UOVd17BgzXtTgxjU_5dZRUhI3mOlYOMdVJBkkU6Ckf9tIkV1jr9NXIKZzmlYhKMvIY1DKPPNC-bKJlYj7Oz_L2vTToq-cqbMbfVGdfSVA4zqeEQbXSHT2iQYTmjpftYH_7kX-yacD-t7CkjaCCzFNM3FVoCe9SZt2VoiPw?width=638&amp;height=79&amp;cropmode=none\" width=\"638\"\/><\/p>\n<p><strong>12th &#8211;\u00a0\u200b<\/strong>Add a condition and use the expression &#8211; &#8220;@greater(length(body(&#8216;Get_items&#8217;)?[&#8216;value&#8217;]), 0)\u200b&#8221; to check if the user exists on our list already, if they do, we dont want them to get the welcome email twice!<\/p>\n<h3><strong>Curse the Blimy email system that cant do a delta!<\/strong><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"175\" src=\"https:\/\/dtyerg-dm2306.files.1drv.com\/y4m0u_eo_Op3e-LEvhWVED9ncfYrt4Q71IZgtknZ2ZN8GIVMNKHCNRONA-HEkKML6k7xn-Ka1qCIGhiw44Kz_OE3h7LWFwXFlqnN76uBTdd84yDew9AFj_uiQYnl48b-7-zUC4c66blALxiOY-uo4remVc7uiGcKjhItKuqQf4QViMzvL6Z5lPy9guqK0NJRCYHH4hfPq2hOUw4OjDc3AMNqA?width=638&amp;height=175&amp;cropmode=none\" width=\"638\"\/><\/p>\n<p><strong>13th &#8211; <\/strong>On the IF NO side of the condition <strong>Add an action<\/strong> choose <strong>SharePoint<\/strong> then <strong>Create Item\u00a0<\/strong>\u200bThis way, if the user wasn&#8217;t on the list yesterday they WILL get the welcome email and be added to our group like you will see below<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"575\" src=\"https:\/\/3pmulg-dm2306.files.1drv.com\/y4mi1ohiHBVLnV4DDJYfva3IAfL1fVGEyPpMoTbZm3M2h0QFJoUr554cUn3_cq7pDWM5kq_EogdD7BpjBkUnY_amZpBFSHgqI92e1OGNAHbOpRGX_egyIAGjv0_-TdSt5QmD2aEyvQFOL1FQhy1yEjfXEHz44hmxb0XyQsJRQXCZTl9RHdxFPC1pkhnf0Lheq6yYxtIHs2_LIOxkfGRMjNonQ?width=653&amp;height=575&amp;cropmode=none\" width=\"653\"\/><\/p>\n<p><b>14th &#8211;\u00a0<\/b>\u200bChoose <strong>Add an action<\/strong> and then <strong>Office 365 Groups<\/strong>\u00a0and then <strong>Add user to Group.\u00a0<\/strong>\u200bSelect the proper group and then add the User <strong>UPN<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"154\" src=\"https:\/\/qx9t8w-dm2306.files.1drv.com\/y4mcMlUp3F1rujo3sNgpjZP0cWMHCeJ9HaeBAyb0JCUogecjHZuAn1Aj6Lh1xdO9F26dII8hOTpgRFNdFzUxemyWv0R27pboYJoagMQstwgTLDTJ2ZFMuGjXHi-cjqNVYvBPvCDbKR_03JkTJ-0wbbxkDd2ieT_PREa4V2paQc-m4hFu-qKoNbHaPwdB3-MvEeMfUJ3gLXufamlA4bCsAFRig?width=619&amp;height=154&amp;cropmode=none\" width=\"619\"\/><\/p>\n<p><strong>15th &#8211;\u00a0<\/strong>\u200bLast but not least, Lets add our final action to <strong>Send An Email<\/strong> (hopefully not covered in red smudges like mine) welcoming the user to the group with a bunch of helpful links for them to use!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" height=\"803\" src=\"https:\/\/eqi8oa-dm2306.files.1drv.com\/y4m_Wu3A5uJqdc69W_7FfKBDxWN0x9KsPZhfVwyoejCz2CngppuQukiRll_FDcrMHhWwdSezCbrlSGvuzDwLm630sF0T52by5a-YkJHaa9Hfpr144h4XZlN0y54XpyVPpmTaC5vjayndlVNQfkj_i7zZR0zNM-wcV-ekvzGOuVKw-S-TsdW8_WggHES8YhjoYYarUxNQhv9hSJtbW5F2ovMyA?width=560&amp;height=803&amp;cropmode=none\" width=\"560\"\/><strong>\u200b<\/strong><\/p>\n<p><strong>\u200b<\/strong>\u200bAnd that&#8217;s that! A real life Flow powering Process inside of Microsoft, for Microsoft FTE&#8217;s to be more productive and to not have to go and code native solutions to accomplish every day tasks.<\/p>\n<p>Here is the email from Liane Scult and Lora White after we completed the project for them:<\/p>\n<p style=\"margin: 0px;\"><em>\u201cHi, this is Liane Scult from the Office Products Group (OPG) \u00a0and Lora White from Microsoft Procurement.\u00a0 We are business partners co-managing the launch of a new enterprise program that allows Microsoft employees to participate in the <a href=\"https:\/\/aka.ms\/gigeconomy\"><u>Gig Economy<\/u><\/a> by leveraging our first-ever agreement with a freelance platform called Upwork.\u00a0 It\u2019s a really exciting new opportunity that allows Microsoft employees access to over 12 million freelancers around the world who can be engaged on-demand to complete projects large and small.\u00a0 <\/em><\/p>\n<p style=\"margin: 0px;\">\u00a0<\/p>\n<p style=\"margin: 0px;\"><em>We discovered Microsoft Flow when we were struggling to figure to manage process-triggered actions and communications needed to support the program.\u00a0 In a dynamic process with many requirements that prompt certain actions and messages once completed, we thought we would need to hire a contractor just to facilitate communications.\u00a0 What contradiction:\u00a0 We were launching a state-of-the art platform that would digitally transform how we source external talent, yet we couldn\u2019t scale our internal, manual processes to support it.<\/em><\/p>\n<p style=\"margin: 0px;\">\u00a0<\/p>\n<p style=\"margin: 0px;\"><em>With Flow, and help from Kent Weare and Jon Levesque on the Flow team, we were able to automate all of the steps in our process.\u00a0 When a new user completes the required training, Flow consumes the data from Learning Central and then triggers a series of events that would have been done manually otherwise.\u00a0 For example, the flow adds users to our list of approved participants, \u00a0joins them to our program MS Teams site, and then sends a personalized congratulatory email.\u00a0 Next, Flow lets us know when we have a project application to review and sends the applicant a status update in a customized email informed by fields populated by the applicant and the reviewer.\u00a0 It even sends an email to our supplier advising them when an application has been approved and instructs them to set up the new user account.\u00a0<\/em><br \/>\n\u00a0<\/p>\n<p><em>Seamlessly and instantaneously, Flow enabled process steps and communications between our program office, our end users, and our supplier.\u00a0 With very little effort, we have delivered an unparalleled response time \u2013 and ultimately, an exceptional customer experience. \u00a0What\u2019s more?\u00a0 It\u2019s efficient and it scales.\u00a0 Problem solved.\u00a0 Thank you, Flow!\u201d<\/em><\/p>\n<p>\u200bIf you get emails like this, i bet your boss would LOVE you! Have you created a Flow that your business absolutely depends on? We WANT to hear about it!\u00a0 Send me an email at <a href=\"mailto:jolevesq@microsoft.com?subject=I%20use%20Flow%20for%20my%20business!\">Jolevesq@microsoft.com<\/a><\/p>\n<p>And as always, if you have questions or comments, please leave them in the comments below, on our <a href=\"https:\/\/twitter.com\/MicrosoftFlow\">Twitter <\/a>or the best place to talk &#8211; <a href=\"https:\/\/powerusers.microsoft.com\/t5\/Microsoft-Flow-Community\/ct-p\/FlowCommunity\">The Flow Community<\/a>!<\/p>\n<h3>P.S &#8211; I want to make a special shout out to Courtenay from Parserr.com for providing us access to the Parserr service at no cost. Without the Parserr service, this Flow wouldnt be possible!<\/h3>\n<h3>\u00a0<\/h3>\n<p>Until next time!<\/p>\n<p>&#8211; Jon Levesque, Senior Program Manager<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this Microsoft Flow of the Week, Senior PM Jon Levesque walks you through building a Flow that is powering the partnership between Microsoft and UpWork.<\/p>\n","protected":false},"author":348,"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":[27],"job-role":[],"product":[3474],"property":[],"topic":[],"coauthors":[2899],"class_list":["post-110903","post","type-post","status-publish","format-standard","hentry","audience-it-professional","content-type-customer-stories","product-power-automate"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"In this Microsoft Flow of the Week, Senior PM Jon Levesque walks you through building a Flow that is powering the partnership between Microsoft and UpWork.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-25T17:30:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-11T15:10:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\" \/>\n<meta name=\"author\" content=\"Jonathon Levesque\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathon Levesque\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\"},\"author\":[{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/\",\"@type\":\"Person\",\"@name\":\"Jonathon Levesque\"}],\"headline\":\"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions\",\"datePublished\":\"2018-01-25T17:30:11+00:00\",\"dateModified\":\"2025-06-11T15:10:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\"},\"wordCount\":1448,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\",\"keywords\":[\"Flow of the Week\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\",\"name\":\"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\",\"datePublished\":\"2018-01-25T17:30:11+00:00\",\"dateModified\":\"2025-06-11T15:10:07+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage\",\"url\":\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\",\"contentUrl\":\"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772\",\"name\":\"Jonathon Levesque\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g\",\"caption\":\"Jonathon Levesque\"},\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jolevesq\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - 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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/","og_locale":"en_US","og_type":"article","og_title":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - Microsoft Power Platform Blog","og_description":"In this Microsoft Flow of the Week, Senior PM Jon Levesque walks you through building a Flow that is powering the partnership between Microsoft and UpWork.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/","og_site_name":"Microsoft Power Platform Blog","article_published_time":"2018-01-25T17:30:11+00:00","article_modified_time":"2025-06-11T15:10:07+00:00","og_image":[{"url":"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png","type":"","width":"","height":""}],"author":"Jonathon Levesque","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathon Levesque","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#article","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/"},"author":[{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jonathon-levesque\/","@type":"Person","@name":"Jonathon Levesque"}],"headline":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions","datePublished":"2018-01-25T17:30:11+00:00","dateModified":"2025-06-11T15:10:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/"},"wordCount":1448,"commentCount":0,"publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage"},"thumbnailUrl":"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png","keywords":["Flow of the Week"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/","name":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage"},"thumbnailUrl":"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png","datePublished":"2018-01-25T17:30:11+00:00","dateModified":"2025-06-11T15:10:07+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#primaryimage","url":"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png","contentUrl":"https:\/\/blogs.azure.net\/Modules\/LuDC.CKEditor\/scripts\/ckeditor\/plugins\/smiley\/images\/thumbs_down.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/2018\/01\/25\/flow-of-the-week-using-flow-to-create-internal-microsoft-solutions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Intermediate | Flow of the Week: Using Flow to create internal Microsoft solutions"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/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:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/person\/017e233f3881f5857f3e7f6f221ef772","name":"Jonathon Levesque","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g42ef9de3d3e22347884fca1cf41497c5","url":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41fc5b54c4eaedb81f310f27ac37ee7ddeb02a9c5a0fe4616693f664bd6a1d7c?s=96&d=mm&r=g","caption":"Jonathon Levesque"},"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/author\/jolevesq\/"}]}},"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:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110903","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/348"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110903"}],"version-history":[{"count":1,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110903\/revisions"}],"predecessor-version":[{"id":131126,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/posts\/110903\/revisions\/131126"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110903"}],"wp:term":[{"taxonomy":"audience","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/audience?post=110903"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/content-type?post=110903"},{"taxonomy":"job-role","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/job-role?post=110903"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/product?post=110903"},{"taxonomy":"property","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/property?post=110903"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/topic?post=110903"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110903"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}