際際滷

際際滷Share a Scribd company logo

Dude, where's my car?

Download as PPTX, PDF
Jennifer Pearcey
Jennifer Pearcey

Using SharePoint list, Flow and PowerBI the steps in this slide will walk you through setting up a Dude, where's my car button for your mobile device to track where you left your car. This demo was provided at SharePoint Saturday, on Friday in Honolulu, HI by Jennifer Pearcey

1 of 17
Download to read offline
Platinum Gold Silver Bronze Special thanks to our facility sponsors at
SharePoint, Flow and PowerBI Oh my!
Flow 112 Service connections Templates galore! Save Flows, Re-run Flows, button Triggers (demo) Upcoming webinars: http://bit.ly/2nFEvGe
PowerApps Released to general availability as of late last year Available to subscribers within your tenant Get to know or expand your Excel formula knowledge Explore the templates provided to peek at the functionality baked into in each
PowerBI Available in modern pages when all users are consuming First Release Free PowerBI service (still requires O365 account) Pro 9.99/mo Hourly refreshes 1m rows per hour streaming data more https://powerbi.microsoft.com/en-us/pricing/?b=1 Deep dive into PowerBI June 12/13 Data Insights
DEMOS Oh my!
Step 1 Create a new SharePoint list Create a new SharePoint (custom) List: carlocation Add columns as illustrated
Step 2 Create new Flow Navigate to flow.Microsoft.com, login and Create a new (blank) Flow button for mobile: Dude
Step 3 Connect SP list New Step, Add an action and select SharePoint
Step 4 Update SP list Create SharePoint item, select Site address and List Name to populate. Add columns as illustrated
Step 5 Create mobile notification after list is updated Below the Update SP list, Add an action and select (mobile) Notifications
Step 6 Save the Flow Rename Flow: Dude Check mark to finish.
Step 8 Test the Flow Launch Flow on your mobile device, click Buttons. Click Dude button. Check SP list
Step 9 Add PowerBI to map visual data Create new PowerBI (desktop). Get Data from SharePoint site. Select carlocation and click Load
Step 10 Add map visuals Drag to add ArcGIS Visualization then map Latitude, Longitude and Timestamp
Step 11 Limit location results to show only the latest result Edit Query, filter TimeStamp by Is Latest. Click the Close and Apply button and review results
@pcmom03 jenniferpearcey@eworldes.com linkedin.com/in/jennifer-pearcey- 09603617 Got questions?

More Related Content

Dude, where's my car?

  • 1. Platinum Gold Silver Bronze Special thanks to our facility sponsors at
  • 2. SharePoint, Flow and PowerBI Oh my!
  • 3. Flow 112 Service connections Templates galore! Save Flows, Re-run Flows, button Triggers (demo) Upcoming webinars: http://bit.ly/2nFEvGe
  • 4. PowerApps Released to general availability as of late last year Available to subscribers within your tenant Get to know or expand your Excel formula knowledge Explore the templates provided to peek at the functionality baked into in each
  • 5. PowerBI Available in modern pages when all users are consuming First Release Free PowerBI service (still requires O365 account) Pro 9.99/mo Hourly refreshes 1m rows per hour streaming data more https://powerbi.microsoft.com/en-us/pricing/?b=1 Deep dive into PowerBI June 12/13 Data Insights
  • 7. Step 1 Create a new SharePoint list Create a new SharePoint (custom) List: carlocation Add columns as illustrated
  • 8. Step 2 Create new Flow Navigate to flow.Microsoft.com, login and Create a new (blank) Flow button for mobile: Dude
  • 9. Step 3 Connect SP list New Step, Add an action and select SharePoint
  • 10. Step 4 Update SP list Create SharePoint item, select Site address and List Name to populate. Add columns as illustrated
  • 11. Step 5 Create mobile notification after list is updated Below the Update SP list, Add an action and select (mobile) Notifications
  • 12. Step 6 Save the Flow Rename Flow: Dude Check mark to finish.
  • 13. Step 8 Test the Flow Launch Flow on your mobile device, click Buttons. Click Dude button. Check SP list
  • 14. Step 9 Add PowerBI to map visual data Create new PowerBI (desktop). Get Data from SharePoint site. Select carlocation and click Load
  • 15. Step 10 Add map visuals Drag to add ArcGIS Visualization then map Latitude, Longitude and Timestamp
  • 16. Step 11 Limit location results to show only the latest result Edit Query, filter TimeStamp by Is Latest. Click the Close and Apply button and review results