Build Cloud Inventory Management App using power apps and SharePoint

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024

Комментарии • 121

  • @4NasirAlDeen
    @4NasirAlDeen 7 месяцев назад +4

    Fantastic video, well-paced with detailed explanations. Thanks a million. Cheers!

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  7 месяцев назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀 Do comment if you want a specific topic video to be made in the future

  • @ammarshaikh833
    @ammarshaikh833 5 месяцев назад +4

    Excellent video, Explanation was Great, please upload more Such Content. You have to come back for an incredible Content like this.we want more content from you.
    Thanks

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  5 месяцев назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀 Do comment if you want a specific topic video to be made in the future

    • @ammarshaikh833
      @ammarshaikh833 5 месяцев назад

      @@ProductivityCentralChannel Detailed Video on Patch and Variable, How to use these Two Functions, and How to make a leave application in Powerapps, using SharePoint as a data Source.
      Please Upload videos which is helpful for us.
      Thank you so much for the reply❤️

  • @vicenteconsing
    @vicenteconsing 5 месяцев назад

    Good day, I am so happy to find you here, this is what i am actually looking for, how to create a log in page for each of our Teachers in the Agency. My next goal is to be able to create a sort of a table wherein each teacher can see the benefits that are being credited to her bank account, it should be able to show the date when the benefit was credited, what specific benefit it was and the amount of benefit, basically it should look like a payment history where a particular teacher will be able to view all of her benefits in a tabular format with the most recent being on top of the list whenever he or she logs in. Thank you so much, i hope to hear from you very very soon,

  • @christopherbrown1082
    @christopherbrown1082 Год назад +3

    Thank you for this great tutorial! I have been struggling with how to accomplish this for 3 years while trying to use excel and sharing it with workers. It hasn't been great as they constantly edit fields or delete rows of data by accident. I am going to try to build this today with a modification of creating and linking a repair log to the inventory list.

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @sararodriguezperez1111
    @sararodriguezperez1111 Год назад +2

    Thank you for your content! Love the way you explain, you have helped me a lot with Power Apps.👏

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Happy to hear that 😊 Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @srinivasgarnepudi1800
    @srinivasgarnepudi1800 Год назад +2

    Nice explanation , i'm looking for the video inventory management tool where we go via approval process for asset request and need to generate a mail when requested & returned the asset ,here conditions require is when asset assigned then need to remove from instock and when it returned it has to display as part of instock , if possible kindly make a video related to this

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад +1

      Nice suggestion for future videos. Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @realbenedictik
    @realbenedictik 4 месяца назад +1

    I'm new to power apps and I tried developing the app you created here. However I observed that once you linked your excel file to PA, yours created three screens whereas mine just created one called MainScreen1. The DataScreen1 and EditScreen1 screens were excluded. Is this due to a more recent update?

    • @parkopkisokau7814
      @parkopkisokau7814 Месяц назад +1

      Yes 100%, gaps in the flow process exist with incomplete and missing information at certain points. Otherwise, overall it's a excellent tutorial presentation, with mostly good explanations and great concepts.

  • @MrDionmar
    @MrDionmar 2 года назад +1

    Very helpful!! Tks!
    Just one ☝🏻 question, when your list exceed 2000 rows , what you gonna do ?
    Tks bye ✌🏻

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
      I made a separate video on that. Check it out

  • @slater1182
    @slater1182 Год назад +2

    Is this app free to download or available to purchase?

  • @afaqahmad708
    @afaqahmad708 3 дня назад

    could you please provide the video how you created that power bi dashboards ?

  • @viboperz8376
    @viboperz8376 10 месяцев назад

    Question.. PowerApp is the same for anything you want to do? I went to windows store and there are two type . this one is obviously the power app business ? I just want to make sure.. Great vid BTW, Tanks for sharing it with us.

  • @pullanthestrings_1
    @pullanthestrings_1 Год назад +4

    This is great and explains exactly what I need to do! I'm just wondering, is there a way to scan a barcode of an existing item in the inventory list, then it bring up the details of that item? For example a find item button by using the scan function? :D

    • @gaderyfr8485
      @gaderyfr8485 Год назад

      hello, did you find a way to do this things ?
      I also need to scan a QR code and extract it's information from a data base.

    • @MarkJFellows
      @MarkJFellows Год назад

      @@gaderyfr8485 I would approach this by a scan button on the gallery screen. Save the scan value to a variable, say "var"Barcode." Then modify the Search described in the video to include a match between the variable and the inventory barcode. Does this make sense? happy to help if you need it.

  • @almanzaralbert1
    @almanzaralbert1 2 года назад +1

    Thanks. It's a great educational video. Only one thing, to crate a botton to create Barcode or a Qr code.

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Appreciate it! Thank you for watching! Don't forget to subscribe! Can you clarify your question.

    • @almanzaralbert1
      @almanzaralbert1 2 года назад +1

      @@ProductivityCentralChannel. I subscribed already and shared it too. Can you please show somethomg parking management? Create Barcode or Qr code, entry time, leaving time, diferente prices. Gracias, gracias.

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Sure you mean like a Parking management app for a company ?
      Do you want scan barcodes or create barcodes?
      What do you want in terms of prices inside the app ?
      Can you tell more about the project you have in mind?

  • @WahidShahid
    @WahidShahid Год назад +1

    Thank you very much for such a
    nice and informative video. Best of luck.❤

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @rodelformaran2789
    @rodelformaran2789 4 месяца назад

    Hello, Thank you for the great tutorial! Is it possible to add the "assigned to" field via AD/LDAP? and also it will send a notification to the user via email. and also to add another page displaying all the available IT assets?

    • @AnuKeerthanaM
      @AnuKeerthanaM 3 месяца назад

      Were you able to sync the Barcode scanner with the Serial Number Text Input? If yes, let me know how, I keep getting error for the same

  • @moodleyd38
    @moodleyd38 10 месяцев назад

    Thank you for the detailed and informative video. Question, how would you use this app on a mobile device to input the info whilst in the field and relay info to PC/Cloud ? What platform would be used on the android device? Do you have a video detailing same?

  • @sagarkulkarni6048
    @sagarkulkarni6048 2 года назад +1

    Nice. simple and good explanatory video. Thanks for your efforts!

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @letuan930
    @letuan930 6 месяцев назад +1

    thanks very clear explaining.

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  6 месяцев назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀 Do comment if you want a specific topic video to be made in the future

    • @AnuKeerthanaM
      @AnuKeerthanaM 3 месяца назад

      Were you able to sync the Barcode scanner with the Serial Number Text Input? If yes, let me know how, I keep getting error for the same

  • @deeppatel1320
    @deeppatel1320 5 месяцев назад +1

    Helpful video for me ❤

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  5 месяцев назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀 Do comment if you want a specific topic video to be made in the future

  • @thelearninglife5023
    @thelearninglife5023 Год назад

    Thank you so much for this Great tutorial, is it possible to make this App work offline.

  • @shariarzunak5139
    @shariarzunak5139 3 месяца назад

    How to add selling option. Which will deduct the item quantity from the stock

  • @LivysFamilyAdventures
    @LivysFamilyAdventures 2 года назад +2

    Is there a way to increase the qty of an inventory each time you scan the barcode?

  • @Narculis
    @Narculis 2 года назад +2

    This video has been really useful for me. Do you think you could make a video with this app but using powerapp charts for the dashboard instead? I am having trouble implementing them

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching. Inbuilt powerapps charts don't have much functionality as compared to power bi charts in powerapps as we can't make similar modifications there.

    • @Narculis
      @Narculis 2 года назад +1

      @@ProductivityCentralChannel Unfortunately I do not have access to use powerbi. So charts are my only option. I watched your other inventory app video, but it didnt quite help me.

  • @thetechnician832
    @thetechnician832 Год назад

    Thanks this was helpful. I want to create a similar app using QR scanning for checking out equipment that goes out on loan and then check back in. Would I need to create a separate screen and button for scanning equipment back in or could I use the same button for check out and in?

  • @mukhoiyarotuzzamrudah2664
    @mukhoiyarotuzzamrudah2664 7 месяцев назад

    I have a question sir, when we want to recall our power bi data into power apps, should we use the same account? I have different accounts in both and makes me can't recall data from power BI automatically. Do you have any suggestions??

  • @jonathanplahn
    @jonathanplahn Год назад

    This is a great video. I would like to add a tool for users requesting new assets and the items being added to a list for ordering and tracking. I have a list created of items to select from but can’t figure out how to have them select items to request (i.e. like adding to a shopping cart). Do you have any videos like this?

  • @nwankwoifesinachi4424
    @nwankwoifesinachi4424 Год назад +2

    The video looks good...but i can"t see your code...Please zoom your screen to enable viewers see your code very well

  • @ginevracerreto6886
    @ginevracerreto6886 10 месяцев назад

    I have a question, do I need to have Power BI pro to embed the dashboards? Once I connect my power BI report to the Powerapp it only shows an arrow going up on a chart, not my dashboards. What can I do?

  • @GeorgeZavala-pd6yd
    @GeorgeZavala-pd6yd 3 месяца назад

    Might there be a way to add a return item page? like if someone checks an item out and then back in

  • @Kapildevkushwah
    @Kapildevkushwah 2 года назад +1

    I got what I was looking for thanks buddy .... ❤️

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @pascalneuhaus4945
    @pascalneuhaus4945 2 года назад +2

    First of all: Thank you for that content. I really like your explanations.
    Are you going to make more videos for Microsoft PowerApps?
    Can you explain how to use DropDown fields and how to add new Items to the DropDown list?
    I would love it :D

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching! Yes there will be many more videos on Powerapps. Will try to cover these topics in the future video for you. I take feedback from my subscribers regarding future videos. Make sure you vote 😀

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад +3

      Made a video for dropdowns 😀 ruclips.net/video/u7jaTRzPELs/видео.html
      Check it out!

  • @mortenlie3898
    @mortenlie3898 2 года назад +1

    thanks for really good learning with powerapps and barcode scanner. I have a question. is it possible to make so that the scanner fills information in several fields at once. example. scans an item to be placed in room 1, cabinet 2, shelf 3. then it data in 3 different fields.

  • @AkhilDev007
    @AkhilDev007 Год назад +1

    Hi Bro, I have a choice column (single option) in SP list. Is it possible to view the same in PowerApps gallery view

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Yes it is possible. Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @elnikky4039
    @elnikky4039 2 года назад +1

    Hi, I realized the screen interface is different for mine. I can’t seem to follow well. Would you be able to advice me please. This is my first time trying and learning power apps

  • @ansarshaikh2486
    @ansarshaikh2486 2 года назад +1

    So help u sir nice

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @That9ja_kpopgirl
    @That9ja_kpopgirl 2 месяца назад

    hi, pls i wanted to add two form list to the app , how do i do it
    but for some reason ,when i create a new item, it doesnt appear in my list

  • @0135827
    @0135827 Год назад

    what a wonderful video 👍👍👍👍

  • @nathjeff4205
    @nathjeff4205 2 года назад +1

    Can you give some example script/command so the search engine can search multiple culumn?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
      You can try this for example:
      Filter(StewardList,TextSearchBox.Text in Steward Name||TextSearchBox.Text in Business Area|| TextSearchBox.Text in Type of Steward)

  • @mohamedmaalaoui4479
    @mohamedmaalaoui4479 2 года назад

    Thank you for the very helpfull content. The only point that I want your support to solve it is : when I edit a record the Serial Number is set to blank and we loose the last value. I'll appreciate you share the solution. Thank you

  • @merish22
    @merish22 Год назад

    Hi this good but how can I share or put my app open that any one who opens power app its seen first

  • @maggy85fyah
    @maggy85fyah Год назад

    Thank you for the helpful videos. I have a problem though. When i format the dates as "long dates" on my excel sheet, it shows for example "Monday, 12.September 2022". It doesn't show it any other way. The next problem ist, when i upload the excel sheet on Sharepoint, the date format there changes to number. So date Format totally disappears and nothing works after that.I tried changing the format on Sharepoint (date and time, currency) and when i click on "integrate to PowerApps, i get an errror code "app could not be created - cannot read properties of undefined (reading 'dataEntityDefinition'). Do you have any tips for me how i can fix this?
    Thank you so much and I'm really looking forward to your assistance.

  • @AB-vr4oe
    @AB-vr4oe 8 месяцев назад

    Hi. What if my excel file is a work book with multiple sheets ?😢

  • @fairtradedavao5574
    @fairtradedavao5574 11 месяцев назад

    Can you show how to use the barcode scanner in the main form?

  • @AkhilDev007
    @AkhilDev007 2 года назад +2

    Hey bro, Thanks for the content- really appreciate your efforts.
    need to create an inventory management for different stores like one store has some 200 items . is it possible to group all the items for a store in a group (under a store name- list of items, next group- next set of items). is this something that is achievable by sharepoint list?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад +1

      You can create multi level group by more than two columns in SharePoint. Hope this article helps:
      www.dotnetsharepoint.com/2015/05/group-by-more-than-2-columns-sharepoint.html?m=1

    • @AkhilDev007
      @AkhilDev007 2 года назад

      @@ProductivityCentralChannel Thanks for this. Can this be connected with powerapps for viewing/further addition to lists as we do with simple SP lists & PowerApps

  • @sashanaidoo1146
    @sashanaidoo1146 2 года назад +1

    Hi, Great Video, it was very helpful, how do you take out stock and allocate to customers?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you. Just update the assigned to and status in the database so that Admin knows where is the device

    • @tecnologiaaldia284
      @tecnologiaaldia284 Год назад

      @@ProductivityCentralChannel but if a need record, for the checkout item. How can i do this in power app. Add other buttón for checkout item in stock. thanks

  • @TheFearBO
    @TheFearBO 2 года назад +1

    How would I go about setting up multiple locations?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  Год назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
      Setup a new column for location in your backend (excel or SharePoint list or sql)
      and then you can start building your app from that

  • @ratdevelopment
    @ratdevelopment 2 года назад +1

    Do you have a resource that explains how to display product photos for a specific record that has the product images stored as urls in share point list? Column 1 would contain image 1, Column 2 would contain Image 2 and so on. The product detail screen would show all of those photos in a gallery for just that specific item?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Check out our website:
      www.productivitycentral.ca/2022/01/how-to-display-images-in-sharepoint-list.html
      Hope it helps!

    • @ratdevelopment
      @ratdevelopment 2 года назад

      @@ProductivityCentralChannel Thank you, im looking to display the photos in powerapps for each product. Do you happen to offer training calls?

  • @user-qh3ce1bd6o
    @user-qh3ce1bd6o Год назад

    great tutorial. how can i insert an return item option in it ?

  • @ExpatMoto
    @ExpatMoto Год назад

    Thanks for the amazing video! Can you recommend someone I can hire to customise this app to my business? I need a few minor additions- but inexperienced/unable to do it on my own. Thanks

    • @Dr.marv1
      @Dr.marv1 5 месяцев назад

      I can build and customize business application using the power platform tailored to your business needs

  • @jonathanplahn
    @jonathanplahn Год назад

    I'm trying to build the Power BI Inventory with Bin Levels but cannot find any instructions on this process. Your video referenced does not cover BIN Levels. Can you please help and post a video for this?

  • @user-rp2vz5qp2m
    @user-rp2vz5qp2m 2 месяца назад

    How to give rights to other users , you have shown only adding stock what about an outgoing one , how to put a sales order in it, from field workers with status approved from management, decline or pending or delivered ...plz if you could make it on it

  • @sapnaverma1002
    @sapnaverma1002 2 года назад +1

    Power app creation which will b e showing screen based on user . plzz make a vedio

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Sure will do. Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

  • @merk252
    @merk252 Год назад

    Great Tutorial! @productivitycentral Is it possible to show me how to edit the search screen so that if I type in any characters, then it will find any items with those characters within the name? I noticed it only works now if you type what the beginning of the item you are searching for.

  • @anthonybell2692
    @anthonybell2692 9 месяцев назад

    My Barcode Reader Gave Me An Error: Change the rule to produce a (0) value.
    Can you help me with this error?

  • @akkaradechsrithongchai7766
    @akkaradechsrithongchai7766 2 года назад +1

    How to scan for check or search items ?

  • @TheGuitarsforme
    @TheGuitarsforme 2 года назад +1

    Great Video! The Barcode scanner button in the home screen. Do you create a navigate button to barcodescanner1?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад +1

      Thank you for watching! No you can create the navigation directly to the new entry screen where we have the barcode scanner.
      Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀

    • @TheGuitarsforme
      @TheGuitarsforme 2 года назад +1

      Can I use it to search?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад +1

      Yes you can

    • @TheGuitarsforme
      @TheGuitarsforme 2 года назад +1

      @@ProductivityCentralChannel I want to be able to scan the barcode and pull up the inventory associated with that barcode

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Yes that can be done. Will make a video for this in the future.

  • @nitinkaushik3432
    @nitinkaushik3432 2 года назад

    How to send a email to vendor in this app, so that power automate flow will be involved in it...

  • @QianXuann
    @QianXuann Год назад

    Hi, The code that I copied and pasted keep shows error... Are you able to help me?

  • @dennisspooren8987
    @dennisspooren8987 2 года назад +1

    Great video. Can you provide the images/icons used in the video?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад +1

      Thank you for watching. Don't forget to subscribe :)
      I use Canva for that. You can try their free version.
      bit.ly/3IiEu3P

    • @dennisspooren8987
      @dennisspooren8987 2 года назад +1

      @@ProductivityCentralChannel thanks, I will give it a try!

  • @rakeshvishwanath3758
    @rakeshvishwanath3758 2 месяца назад

    How to create a product bill of material

  • @surajsuchdev7737
    @surajsuchdev7737 Год назад

    Hi Mate,
    I have a share point list which is customized using power apps I need to add a lookup function and it's not looking up for data beyond 18000 line items is there a way we can crack this ?

  • @ronaldremollena4300
    @ronaldremollena4300 Год назад

    Can I use QR code instead of Bar Code?

  • @CC-wk3iy
    @CC-wk3iy 2 года назад +1

    Hi, do you offer your services to custom build apps?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Thank you for watching! Don't forget to like, subscribe and hit the bell notifications icon to be notified first of any future helpful videos 😀
      Unfortunately no I do not at this point of time.

  • @gangaramchandramohanreddy8348
    @gangaramchandramohanreddy8348 2 года назад

    where can i get excel sheet for practice in my tenant

  • @timorovers
    @timorovers Год назад

    Great video. One question I'm having: in my case I want to check the inventory by scanning a barcode from an item that I have in my warehouse. My datasource is Dynamics Business Central (and then the"Item" table). Do you know if this would be possible, and if so could maybe shortly describe it? Many thanks in advance.

  • @victormainza8660
    @victormainza8660 2 года назад

    hi i failed to load the dashboard kindly support screen

  • @arsenenguezang4383
    @arsenenguezang4383 2 года назад +1

    Where can we get the excel data sheet?

    • @ProductivityCentralChannel
      @ProductivityCentralChannel  2 года назад

      Will try to create a link on the website to download for future videos. For now you can just scan the worksheet through excel mobile app from the screen and it will paste it in your excel workbook

  • @Zoids-bf6op
    @Zoids-bf6op Месяц назад

    you skipped the QR code part which is the most important

  • @merish22
    @merish22 Год назад

    Hi this good but how can I share or put my app open that any one who opens power app its seen first