Power Apps Check in Check out Inventory Management App
Вставка
- Опубліковано 3 жов 2024
- 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.power...
Power Apps Consulting and training at www.PowerApps9...
Shane, you might not have thought about it, but you are saving a LOT of lives with your videos. Thanks so much
I appreciate that!
Always love your videos. Without you my job would have been alot tougher. Keep up the good work my good sir.
Thanks Steven. You do the hard work of learning and building. Give yourself a pay on the back.
Thank you Shane. I also purchased monthly subscription on power apps 911 yesterday, i love it.
Awesome. Thanks. 😎
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!
Awesome Melissa! I hope they find it a perfect fit.
I am new to the PowerApps game and found this video immensely helpful. Thank you for creating it!
You're very welcome!
Thanks for another great video, Shane! Thanks to your knowledge, I recently got my first App Maker Certificate from Microsoft. Keep it up! 💪
That is awesome!
Im a newbie - when you started mentioning variables i got lost!
Aside from me fetting lost, i love your videos, super easy to follow
This video will help with variables Ross. ua-cam.com/video/mCj1X6KRYew/v-deo.html Thanks for the kind words.
@@ShanesCows legend thank you! I'll get on this today and then my apps nearly done 🙏🏼
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 :-)
Awesome 🤩
What amazing work! Thank you so much, Shane. You are a real hero.
Thanks 😊
That's brilliant. You save my life, once again. Thanks a lot, you're definitely the man!
Glad to help!
Thanks, going to delve into powerapps for work soon. Think your content should help a lot. Keep it up and wish you great success!
Excellent video as usual! Covered lots of good stuff!
Glad you enjoyed it! Hope you are doing well. 😀
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.
You're very welcome!
Hi Shane. Great video, as usual. An awesome combination would be the inventory management with the self-made calendar 🤯 Keep it up 👍
Thanks and noted. 😎
@@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.
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!
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.
@@ShanesCows you've definitely earned them! Bring on the clicks! Ding, ding, ding!
Awesome Video Shane Thanks.
Glad to help. 😀
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.
Hi Shane , this was really helpful. I’m stuck on how the Group Confirm popped up when you select return item. Mine stays visible on screen
This video tackles pop ups again, maybe it will help ua-cam.com/video/BL7a5PmgZoc/v-deo.html
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?
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?
Check your filter and adjust as necessary. I had mine so show previously returned items shows everything. Maybe not ideal
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.
Shane, what if I want to borrow the item in the future, maybe 5 days from today?
Add a date picker for check out date also? Then instead of patching Now() patch the value of that date picker.
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:
I will put it on my list of things to consider but no promises.
@@ShanesCows I have a power apps Application called Inventory Production, that has all the apps that are in power apps environment so how can i go through that Inventory Production app and get all the users That are using the apps that are in inventory production application can you please create power automate flow .
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!
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!!
Brian did you see this video? ua-cam.com/video/kWUvttbYpu4/v-deo.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. ua-cam.com/video/-JLgj9l25ok/v-deo.html Or you can hit up www.PowerApps911.com for more proper help if need be.
Can you perform this same concept in a model driven app?
Awesome video Shane, you save me a lot..... can I download (buy) this video and the app through the PowerApps 101?
If you go to training.powerapps911.com/courses/video-library you can subscribe and download this and other example apps.
Set(varRecord3, ThisItem) When setting the onSelect property for the return button, ThisItem is not a valid value. What are we supposed to use these days to set the varRecord3 value?
ThisItem is only valid inside of a gallery. If you are in a gallery then I would assume you might have used varRecord3 alrady for something else. Maybe try varRecord4. Everything still works exactly like shown in this video. None of the mechanics have changed.
@@ShanesCows Thank you. Watching the video, I knew the return button was selected when you are adjusting the onSelect property on the return screen, and it is. However, my mistake is that the return button is not "in" the gallery, and I can't figure out how to get it into the gallery's group in the tree view. How do I insert that return button into the gallery, and not just on the page?
Never mind on that part. For anyone reading, if you want to add a button to a gallery, simply click the little edit icon in the top left corner of the gallery WHILE YOU HAVE THE GALLERY SELECTED. Then, simply insert the button, and it will show up for each item in the gallery table. Thanks for your help Shane!
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?
Did you ever find a tutorial for it?
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
You would have more patch functions when you press the button.
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.
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
@@ShanesCows do I need to say thank you or love you buddy?
Thank you Shane. but why can't i make the signature to show as an image. when i use thisitem.Signature, i only see the base64 on the gallery in the app?
Did you put ThisItem.Signature in the Image property of an Image control?
Thank you. I dont what i was thinking when i put in text label to display the signature. It works now!
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?
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! 👍
Sounds perfect to me!
Thank you!
You bet!
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).
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.
Shane how do we print the document out as an invoice, can you do a video..it should be a continuation video right?
Make a pdf. ua-cam.com/video/2rfAQe1kK8M/v-deo.html I like your idea of making a continuation video for this also. It is on my list now.
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?
Thanks Shane
You bet! Have a great week Sundra
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
what does sharedItemPatch stands for in 21.04?
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
The column is a HyperLink column set to the Picture setting in SharePoint.
And how can I show it at the gallery? I've tried with thumbnail small, but it doesn't work for me.
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?
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.
Could you please share a video of this from begining onwards
hi Shane, this is very good but I like to default for loan as 1 every time, how to do it . Thanks
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.
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?
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.
This video I show how to reduce quantity. Did that not work for you?
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
varShowSignOutForm why no showing anything. sorry to say it's hard for a newbie to follow what you're doing.
!varShowSignOutForm
Question, How can I use a TextInput instead of ComboBox and add multiple items? thanks in advance.
Hi Shane,
Currently working on something similiar to this.
Now that there is the image column in sharepoint, would you do the signature differently?
I would not. The Image column is "weird" under the covers so I don't use it in most scenarios.
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?
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. ua-cam.com/video/bIne3DD3HAg/v-deo.html
@@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.
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
I would assume you have a field that is Store. You should be able to patch the store field in a similar manner.
@@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
Remember you can do more than one patch in the same button press like we did here. You just need to have more patches.
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?
I don’t. I wonder if you could maybe replace all of the , with ; via a flow loop of some sort. Not sure though.
Any chance yall could get yourselves on Udemy?
Nope. We have our own platform on training.powerapps911.com Sorry
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"
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
Adam check the math. Did you add instead of subtract?
@@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
@@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.
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 ...
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.
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!
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
I have not. Check the formula for your ITems property of the form.
@@ShanesCows form control Item property only consist of "LookUp()"
How much is this system/code?
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.
@ShanesCows thanks for writing back. Does the system require the premium power app license?
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?
Nvm, I already fixed it. The video is so amazing. Thank you so much for your help!
Awesome! Glad you got it working!
its good but this not inventory management.. this is just like a loan equipment app..
That is fair, maybe the one with barcodes will be a bit closer to what you are looking ua-cam.com/video/1rlPduDP_Ew/v-deo.html
hmm too complicated...
Hello Shane Young , Kindly I need to contact with I have some idea to discuss.
You can go to www.PowerApps911.com and fill out the contact form. 😎
@@ShanesCows great I sent you now and i hope you give me a chance to open a small meeting via team