Power Apps Check in Check out Inventory Management App

  Рет қаралды 90,980

Shane Young

Shane Young

3 жыл бұрын

Learn how to build an app to manage the checking in and out of loaner items. Lots of little concepts covered including storing pen input as a base64 string and some admin functionality. Power Apps Inventory Management fun.
Download the app by signing up at training.powerapps911.com/cou...
Power Apps Consulting and training at www.PowerApps911.com

Пікірлер: 124
@bideyyusuf
@bideyyusuf 3 жыл бұрын
Shane, you might not have thought about it, but you are saving a LOT of lives with your videos. Thanks so much
@ShanesCows
@ShanesCows 3 жыл бұрын
I appreciate that!
@Omkh4258
@Omkh4258 2 жыл бұрын
Thanks, going to delve into powerapps for work soon. Think your content should help a lot. Keep it up and wish you great success!
@mburt0n
@mburt0n 3 жыл бұрын
Thanks Shane, our team has been looking at ways to manage IT inventory. People on the team are just branching into Power Apps now, they are going to freak out with joy when they see this!
@ShanesCows
@ShanesCows 3 жыл бұрын
Awesome Melissa! I hope they find it a perfect fit.
@steventhawe1598
@steventhawe1598 3 жыл бұрын
Always love your videos. Without you my job would have been alot tougher. Keep up the good work my good sir.
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks Steven. You do the hard work of learning and building. Give yourself a pay on the back.
@bestyapper
@bestyapper Жыл бұрын
Thank you Shane. I also purchased monthly subscription on power apps 911 yesterday, i love it.
@ShanesCows
@ShanesCows Жыл бұрын
Awesome. Thanks. 😎
@necdetsaritas8722
@necdetsaritas8722 3 жыл бұрын
What amazing work! Thank you so much, Shane. You are a real hero.
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks 😊
@EuroWin
@EuroWin Жыл бұрын
Thanks for another great video, Shane! Thanks to your knowledge, I recently got my first App Maker Certificate from Microsoft. Keep it up! 💪
@ShanesCows
@ShanesCows Жыл бұрын
That is awesome!
@GreyDob
@GreyDob 3 жыл бұрын
Thank you Shane, again you managed to learn me some great new tricks to improve things I've build in the past in another way :-)
@ShanesCows
@ShanesCows 3 жыл бұрын
Awesome 🤩
@llusufsn5200
@llusufsn5200 3 жыл бұрын
That's brilliant. You save my life, once again. Thanks a lot, you're definitely the man!
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to help!
@angrybatvoice
@angrybatvoice 3 жыл бұрын
Excellent video as usual! Covered lots of good stuff!
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad you enjoyed it! Hope you are doing well. 😀
@andreash.1364
@andreash.1364 3 жыл бұрын
Hi Shane. Great video, as usual. An awesome combination would be the inventory management with the self-made calendar 🤯 Keep it up 👍
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks and noted. 😎
@stephaniechavez9927
@stephaniechavez9927 3 жыл бұрын
​@@ShanesCows Yes, I am working on this for work and they asked if I can make a calendar or reservation for that item. Can share point do that individual calendar for each item on share point. Thank you in advance for all you do I have learned a lot.
@ricardobunge5957
@ricardobunge5957 3 жыл бұрын
Another gem, Shane - some great tips, tricks, and techniques... Thanks very much! Oh, and the 'bulk delete SP list records' thing? Yep, been there, done that... Recycle bin saved my bacon as well... You have a big celebration planned for your upcoming 100K subscribers? Wooo-hooooo!
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad you shared my pain Ricardo. 😀 I don't know exactly what I am going to do for 100k subs but it should be something awesome! I am very excited.
@ricardobunge5957
@ricardobunge5957 3 жыл бұрын
@@ShanesCows you've definitely earned them! Bring on the clicks! Ding, ding, ding!
@david78642
@david78642 Ай бұрын
I am new to the PowerApps game and found this video immensely helpful. Thank you for creating it!
@ShanesCows
@ShanesCows Ай бұрын
You're very welcome!
@user-do5io6eg3e
@user-do5io6eg3e Жыл бұрын
Shane, this is awesome! I changed a couple things to make it fit my needs better. I adjusted the check-in and check-out items to have a date range instead of defaulting to check-out immediately. I want my items to stay visible outside of this date range, assuming qty available is above zero. What function would you have used to accomplish this?
@edmacintosh5830
@edmacintosh5830 3 жыл бұрын
Great video! I know this was such a minor point in your button code but I did not realize I could "Select" a control from an action on another control. You don't know how many times I wished I could trigger the same action from 2 methods without repeating my code.
@ShanesCows
@ShanesCows 3 жыл бұрын
You're very welcome!
@louismartini6983
@louismartini6983 3 жыл бұрын
Awesome Video Shane Thanks.
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to help. 😀
@finalfant111
@finalfant111 3 жыл бұрын
I really only like to use forms when I have allot of data that needs to be shown. For example, I have a gallery that shows contract data with clients. The gallery shows basic information such as client, type of contract, expiration date, and an icon that visually shows if something is expired. When you click on the item, it brings up a form with a complete showing of all the data related to that item. It is like 30 columns worth of data, I have an edit item button (that only shows up if someone is in an admin list, thank you for that video, it helped with that), that allows you to edit any of the fields and save the data. In a case like this, using the form is MUCH easier and less time consuming. If I had to create an individual control for every items, this thing would be massive and very time consuming.
@sininv1
@sininv1 3 жыл бұрын
Hi Shane This is really great. I try to set hardcode taken as 1. Do I remove dropdown.text and put 1 Also can you kindly advice the patch to return 1 to admin list and overall record? Thanks
@calvinmunisi346
@calvinmunisi346 3 жыл бұрын
Hi Shane, great video. Please assist whenever i select the > button on Gallery, the input controls dont show despite me adding "varShowSignOutForm" on their visible property. did i miss something? watched the video over 20 times but i still get this.
@rodamalco9757
@rodamalco9757 Жыл бұрын
Hi Shane - powerapp newbie here. Had a question about the sign out form. Is the sign out form a page? How did you create the variable for the whole page when it’s made up of individual fields?
@rossmarvin6078
@rossmarvin6078 Жыл бұрын
Im a newbie - when you started mentioning variables i got lost! Aside from me fetting lost, i love your videos, super easy to follow
@ShanesCows
@ShanesCows Жыл бұрын
This video will help with variables Ross. kzfaq.info/get/bejne/o6maZLtnsLi9las.html Thanks for the kind words.
@rossmarvin6078
@rossmarvin6078 Жыл бұрын
@@ShanesCows legend thank you! I'll get on this today and then my apps nearly done 🙏🏼
@mollybrinkley9212
@mollybrinkley9212 2 жыл бұрын
First time using Power Apps and I have been able to follow along pretty well. I'm stuck though because my app looks appropriate for phone, but yours is tablet size. When I create the settings for the next arrow, the other side's information for the dates and signature does not populate. What am I missing?
@JC-tt5lj
@JC-tt5lj Жыл бұрын
Hello there! I'm not sure if I missed this part in the video or not, but how are your selected choices in the gallery getting greyed out? I've went through your video a couple times and can't find if you've spoken about it! Other than that, I was able to follow your tutorial pretty easily. Thanks for your time!
@seanenright474
@seanenright474 2 жыл бұрын
Great video Shane! How would you go about updating the inventory if lets say you got more Pacman toys? Would you update the list or make another app to select the item and update the quantity?
@ShanesCows
@ShanesCows 2 жыл бұрын
I would have an admin screen that let me manage the quantities in the list. Should be a simple UI. Find pacman and set total qty to the new number.
@consciouslyconsumed3801
@consciouslyconsumed3801 3 жыл бұрын
Thank you!
@ShanesCows
@ShanesCows 3 жыл бұрын
You bet!
@op8641
@op8641 3 жыл бұрын
Thank you for the video. I was wondering how to do it if you have a "bundle" of things and like to add them in one go rather each item individual? Thank you
@ShanesCows
@ShanesCows 3 жыл бұрын
You would have more patch functions when you press the button.
@sundrapillay6668
@sundrapillay6668 3 жыл бұрын
Thanks Shane
@ShanesCows
@ShanesCows 3 жыл бұрын
You bet! Have a great week Sundra
@louiscutmore
@louiscutmore 3 жыл бұрын
Absolutely brilliant! On the Yep button1 in the confirm return popup - how do would you allow users to return 1 of multiple borrowed? Add a dropdown of the numberOfItemsBorrowed, default to allItemsBorrowed then allowed to adjust the value and patch the number chosen? Would that work? Like button pounded! 👍
@ShanesCows
@ShanesCows 3 жыл бұрын
Sounds perfect to me!
@jonatell011
@jonatell011 2 жыл бұрын
Hi Shane, How are you getting your thumbnails of your pictures to show? I've done the same column as ItemImage and unsure on how to upload my own picture to make that item's thumbnail. Only option is to "enter image url"
@labuerostuhl
@labuerostuhl 3 жыл бұрын
Thank you so much for this video! Is there a way to change the delimiter from ',' to ';'? With using the German version of PowerAutomate and PowerApps, I have the problem that Excel shows all the data of the csv File in one row. To read the data I have to manually use "Text to columns" in Excel. Do you have any ideas how to fix this?
@ShanesCows
@ShanesCows 3 жыл бұрын
I don’t. I wonder if you could maybe replace all of the , with ; via a flow loop of some sort. Not sure though.
@slcoach
@slcoach 2 жыл бұрын
Hello, Shane I'm a coach looking to inventory our football equipment for check in, check out purposes. This looks almost perfect. Is there a way to use a scanner on phone to scan barcoded helmets/shoulder pads etc. and check them out to an individual player. I would have almost 120 players in the program each needed anywhere between 4-8 pieces of equipment. Watching your videos I have no doubt that its possible and that you are the man. Is there another video that shows this exact thing or would it be possible to contact you another way to get more detail or even pay you for something like this. Please let me know, thank you!!
@ShanesCows
@ShanesCows 2 жыл бұрын
Brian did you see this video? kzfaq.info/get/bejne/ob2Fqdelx7_UpWg.html It shows using the phone barcode scanner. This one shows the inventory app and NFC tag scanning. If you meld the topics you ahve what you want. kzfaq.info/get/bejne/Y7B8ms1q0ZiZn58.html Or you can hit up www.PowerApps911.com for more proper help if need be.
@jaimesca81
@jaimesca81 3 жыл бұрын
Thanks Shane, as awesome as usual!!!!!,, I have a question regarding the 'itemimage' column. I can see that you can show the image on the gallery and on the SharePoint list. I couldn't have figured out how you do that. Don't know if you may help me with that may be in a new video or on comments here
@ShanesCows
@ShanesCows 3 жыл бұрын
The column is a HyperLink column set to the Picture setting in SharePoint.
@jaimesca81
@jaimesca81 3 жыл бұрын
And how can I show it at the gallery? I've tried with thumbnail small, but it doesn't work for me.
@iyengar007
@iyengar007 3 жыл бұрын
Thanks Shane. Loved it. Gotta steal every bit of it. This could be awesome Hackathon project too isn't? In the meantime, do you have a short time for quick tip? Say, I have a list wth 20+ coulms and I would like to use two screens to accept the input. Fist screen has 10 cokumns with next page and 2nd screen has 10 coumns with submit button. easy peasy lemon squeezy right? I would like to show that to my students.
@ShanesCows
@ShanesCows 3 жыл бұрын
Rama you would want to use Patch. Have screen 1 have inputs for your first fields and then screen 2 have inputs for your second fields. When they are done Patch can pull data from both screens. :) I should really make a video on this.... added it to my list. Thanks
@iyengar007
@iyengar007 3 жыл бұрын
@@ShanesCows do I need to say thank you or love you buddy?
@kusulabasava2717
@kusulabasava2717 2 жыл бұрын
Could you please share a video of this from begining onwards
@sg8345
@sg8345 2 жыл бұрын
Brand new to powerapps. I'm trying to create an app for my staff to be able to check in and check out toys from our inventory. I built a basic Microsoft List and then I discovered this video and it looks way cooler than Lists. Can you please point me to which of your videos I should watch to learn how to get my powerapp built?
@papasheev8924
@papasheev8924 4 ай бұрын
Did you ever find a tutorial for it?
@VANDIK01
@VANDIK01 2 жыл бұрын
Awesome video Shane, you save me a lot..... can I download (buy) this video and the app through the PowerApps 101?
@ShanesCows
@ShanesCows 2 жыл бұрын
If you go to training.powerapps911.com/courses/video-library you can subscribe and download this and other example apps.
@a194321
@a194321 2 жыл бұрын
Hi Shane, first of all thank you for your hard work. I was wondering if i could combine your video 'Select muliple items from gallery' with this video. I want to achieve exactly what is discribed in this viedeo but what happens when for example, user shane wants to borrow a Chewy Toy AND a Ghost Toy. Grts
@rohanshaw1827
@rohanshaw1827 Жыл бұрын
Hi Shane, Currently working on something similiar to this. Now that there is the image column in sharepoint, would you do the signature differently?
@ShanesCows
@ShanesCows Жыл бұрын
I would not. The Image column is "weird" under the covers so I don't use it in most scenarios.
@JoeCole_social
@JoeCole_social 2 жыл бұрын
So I connected my data source(s), and followed the video to the "T". I have no visible errors, but if I reserve an item for next week, let's say the 29th, it's removed from the gallery as an available item for today the 22nd. Any thoughts?
@viruscop2
@viruscop2 2 жыл бұрын
Amazing work dude! Wonder why when i click on the toggle "Show previously returned items?" the "Return Item" still appear? suppossed to be hide rite?
@ShanesCows
@ShanesCows 2 жыл бұрын
Check your filter and adjust as necessary. I had mine so show previously returned items shows everything. Maybe not ideal
@Deadpool12353
@Deadpool12353 3 жыл бұрын
Shane how do we print the document out as an invoice, can you do a video..it should be a continuation video right?
@ShanesCows
@ShanesCows 3 жыл бұрын
Make a pdf. kzfaq.info/get/bejne/aNiWdLSWltGvaIE.html I like your idea of making a continuation video for this also. It is on my list now.
@Govindahya
@Govindahya 3 жыл бұрын
Hi Shane, i am trying send email to different people and i want to send all the selected options in (dropdown, radio button, lable name etc) in body of email from power app. I looked into your video of concate or the one with outlook send email v2. Could you please Any ideas that you may have for me to solve this- many thanks in advance!
@VANDIK01
@VANDIK01 2 жыл бұрын
Question, How can I use a TextInput instead of ComboBox and add multiple items? thanks in advance.
@ppei2012
@ppei2012 3 жыл бұрын
Thank you, Shane! I have to like this video. I have a question. I tried but I could not show the signature in App though I can see the image text in SharePoint. Do you have any idea how I can fix it?
@ShanesCows
@ShanesCows 3 жыл бұрын
Just have to look at your syntax. Compare what you got when doing the json vs what you see after you get it back. You must be losing a character. I explain base64 in this video for more info. kzfaq.info/get/bejne/mK-emJZ1qZmscZs.html
@ppei2012
@ppei2012 3 жыл бұрын
@@ShanesCows Thank you for your help, Shane. It turned out that I wrongly set up signature column in Enhanced rich text format. After I set up it in Plain text format, it works as expected.
@myounis
@myounis 3 жыл бұрын
Awesome video, as usual, I have a question please, If I have an inventory app with 3 conditions add, subtract, and transfer from store to store, how can I handle the transfer part here am using SharePoint list, I work with add and subtract normally without any issue but I cannot go with the transfer part , Thanks in advance
@ShanesCows
@ShanesCows 3 жыл бұрын
I would assume you have a field that is Store. You should be able to patch the store field in a similar manner.
@myounis
@myounis 3 жыл бұрын
@@ShanesCows Yes I have a field for each store the point is how am going to deduct an item from one store and add it to another store in the same transaction without having to use manual input
@ShanesCows
@ShanesCows 3 жыл бұрын
Remember you can do more than one patch in the same button press like we did here. You just need to have more patches.
@NtetheleloButhelezi-bh8bp
@NtetheleloButhelezi-bh8bp Ай бұрын
Hi shane can you make a video on how to : To download all users across different applications in an inventory application on Power Apps using Power Automate, you'll need to create a centralized Power Automate flow that can:
@ShanesCows
@ShanesCows 25 күн бұрын
I will put it on my list of things to consider but no promises.
@itubeHirschberg
@itubeHirschberg 3 жыл бұрын
Hello a video about Dataverse rights assignment would be interesting. How (and where) do I set who can only see data/ who can edit the data ...
@bideyyusuf
@bideyyusuf 3 жыл бұрын
I think a LookUP would do that....maybe creating a user group, to give access to who you want to see a data and who you want to edit.
@sininv1
@sininv1 3 жыл бұрын
hi Shane, this is very good but I like to default for loan as 1 every time, how to do it . Thanks
@ShanesCows
@ShanesCows 3 жыл бұрын
You can set the Default property of dropdown to 1. Or you can hard code in the patch the quanity is 1 and not ask the user.
@Bostradamus
@Bostradamus Ай бұрын
Can you perform this same concept in a model driven app?
@facundopoblet954
@facundopoblet954 2 жыл бұрын
hi shane!, thanks for the video. I have a question, i just want a buttom to check out an item in my inventory, without the signature. In my data base i have "number of items available", and when someone check out a material i want that amount go down. Can you help me please?, kind regards from Argentina.
@ShanesCows
@ShanesCows 2 жыл бұрын
This video I show how to reduce quantity. Did that not work for you?
@cvkealey
@cvkealey 3 жыл бұрын
I've built a few apps like this but most never get to production because I haven't found a good way to handle the "race condition" of multiple people trying to "sign out" or "borrow" or "book" the same item at the same time. Power Apps (in my experience) doesn't handle those kinds of "real time" transactions very well, but maybe you've figured out some way around this particular issue? FWIW, I'm strictly using SharePoint as my data source (which I know is probably a big part of the issue; SQL or Dataverse would probably be faster).
@ShanesCows
@ShanesCows 3 жыл бұрын
Chad in the race conditions I have just had to deal with it. Meaning I wrote logic to create locks to check for and avoid conflicts. It was a pain in the butt but worked in the end. Lots of back and forth to make sure people truly get the record they wanted.
@begumdost381
@begumdost381 Жыл бұрын
what does sharedItemPatch stands for in 21.04?
@mardithpascua8112
@mardithpascua8112 3 жыл бұрын
hi shane. did u encounter an error in Form Control stuck in loading dots (Preview Mode) when item is selected in a gallery then the canvas will also stops and forcing u to close and reopen the app? Thank you
@ShanesCows
@ShanesCows 3 жыл бұрын
I have not. Check the formula for your ITems property of the form.
@mardithpascua8112
@mardithpascua8112 3 жыл бұрын
@@ShanesCows form control Item property only consist of "LookUp()"
@errol7133
@errol7133 2 ай бұрын
Shane, what if I want to borrow the item in the future, maybe 5 days from today?
@ShanesCows
@ShanesCows 2 ай бұрын
Add a date picker for check out date also? Then instead of patching Now() patch the value of that date picker.
@adamcarter6576
@adamcarter6576 3 жыл бұрын
Hello, having an issue, hope you can help. When I press the return item button it adds the item back to the original list as I want it to but then I am ending up with 7 of 4 available instead of say 4 of 4. Any ideas what I may have done wrong? thanks, adam
@ShanesCows
@ShanesCows 3 жыл бұрын
Adam check the math. Did you add instead of subtract?
@adamcarter288
@adamcarter288 3 жыл бұрын
@@ShanesCows thanks for quick reply. Pretty sure i did a - but will double check everything tomorrow. Only thing i did differently to your video was not use the toggle control. Iv’e never used one & i assume they quite simple so you didn’t explain it in this vid but i’m guessing you will have covered it in another so i will hunt it out. Thanks
@adamcarter6576
@adamcarter6576 3 жыл бұрын
@@ShanesCows My bad, I'd set the SharePoint list up incorrectly. For some reason when setting it up for some reason I put an amount in the on-loan column.
@LamNguyen-jp5vh
@LamNguyen-jp5vh 2 жыл бұрын
Hi Shane, I have a question about patch. When I use patch to update the Shared Equipment list, the NumberOnLoan did not update but it created a new item in the list. Can you help me fixing this?
@LamNguyen-jp5vh
@LamNguyen-jp5vh 2 жыл бұрын
Nvm, I already fixed it. The video is so amazing. Thank you so much for your help!
@ShanesCows
@ShanesCows 2 жыл бұрын
Awesome! Glad you got it working!
@SoNonWoo
@SoNonWoo 5 ай бұрын
Any chance yall could get yourselves on Udemy?
@ShanesCows
@ShanesCows 5 ай бұрын
Nope. We have our own platform on training.powerapps911.com Sorry
@user-nt4yq4tx8y
@user-nt4yq4tx8y 5 ай бұрын
How much is this system/code?
@ShanesCows
@ShanesCows 5 ай бұрын
Not sure what you mean? I wrote all of it though using drag and drop and the Excel like language Power FX. No pro code here.
@user-nt4yq4tx8y
@user-nt4yq4tx8y 5 ай бұрын
@ShanesCows thanks for writing back. Does the system require the premium power app license?
@mohdhafizi7942
@mohdhafizi7942 2 жыл бұрын
varShowSignOutForm why no showing anything. sorry to say it's hard for a newbie to follow what you're doing.
@natalyaoliveira6264
@natalyaoliveira6264 Жыл бұрын
!varShowSignOutForm
@sweetiejackylyn
@sweetiejackylyn Ай бұрын
its good but this not inventory management.. this is just like a loan equipment app..
@ShanesCows
@ShanesCows Ай бұрын
That is fair, maybe the one with barcodes will be a bit closer to what you are looking kzfaq.info/get/bejne/Z9icg8emqbbDdas.html
@babypooful
@babypooful Жыл бұрын
hmm too complicated...
@faharalzadjali5606
@faharalzadjali5606 Жыл бұрын
Hello Shane Young , Kindly I need to contact with I have some idea to discuss.
@ShanesCows
@ShanesCows Жыл бұрын
You can go to www.PowerApps911.com and fill out the contact form. 😎
@faharalzadjali5606
@faharalzadjali5606 Жыл бұрын
@@ShanesCows great I sent you now and i hope you give me a chance to open a small meeting via team
Power Apps Button at the bottom of gallery
7:32
Shane Young
Рет қаралды 19 М.
Power Apps Shopping Cart new for 2021
41:28
Shane Young
Рет қаралды 94 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 20 МЛН
DEFINITELY NOT HAPPENING ON MY WATCH! 😒
00:12
Laro Benz
Рет қаралды 60 МЛН
Who has won ?? 😀 #shortvideo #lizzyisaeva
00:24
Lizzy Isaeva
Рет қаралды 65 МЛН
Build Cloud Inventory Management App using power apps and SharePoint
28:09
Productivity Central
Рет қаралды 116 М.
Asset Checkout Template Overview - Build a Power App Today
11:04
Bulb Digital
Рет қаралды 18 М.
Power Apps Visitor Gate Entry Check-In Checkout with SharePoint List
33:05
Power Apps Barcode  Scanning *Reboot*
20:28
Solved Systems
Рет қаралды 19 М.
Build an Inventory Management App using PowerApps | Tutorial | Step by step
24:54
Shopping Cart in PowerApps
18:42
MS Power Platform Tutorials
Рет қаралды 43 М.
How to Improve Teams Meetings with Loop!
13:27
Scott Brant
Рет қаралды 68 М.
Kumanda İle Bilgisayarı Yönetmek #shorts
0:29
Osman Kabadayı
Рет қаралды 1,5 МЛН
BEKMOBILDA Tecno Camon 30 smartfoni🔥🤩 #bekmobil
1:01
Bekmobil shorts
Рет қаралды 2,3 МЛН
Rate This Smartphone Cooler Set-up ⭐
0:10
Shakeuptech
Рет қаралды 3,6 МЛН