How to never lose your car again in under 10 minutes using Microsoft Flow
Have you ever wanted to drop a digital breadcrumb on a location for later access? I first thought of this for snow shoeing, where trails can be established using layers of 'pins' dropped by users, so fellow snow shoe'ers can find new or already established trails, or blaze new ones.
Recently, I was inspired to develop a mobile app for capturing homeless stats during the annual state count/sweep as a demonstration using PowerApps, Flow, SharePoint and potentially some PowerBI. By using a mobile app to capture homeless interview information, we can give back hundreds of volunteer hours, provide better data by reducing the number of times the information is captured, in hopes of better serving this demographic. Using Microsoft's Modern Application Platform, a lesson in humility, and a hackathon opportunity, I still came up short on functionality until just recently, which inspired THIS blog.
More on the homeless app in a future blog!
Don't loose your car, ever again Dude!The Dude Flow button
With the click of a 'Dude' Flow button, you will save your location information from your mobile device, to a SharePoint Online list. Lastly, you'll see a link in the mobile notification that launches your mobile app with step by step directions on getting you back to your car.
SharePoint, Flow and the Dude Flow button
NOTE: This has only tested on iOS at this time. Please let me know your experiences so I can keep this post up to date.
Requirements
Short of a developer or community Office 365 account you will need:
- You will need an active Office 365 subscription to create a new Flow.
Office 365 Subscription required
- You will need to install Microsoft Flow on your mobile device if you haven't already.
- While you aren't required to store the location information in SharePoint to obtain the end result, which is directions back to your car, it is required to be able to show the location maps using this awesome PowerBI visual.
PowerBI ESRI Mapped Location
I should note that you could have stored the location information generated when pressing the Dude Flow button, into an Excel file stored on your OneDrive for Business as an alternative location than using a SharePoint list. There are a few things you would need to do with the Excel file to work. Check out any of the Flow Tweet blogs or how to videos on the additional table formatting you need to do first if you want to go down this path.
To complete all the steps in this article, an Office 365 E1 license, student or Small Business license should suffice. You will also need PowerBI if you want to view the locations or perform other BI wizardry on.
Create a new SharePoint list
- Create a new SharePoint (custom) List with the name CarLocation
- Add columns as illustrated below for Longitude, Latitude and TimeStamp:
CarLocation SPCustomList
Create a new Microsoft Flow
- Log into flow.microsoft.com using your Organizational O365 account
- Create a new (blank) Flow
- Select Flow button for mobile
- Rename the new flow Dude
Add the Dude Flow Button
Connect to your SharePoint list
- Click New Step
- Click Add an action
- Type or select SharePoint (SERVICES)
Flow Add SharePoint Action
Map location to SharePoint list columns
- Click to select SharePoint Create Item
- Select or type Site address and List Name
- Drag to add Longitude, Latitude and TimeStamp columns as illustrated:
Flow SharePoint Service Create Item
Create mobile notification after SharePoint list updated
- Below the Update SharePoint Flow step, click Add an action
- Click to select Notifications (SERVICES)
- Select Notifications - Send me a mobile notification
Flow Send Mobile Notification service
Add link to notification to show map location
- Add the notification text you would like to see appear on your mobile device when the button is clicked. I used Dude, I know where your car is!
- In the Link field, add the following:
https://www.google.com/maps/place/ - With NO SPACES, drag Longitude, followed by a comma, and then drag Latitude (as illustrated) into the Link field.
- Provide some text which you will click to launch maps on your mobile device into the Link label field.
Flow mobile location link
Save the Flow
- Rename Flow: Dude
- Click the check mark to finish
- To exit the Flow editor page, click the Done arrow
Flow Rename Dude and Save
Test the Flow
- Launch Flow on your mobile device
NOTE: You may need to log in using your Organizational account if it's your first time using. - Click Buttons
NOTE: You may be prompted to access your devices location information, accept and continue. - Click the Dude button
Flow Test Mobile Dude button
Spoiler (Highlight to read)Dude Flow button in action
REF: https://www.youtube.com/watch?v=qWtebXifEdEDude Flow button in actionREF: https://www.youtube.com/watch?v=qWtebXifEdE
You can stop here and happily never loose your car again, otherwise, continue to add in the PowerBI map visuals...
Add PowerBI to map visual data
- Create new Power BI (desktop)
- Click the Get Data button, and select from SharePoint site from the list
- Enter your site address, select carlocation list, and click Load
PowerBI Connect to SharePoint
Add map visualizations in PowerBI
- Click and drag to add ArcGIS Visualization
- Drag Latitude, Longitude and Timestamp from carlocation fields to Visualizations fields as illustrated:
PowerBI map SharePoint columns to Map Visual
Limit location results to show only the last location stored
- Click the Edit Query button
- Filter the TimeStamp column by IsLatest
- Click the Close and Apply button
- Review results
PowerBI limit location to IsLatest
To summarize
We used a simple list in SharePoint to store our location information. We created a Flow button that we access on our mobile device to capture our location information. When the Dude Flow button is pressed, your location data was stored in SharePoint Online, then a notification message appeared on your mobile device indicating success, with a link to the map location which you clicked to launch Google maps, to route you back to your car. We also pulled the location data into Power BI, then showed that location information in a visual map.
Give it a try on your own
It will be fun, I promise and I'll bet that you'll be dropping Dudes' all over town to see your map light up. You may even be thinking about that snow shoe app now... right? I'm looking forward to hearing if and how this article inspired you to come up with an idea based on these features.
Stay tuned as I continue to work out the homeless app. I'll be presenting these demos at upcoming SharePoint user group and SPSaturday events.
Please let me know what you'd like to see demonstrated or if you have any questions about these steps.
Mahalo!
Author: Jennifer Pearcey
@pcmom03
Got Questions?
Comments
-
How to never lose your car again in under 10 minutes using Microsoft Flow
Thanks Johnathan,
Will give that a go.
Regards,
Dan -
How to never lose your car again in under 10 minutes using Microsoft Flow
Hi Dan,
I don't have my PowerBI Desktop running now, but if I recall correctly, you will need to select the "Map" visualization instead.
Johnathan
-
How to never lose your car again in under 10 minutes using Microsoft Flow
I'm struggling to find the ArcGIS PowerBI.
Any ideas?
Thanks,
Dan -
How to never lose your car again in under 10 minutes using Microsoft FlowCheezer looking at the picture i am guessing that the issue is your location is not appearing on the map. If so double check that in the URL you are passing it Latitude and then Longitude (in that order).
-
How to never lose your car again in under 10 minutes using Microsoft Flow
Hi there guys. Great post. Having trouble with my Dude. Any thoughts? Thanks in advance.
-
How to never lose your car again in under 10 minutes using Microsoft Flow
Well said, and thank you @exnav29! The intention of this post to illustrate that an everyday problem could be solved with a simple Flow and to show any O365 subscriber how to do the same, with relative ease.
Let's take the snowshoe case I mentioned above. If I'm snow shoeing a new trail, I could tap a Flow button on my mobile device to pin GPS location at intervals throughout the trail, as well as interesting points. I could share this location information with other fellow snow shoers' so they don't have to make new trails.
Mahalo @JonL! I'm brewing up some fresh content in my kitchen that I'm hoping is useful for anyone trying to get started, or just have some fun learning, while solving a few of lifes little problems.
-
How to never lose your car again in under 10 minutes using Microsoft Flow
@Anonymous Thanks so much for writing this super cool blog post teaching us all how to combine some of the various tools with Flow. You rock! Cant wait for your next post! 🙂
-
How to never lose your car again in under 10 minutes using Microsoft Flow
This is a great article which displays the different components (SharePoint, Flow, and PowerBI) working together. As far as the earlier comment. I think the writer totally misses the point on the purpose of this article. It is to give people a possible scenario that can be used. But more importantly to show how the three components can be arranged to work together. This is a learning tool and for the unitiated it is a good starting point into the world of using Flow.
-
How to never lose your car again in under 10 minutes using Microsoft FlowThis article is misleading! It should have been named "How to never lose your MOBILE again in under 10 minutes using Microsoft Flow if you keep pressing Dude Flow button at least 5000 times every day!" I mean I am already in love with Flow, PowerApps and Power BI, but this is not a good way to market Flow. There are many tracking devices available in the market, better for Microsoft Flow partner with one, or few, then such devices would give signals about location automatically! Frequently and On a Request!, and only then - after article is modified - title of the article would become true.
*This post is locked for comments