Тёмный

Power Apps Check in Check out Inventory Management App 

Shane Young
Подписаться 163 тыс.
Просмотров 90 тыс.
50% 1

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

Наука

Опубликовано:

 

25 апр 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 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!
@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.
@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.
@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 😊
@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!
@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 🤩
@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!
@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. 😀
@david78642
@david78642 23 дня назад
I am new to the PowerApps game and found this video immensely helpful. Thank you for creating it!
@ShanesCows
@ShanesCows 23 дня назад
You're very welcome!
@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.
@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!
@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?
@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!
@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.
@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!
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mCj1X6KRYew.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?
@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?
@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
@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"
@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.
@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!
@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.
@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
@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!
@sundrapillay6668
@sundrapillay6668 3 года назад
Thanks Shane
@ShanesCows
@ShanesCows 3 года назад
You bet! Have a great week Sundra
@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?
@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.
@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.
@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 3 месяца назад
Did you ever find a tutorial for it?
@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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kWUvttbYpu4.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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE--JLgj9l25ok.html Or you can hit up www.PowerApps911.com for more proper help if need be.
@VANDIK01
@VANDIK01 2 года назад
Question, How can I use a TextInput instead of ComboBox and add multiple items? thanks in advance.
@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?
@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!
@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.
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-bIne3DD3HAg.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.
@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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2rfAQe1kK8M.html I like your idea of making a continuation video for this also. It is on my list now.
@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
@kusulabasava2717
@kusulabasava2717 2 года назад
Could you please share a video of this from begining onwards
@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?
@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()"
@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.
@Bostradamus
@Bostradamus Месяц назад
Can you perform this same concept in a model driven app?
@begumdost381
@begumdost381 11 месяцев назад
what does sharedItemPatch stands for in 21.04?
@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.
@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.
@NtetheleloButhelezi-bh8bp
@NtetheleloButhelezi-bh8bp 21 день назад
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 16 дней назад
I will put it on my list of things to consider but no promises.
@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.
@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.
@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.
@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 4 месяца назад
How much is this system/code?
@ShanesCows
@ShanesCows 4 месяца назад
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 4 месяца назад
@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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1rlPduDP_Ew.html
@babypooful
@babypooful 11 месяцев назад
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
Просмотров 19 тыс.
Power Apps Shopping Cart new for 2021
41:28
Просмотров 93 тыс.
Прятки #nyanmp3
00:25
Просмотров 1,8 млн
O-Zone - Numa Numa yei на русском!🤓
00:56
Просмотров 255 тыс.
PowerApps Read NFC Tag to manage inventory
11:17
Просмотров 25 тыс.
Power Apps Examples: Checklist Inspection App
7:39
Просмотров 59 тыс.
Power Apps Barcode Scanner For Inventory Records
8:06
Asset Management with Barcodes in Power Apps
19:51
Просмотров 23 тыс.
ЗАКОПАЛ НОВЫЙ ТЕЛЕФОН!!!🎁😱
0:28
Собери ПК и Получи 10,000₽
1:00
Просмотров 2,7 млн
Wylsa Pro: опять блокировка YouTube?
17:49
Wylsa Pro: опять блокировка YouTube?
17:49