Skip to main content

Notifications

Community site session details

Community site session details

Session Id : T9+7Nu+/vQmqHWIFh0Mbm2

Asset Checkout (Microsoft sample)

mblythe Profile Picture Posted 03 Aug 2017 by mblythe

 

 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

 

 

 

 

 

 

 

 

 

 

 

 

Categories:

Mobile App Design and User Experience

Comments

  • Moto-moto Profile Picture Moto-moto 65
    Posted 03 May 2023 at 14:16:20
    Asset Checkout (Microsoft sample)

    can you send me the template please as it is not available anymore

  • Moto-moto Profile Picture Moto-moto 65
    Posted 03 May 2023 at 14:14:32
    Asset Checkout (Microsoft sample)

    where can i download this template and try because it is not available here

  • high-solutions Profile Picture high-solutions 26
    Posted 07 Feb 2022 at 20:58:31
    Asset Checkout (Microsoft sample)

    Hi there,

    I used this template for equipment checkout and it works great, but I can't figure out where "WaitUntil" from the Products datasource excel sheet is managed.

    For some reason it's not used anymore in my app hence reserved items is never coming free after the date expired.

    How does the date expiration work in this app?

     

    greetings

  • Community Power Platform Member Profile Picture Community Power Pla...
    Posted 02 Dec 2019 at 01:20:56
    Asset Checkout (Microsoft sample)

    Hi there, is it possible to convert the data source over to SharePoint lists? I exported the excel to a SP list in preparation. Obviously have an excel based file stored in an individuals OneDrive account is not an enterprise solution. Being able to use this template with SharePoint would be extremely "Powerful"