{"id":110770,"date":"2017-01-03T01:17:46","date_gmt":"2017-01-03T09:17:46","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/"},"modified":"2017-01-03T01:17:46","modified_gmt":"2017-01-03T09:17:46","slug":"track-work-hours-btn","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/","title":{"rendered":"Flow of the Week: Use a button to track your work hours and work location"},"content":{"rendered":"<p>Today, in our\u00a0<strong>Flow of the Week<\/strong>\u00a0series, I would like to highlight a capability we recently added to our Flow Mobile buttons.<\/p>\n<p>Before highlighting this new functionality, just a reminder of the basics: If you aren&#8217;t familiar with <a href=\"https:\/\/flow.microsoft.com\/en-us\/documentation\/introduction-to-button-flows\/\">button flows<\/a>, they are an easy way to kick off a workflow from your \u00a0iOS or Android device with a single tap.<\/p>\n<p>To use a button, download the app for\u00a0<a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.microsoft.flow\">Android<\/a>\u00a0or\u00a0<a href=\"https:\/\/itunes.apple.com\/us\/app\/microsoft-flow\/id1094928825?ls=1&amp;mt=8\">iOS<\/a> and sign in.<\/p>\n<p>Now, heading on to our newest capability: when triggering a button now, the button collects valuable information such as your location, your user details, and the current time. This info can now be leveraged within your flow. Read more on the topic <a href=\"https:\/\/flow.microsoft.com\/en-us\/documentation\/introduction-to-button-trigger-tokens\/\">here<\/a>.\u00a0<\/p>\n<p>This data can be useful in various cases. One usecase which is often raised by our Flow users, is their need to keep track of their work hours, and work locations, so that they can review the info or sum it up at the end of the month. For example, consultants who advise several companies, or project contractors.<\/p>\n<p>For this usecase, we\u2019ve created these templates to log your business activities:<\/p>\n<ul>\n<li><a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/95910030cb7c11e6bc5ded851745407e\/track-your-work-hours-and-work-location\/\">Track your work hours and work location in a Google sheet<\/a><\/li>\n<li><a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/98af62a0ca8911e6bbe0ffe3ac60cec0\/track-your-work-hours-and-work-location\/\">Track your work hours and work locationin an Excel table<\/a><\/li>\n<\/ul>\n<h2>Getting Started<\/h2>\n<p>The first step is to select your template:\u00a0<a href=\"https:\/\/flow.microsoft.com\/en-us\/galleries\/public\/templates\/95910030cb7c11e6bc5ded851745407e\/track-your-work-hours-and-work-location\/\" style=\"font-size: 13.008px;\">Track your work hours and work location in a Google sheet<\/a><\/p>\n<p>On the template page, if this is the first time that you are using a Google Sheet, you will be asked to Sign in.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.png\" style=\"border-width: 0px; border-style: solid; width: 348px; height: 156px;\"\/><\/p>\n<p>As you connect, you should see a green checkmark next to the connection. This indicates that the connection has been successfully tested. Then, once you have connected, select\u00a0<strong>Continue.<\/strong><\/p>\n<h2>Filling out the flow settings<\/h2>\n<p>In order to use this flow, you will need to create a Google sheet with the following columns: <strong>Date, Timestamp, Full address.<\/strong><\/p>\n<p>Now that you have connected to your services, and created your Google sheet, you only need to configure one action in the flow:<\/p>\n<p>In the\u00a0<strong>Insert row<\/strong>\u00a0card, select your Google Sheet file using the highlighted file picker.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/insert20Card.png\" style=\"width: 210px; height: 108px;\"\/><\/p>\n<p>Then, in the Worksheet field just select your respective sheet name, i.e. \u201cSheet1\u201d In the below example.<\/p>\n<p>Once choosing your sheet names, the sheet columns will be mapped to your button trigger inputs, as pre-defined in this template.<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Mapped20columns.png\" style=\"border-width: 0px; border-style: solid; width: 295px; height: 406px;\"\/><\/p>\n<p>If you choose, you can also customize other aspects of the flow, such as the text of the push notification which you \u00a0receive upon run completion.<\/p>\n<p>Please note that this flow can also be created directly from your Microsoft Flow Mobile application for <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.microsoft.flow\">Android<\/a>\u00a0or\u00a0<a href=\"https:\/\/itunes.apple.com\/us\/app\/microsoft-flow\/id1094928825?ls=1&amp;mt=8\">iOS<\/a>.<\/p>\n<h2>Running your flow<\/h2>\n<p>Finally, running the flow is easy. In your Flow mobile app, select the\u00a0<strong>Buttons<\/strong>\u00a0tab at the bottom of the screen, and then tap the flow you just created.<\/p>\n<p><img decoding=\"async\" alt=\"\" src=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Button20tab.png\" style=\"width: 176px; height: 360px;\"\/><\/p>\n<p>Using your button trigger info, tapping the button will log your current location and time to your table. \u00a0Finally, you will get a push notification at the end of the run, indicating that your Sheet was updated successfully.<\/p>\n<p>Please note that when Flow accesses your <strong>location<\/strong> info for the first time, it will ask for your consent.<\/p>\n<p>That\u2019s it, you\u2019re all set to use this button now. You can now simply tap the button once when starting your workday, and once again at the end of your workday.<\/p>\n<p>Let us know what you think about this flow and\u00a0suggest other ideas <a href=\"https:\/\/go.microsoft.com\/fwlink\/?LinkID=787467\">on the forum<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Do you work on several projects? From several sites?<br \/>\nNow you can easily keep track of your work hours and work locations, at the tap of a button.<\/p>\n","protected":false},"author":361,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590],"power-automate-tag":[2487,2609,2658,2814,2850],"coauthors":[2923],"class_list":["post-110770","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week","power-automate-tag-buttons","power-automate-tag-googlesheet","power-automate-tag-location","power-automate-tag-tracking","power-automate-tag-work"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Flow of the Week: Use a button to track your work hours and work location - 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\/power-automate\/track-work-hours-btn\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flow of the Week: Use a button to track your work hours and work location - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Do you work on several projects? From several sites? Now you can easily keep track of your work hours and work locations, at the tap of a button.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Adi Regev\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/\",\"name\":\"Flow of the Week: Use a button to track your work hours and work location - 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\/power-automate\/track-work-hours-btn\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.png\",\"datePublished\":\"2017-01-03T09:17:46+00:00\",\"dateModified\":\"2017-01-03T09:17:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#primaryimage\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.webp\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.webp\",\"width\":438,\"height\":168,\"caption\":\"graphical user interface, text, application, chat or text message\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Flow of the Week: Use a button to track your work hours and work location\"}]},{\"@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\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flow of the Week: Use a button to track your work hours and work location - 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\/power-automate\/track-work-hours-btn\/","og_locale":"en_US","og_type":"article","og_title":"Flow of the Week: Use a button to track your work hours and work location - Microsoft Power Platform Blog","og_description":"Do you work on several projects? From several sites? Now you can easily keep track of your work hours and work locations, at the tap of a button.","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Adi Regev"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/","name":"Flow of the Week: Use a button to track your work hours and work location - 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\/power-automate\/track-work-hours-btn\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#primaryimage"},"thumbnailUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.png","datePublished":"2017-01-03T09:17:46+00:00","dateModified":"2017-01-03T09:17:46+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#primaryimage","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.webp","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2024\/06\/Connection20wizard.webp","width":438,"height":168,"caption":"graphical user interface, text, application, chat or text message"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/track-work-hours-btn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Flow of the Week: Use a button to track your work hours and work location"}]},{"@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\/"}}]}},"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\/power-automate\/110770"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/361"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110770"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110770\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110770"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110770"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110770"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110770"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}