Skip to main content
  • Overview
    • Build Apps
    • Automate Processes
    • Connect Data
  • Pricing
  • Partners
    • Partner Showcase
    • Find Consulting Services
    • Find a Partner
    • Become a Partner
  • Learn
    • Documentation
    • Guided Learning
    • Support
    • Roadmap
    • Blog
    • Customer Stories
  • Community
    • Forums
    • Galleries
    • Ideas
    • User Groups
    • Community Blog
  • Register
  • ·
  • Sign In
  • ·
  • Help
Go To
  • PowerApps Community
  • News & Announcements
  • News & Announcements
  • General
  • General Discussion
  • Common Data Services
  • Common Data Service for Apps
  • Best Practices
  • Administering PowerApps
  • Creating Apps
  • Expressions and Formulas
  • Galleries
  • Community Apps Gallery
  • Video Gallery
  • Live Event Recordings
  • Ideas
  • PowerApps Ideas
  • User Groups
  • Professional Connections & Networking
  • Community Blog
  • PowerApps Community Blog
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
  • PowerApps Community
  • Galleries
  • Community Apps Gallery
  • Asset Checkout (Microsoft sample)

Asset Checkout (Microsoft sample)

06-30-2017 10:48 AM - last edited 08-02-2017 20:07 PM

PowerApps Staff mblythe
PowerApps Staff
4772 Views
LinkedIn LinkedIn Facebook Facebook Twitter Twitter
Highlighted
mblythe
PowerApps Staff mblythe
PowerApps Staff

Asset Checkout (Microsoft sample)

  • Mark as New
  • Bookmark
  • Subscribe
  • Subscribe to RSS Feed
  • Permalink
  • Print
  • Email to a Friend
  • Report Inappropriate Content
‎06-30-2017 10:48 AM

 

 asset-checkout-screen.png

  

Description

Keep track of the tools and equipment your teams need to do their jobs. Document, catalog, and reference assets of all kinds with images, location, asset details, and more.

 

Data connections

Excel file stored in a cloud-storage account, such as Box, Dropbox, Google Drive, OneDrive, and OneDrive for Business.

 

Setup and usage info

To run and explore this app, open the Asset Checkout template from web.powerapps.com. For more information, see Create and run an app from a template.

 

Author's helpful tips and formula lessons

> The first screen (HomeScreen) makes use of two galleries: a horizontal gallery to display items that are most frequently checked out; and an image-based gallery, which provides navigation to the second screen (CategoriesScreen). When the app user clicks an image in the gallery, the app sets the "category" context variable (used elsewhere in the app) and navigates to CategoriesScreen.

 

> CategoriesScreen uses the "List screen" layout, which provides a gallery and related navigation. The "Items" property of the gallery uses the following formula:

 

If(category = "Most checked out", Sort(Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName),CountValue,Descending), category = "Reviews", Sort(Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName),Comments,Descending),Filter(Products,CategoryId=CategoriesGallery.Selected.CategoryId && SearchBoxText.Text in ProductName))

 

The gallery displays items based on the category selected on HomeScreen; it sorts those items based on the value of the "category" context variable, which is set on FilterScreen.

 

> DeviceCheckoutScreen and CheckoutScreen work together to enable users to check out devices. DeviceCheckoutScreen uses a display form so a user can view item details, and check out the device. The "Checkout" button uses the following formula:

 

SubmitForm(CheckOutForm);Navigate(CheckoutScreen,ScreenTransition.None,{checkedout:checkedout});NewForm(ReserveForm)

 

This submits the checkout, then navigates to DeviceCheckoutScreen. The app sets the "checkedout" context variable, so the device is not available to other users.

 

> On CheckoutScreen, the form uses built-in functions to set the "Default" property of the "Name" and "Email" fields to the User().FullName and User().Email functions, respectively. It's cool to save users of your apps some typing!

 

> Finally, on ConfirmationScreen, the text label uses the following formula:

 

checkedout.ProductName & " reserved through " & DateValue( Text( ReserveForm.LastSubmit.ReservedUntil ), "en" )

 

This is interesting in how it pulls in information from the last item submitted through ReserveForm.

 

Other Relevant Blogs and Online Resources

Understand data forms in PowerApps

Understand variables in PowerApps

 

 

 

 

 

 

 

 

 

 

 

 

watch?v=sEHsnVIx31E

asset-checkout-thumbnail.png
Report Inappropriate Content
Message 1 of 1
Labels:
  • Galleries and forms
  • Mobile app design and user experience
  • Workflow and process automation
1 Kudo
Reply
  • All posts
  • Previous Topic

Power platform

  • Power BI
  • PowerApps
  • Microsoft Flow
  • Sign in
  • Sign up

Browse

  • Sample apps
  • Services

Downloads

  • Studio
  • iOS
  • Android

Learn

  • Documentation
  • Support
  • Community
  • Give feedback
  • Blog
  • Partners
  • © 2019 Microsoft
  • Privacy & cookies
  • Terms of use
  • Trademarks