Great content as always. I often reference these videos over and over. You've been a big factor in me moving from general IT and management to App development in 2020.
Absolutely brilliant video. I will once again be able to trick my people into thinking I am smart, and I owe it all to you, Shane. Thank you. The only problem I am having is that I can't stop spelling the word "now", with an 'e' in the middle of it. I even added to the dictionary, so no more red squiggly lines.
Quite simply, fantastic! If I can understand this video - anyone can. Thank you, Shane, for making this straightforward and helping me on my learning journey. I have just created my first shopping cart!
Wow, I'm slowly getting there, so far I've setup HR, Accounting, Maintenance, Logistic, Daily OPS, and Emergency sections all into one app. I was just thinking wouldn't it be good if I could also move our online store to PowerApp, and look where it landed me, lol. Thank you Shane for your videos, been following from the beginning of my PowerApp development. Sooner or later PowerApp might take over the world
Thank you so much Shane, this is a very important component of a final project of one of the most important subjets of my school, so I really appreciate all the time and effort you put in your videos 🙏
Gold. Thank you. Took me a few to figure out how to patch the child table in dataverse by storing the varRecordId as a record rather than text. Perfect timing for my Powerup app challenge. Who Dey!
@@ShanesCows I think I'm getting stuck at the same spot. I get "The specified column 'OrderID' does not exist" as a warning, and "Network error when using Collect fucntion: Field 'solsty_productname' is required" when I click Place Order to run it. Also trying to do this in Dataverse, but not sure what I need to do to store it as a record. Any ideas?
Hi Shane, I just needed to say and appreciate your efforts, your videos are amazing, they have made learning power platform effortless, keep up the great work.
I've built a few apps based on your OG "shopping cart" video, so it's good to see how you've updated yours so I know how/where to update mine! One small enhancement I made is to make the icons used conditional. For example, in the gallery of items, if the particular item exist in the "cart", the plus (+) is replaced with a trash can. In the OnSelect for that icon, if it's displaying the plus, it will add it to the cart, but if it's displaying the trash can, the item is removed from the car. In most of my apps (used by faculty and staff to request new computers), we don't need to provide a quantity option, so either it's in the cart or not. Now my brain is spinning trying to figure out how to do the same thing with quantities involved.
I love this! I want to use something similar to remove items from inventory and return the items that weren’t used. I saw your “check out check in” video but that layout might be too advanced for what I need.
just saw how you do the popup .. i used that popup function in a few apps already, but i used the container control, set that background to the color i wanted and added all the stuff, that should show up .. i used the groups when i started with powerapps, but got annoyed as i had a lot of troubles adding new stuff to that .. so i started using containers instead as soon as they got available and i use the a lot! imho they are the best control ever! 😊
Thanks Shane - this is a great solution. I have what is probably an extra requirement. I have one list with the products and another list for the orders. The second list has other columns (name, email etc) that I want to populate as well as the product details. Is that possible, and how would it work? Thanks
Forget about my question I don´t need that at all, but I have a question: How can I made that when the Oder has check out also on My Assests the QTY of the item is affected... :/ Thanks.
Great video. Thank you so much. Do you know how I could code that I only have a certain amount of each product in and to not let the person purchasing go over that amount that is in stock? Those numbers would be linked to the item on a sharepoint list
Got to get those columns to line up. See if this video helps? PowerApps Performance Optimization - Use Monitor to understand Patch of data sources th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
Great walkthrough, easy to follow and understand. As continuation, I wonder what the correct method is for viewing these order in a master/detail list (i guess without doing lookups) and maybe send it to a Power Automate approval, so a person can approve or deny the orders before they actually get send out.
I have a whole series where I show those concepts. Start here. th-cam.com/video/xgznk4XlPCo/w-d-xo.html then search for approvals without flow video I did. 😎
Hi Shane. Amazing video. Question: how you manage to consolidate the collection items to make it unique items when a user adds more than one instances of the same product?
Hi Shane !! your videos are awesome!! I learned a lot and solved many situations thanks to them !!! Please let us know when you start recruiting outside US cause I would love to be part of your team, I would surely learn and contribute a lot!
Another great video, very helpful. Is there an easy way to add new/more items to the "web store". What is best practice? Add more items to the underlying excel-file or directly to the sharepoint-list? Do you have a video on this?
Hi, just to confirm the only way items end up in collection is if the + button is pressed. Can you not just have one Add to cart button that would look at all selections? If so, can you say with code how that would work if possible please? great video
Hi Shane, your videos have been very helpful for me to learn create an app. I am trying to create an input form for purchase order and save the data to SharePoint. I um unable to share a screenshot but basically the master details for a PO would have PO number, vendor name, approver, etc. The details part is where I add new lines via a button for Qty, unit price, Amount and would like to save each line to the same SharePoint list in a separate row and copy same master data such as PO number, vendor for each row. Would you be able to make a video to show how to do something like this? Thanks!
When you collect all the orders than a user generate, this collection is only for one user. I want to consolidate all the orders that alll user generated. Like order 1, 2, 3, etc. This is usefull when i want to review or analize the data.
I would love to see a follow-up video that combines this "Power Apps Shopping Cart new for 2021" with the "PowerApps PDF Generator using Microsoft Flow PDF Converter" video you made in Aug 2018. I am looking to create a PDF with some of the high level details of the order as well as all of the items ordered.
Chris try this video. It talks about creating table data using Concat, which is the key to what you want to do. :) th-cam.com/video/bfXV_GXc_JM/w-d-xo.html
Thanks Shane, as always great videos, they have helped me a lot, Is it possible to do one integrating Inventory. I would really like to have my inventory sharpoint list substract the quantitys made by the orders.
Good video. If I want to trigger the order at minute 38 with Collect('Shopping Cart Ordered Items', AddColumns(colShoppingCart, "OrderID", varRecordID)) then I get the following error: Network Error when using Collect function. The specified column is generated by the server and can't be specified. I can't find the error because all the columns from the collection are there. Which column could be causing the error?
Do you have a calculated column of some sort maybe? I would try dropping columns one at a time and see if you can find the culprit. But look at special columns first.
Hi Shane. Thanks for providing such a terrific resource. I'm implementing a provisioning app for new hires that lets managers choose all the things their new employee will need on their first day: e.g. computer, account, telephone, office, furniture.... The asset/resource list is large and each option has sub-options that may be constrained by business rules (e.g. that model laptop does not support that piece of software). So it's a shopping cart of assemblies rather than a shopping cart of items. The app is model driven but ordering will be done from a canvas app (or at least I think so, since I don't think model UI is flexible enough for this). Where I'm running into trouble is the data model for the assemblies. Do you have any suggestions for how I should structure my tables, please?
Another Awesome Video! Great Content. One question - Is it better to dump the contents of SharePoint List to a collection, work with the data in the PowerApp and then write it back to the list when you are done or work directly with the data in the SharePoint List via a gallery?
It depends. 😀 If your list is smaller than the delegation limit, and the data will not be changed by someone else while you are using the app, then collections are great. If not calling the datasource directly is fine.
Hi Shane, I saw your app which you have given in description as a link. can you tell me how you are hosting your app in a website so that everyone can see it?
This video is great!! you always do the best demos and I have learned so much. I do have a question. I would like to be able to add an automated order number in my shopping cart checkout screen based on a 4 digit project code and the the next sequential number. Is this possible? and how would I do that? IE: (project ID)####0001, ####0002 etc
Awesome video! I'm trying to figure out why my patch adds rows (records) for items on my Order Details table in Dataverse, but every row (record) is blank. The column names in the Dataverse and in my collection are exactly the same. Any ideas?
@@ShanesCows I was using the display names. I was able to get it to work by enclosing my patch in ForAll and using the disambiguation operator. I'm sure it probably isn't the best way to get it to work. Thank you!
Hi Shane! This video was a perfect instruction for a catering request app I'm doing. I'm trying to get it to output the qty and items ordered from the collection back to the sharepoint list and struggling with this (basically want to track what and how much is ordered for each order in one line item).
Hey, Shane another great video that has really helped me understand a lot of the nuances of canvas apps. I have one question: at around 36 mins you mentioned that you can use a collect function to patch to a Sharepoint site, does this work for Dataverse do you know?
Thanks, Shane -- wierdly enough I am just watching that one now. I wish I had known about this before would've saved me building a Power Automate flow to send up 115 columns to the datasource! Cheers
This has been a huge help. I run into an issue where when I click the submit order button, only certain columns/data is being entered into SharePoint. The submit button has the error "The specified column 'Location' Does not Exist.'. I am not sure why not all the data is being entered, I have tried creating fresh lists too.
@@ShanesCows Tricky one but I would solve it with an extra column in the stock table called ’ReservedQTY’ and patch that as items are put in the basket. Reserved qty could never be more than stock qty, then no further items in basket possible and then reset the column to 0 again as the order request is aborted or finished. How did you solve it Shane?
Hello Shane! Thank you very much for this very useful tutorial. I would like to know if it is possible to add sending an email with all the info directly through PowerApps just by clicking on the "PlaceOrder" button?
Yes you can! th-cam.com/video/vpYkOccwn4Y/w-d-xo.html is a good intro to sending emails. Then in the body you will want to use Concat to send the table of data. This video will help you if that is new th-cam.com/video/AnERfGIE8gw/w-d-xo.html
I am trying to use this for a sort of internal inventory system. I want to be sure if the PM requests materials that they can see how many we have available if any. I also need to do a reverse shopping cart where extra materials can be entered into inventory. Any suggestions?
Power Apps Check in Check out Inventory Management App th-cam.com/video/HTY8AnMz5rw/w-d-xo.html This video should give you some ideas on managing inventory.
good start, but i dropped out @14:49. Where or what is colshoppingcart? The title is also unknown and gives error. I was guessing its the name of the text label title? But i dont see you have it on your list, only title2
@@ShanesCows - I seem to get further but now stuck at 37:29. Everything is confirmed working fine until the Collect(shopping cart ordered items, Addcolumns)colShoppingCart, "OrderID", varRecordID)). The error i get is red under line and error message says: The specified column Order ID does not exist. The column with the most similar name is Order ID. I have checked the table Shopping cart ordered items and it does have the Order ID column. I tried to create different column, but it gives same error (but with the name of the new column used), Been stuck here for days, any idea where the error is? Added info, The ID column in the "Shopping cart orders" table (im using dataverse instead of SharePoint list) does not get any ID either, any reason why? Maybe issue is connected? thanks!
Hi Shane. Great video as always. How do I reset the OrderID to 1. I built your app but the other ID keeps going up and for Production I want to start from 1.
Great job Shane! I achieved Step 1 successfully, in step 2 (35:50) using the Collect function everything after Addcolumns is underlined with a blue line and says "The specified column "anyname" doesn't exist", I already changed the names (to avoid the accent we use in spanish languaje), deleted and added the datasource twice, I do't know what else to do, any suggestion?, I'm working in Teams environment with CDS as datasource. I found your video from October 28 (the Halloween one), I'll try with ForAll.
hello Shane, thanks for the video. Any ideas how to attach a file to the multiple rows created in SP? Taking this demo for as an example, if the customer needs to attach an evidence of payment to the order, how do you achieve this in such a way that the attachment binds to all the rows of data submitted to the SP list. thanks in advance
If hoodie size S has a article number and size M has another number, how would you set this up? If the warehouse person uses that number to pick right article.
Hey Shane, I was wondering when adding to the colShoppingCart is there a way to have the quantity increase rather than it add the same item again? At the moment if I add 2 coffee cups and then decide I want to add another it will add the coffee cup twice, one with qty 2 and one with qty 1. I'm guessing it's something to do with the Patch command so I'll have a play but thought you may have come across this and have a simple solution. Thanks again, really appreciate the work you put into this.
Lee - Take the concept from this video th-cam.com/video/Ap3_Ea9H8b0/w-d-xo.html on finding duplicates. Update your Patch to check for an existing row. If it finds one update it if not create a new one. :)
Hi Shane, your videos are awesome and it inspired me to create this app to use in my own workplace! You may not see this as this is an old video now, but there is one thing I am struggling to do to take this app further which is what I need to rollout the app, and that is to create a flow that will email out all of the items, and the total and name of the customer and other details (I put an account code in the the orders SharePoint list). Essentially I am looking for a way to lookup to the SharePoint list of the individual items, filter on the items with the same order ID and then also include the information from the order SharePoint list that pertain to the same order number. I’m very new with power apps and flow so I’m struggling to search for the functions that would help me with this! If you have any tips that would be much appreciated! :)
Great video, great content :) but a little question: how do you manage your stock? I'm trying to build a system based on a basic amount of item in stock that can be updated when a customer buy something but i'm struggeling with this part.
Hi shane Thank you very much for your help, I have a question I have a filtered gallery that depends on another gallery, example: The first gallery I have grocery categories and in the second gallery the products that make up that category, my problem is that when I change the category in the First gallery, the second one does not return to the first item, it stays in the middle or at the end. Would you help me? Thanks
First and foremost, these videos are amazing and easy follow. Question though, when I “Collect” from the Place Order button, my colShoppingCart is double underlines in blue and I have the following message: The specified column ‘DESCRIPTION’ does not exist. The column with the most similar name is ‘DESCRIPTION’. Have I done something wrong?
Hey Shane! Am I able to extract info (product list) from PDF using AI Builder then send it to power apps to create an order form/shopping cart for my technicians/installers to be able to order products for a service order and then have their order sent to a coordinator?
Do you have a video for how to use the plus and minus with a text input? I'm creating an internal storefront for our business and I like the minus/add option if they type a number quantity in a textbox. The codes I've tried aren't working.
Hi Shane. Great video! I am currently creating something similar with our learning offerings, where I want users to select the courses they want, add them to a cart and then checkout. This would then trigger a flow for manager approval of learning and then when approved, our learning coordinators would get a list of courses to enrol people in (in a separate LMS). I've started by building a data table of the courses rather than a gallery, but wondering if I should change that to Gallery as it looks easier to work with. What are your thoughts on this? Would this work okay using a Data table? I managed to get it all working fine but also want to capture Office365User data and send this back to a different SharePoint list along with the courses requested. Would you add this to a collection first or just send directly using 'For All'?
Can you set this to add a group of items to the basket if you had a bundle? Bundle One contains 1 cup, 1 mask, 1 hoody. Add bundle, this adds all items to basket. Then if I add 1 more mask separately, the basket would update to show 2 masks total
Hello Shane, I’m having quite a rough time building my inventory app. Every time I try to import from sharepoint to power app, I keep getting error messages. I really need your help as I’m running out of time. Thank you.
My image links from my SharePoint list are not converting to images in PowerApps. Wondering if I don't have the column set up properly in SP. Do you have any videos/quick troubleshooting tips on how to do this?!
is there a way to check stock levels on something like this? I have this exact require coming up for a project but I need to manage stock levels, and have a user return items to stock after use.
Couple of options. 1. You can user the GUID() function to generate a unquie idea to the order record and then save it to all of the collection so you can connect them later. 2. th-cam.com/video/xgznk4XlPCo/w-d-xo.html This video teaches child/parent relationships (which is what you need) watch it and then apply the concept to your shopping cart. YOu will be in business. I would use option #2 if I was building it :)
Quesiton: In the colShopping cart. If someone were to select baby onesie size: NB QTY: 1 and add to cart and individually add to cart say 5 times the collection will show each item individually as opposed to baby onesie NB QTY: 5. how would I set it up to where if somewhere does select the same item it just increases the quantity as opposed to an individual item line in the collection.
Figured it out: In the Add to cart button OnSelect: If( // Check if the item with the same Title and Storage already exists in the collection CountRows( Filter( colShoppingCart, Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value ) ) > 0, // If exists, update the quantity of the existing item Patch( colShoppingCart, LookUp( colShoppingCart, Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value ), { Quantity: LookUp( colShoppingCart, Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value ).Quantity + QTYDropDown.Selected.Value } ), // If it does not exist, add a new item to the collection Collect( colShoppingCart, { Title: ThisItem.Title, Storage: SizeDropDown.Selected.Value, Quantity: QTYDropDown.Selected.Value } ) ); // Resetting dropdowns and setting success variables Reset(QTYDropDown); Reset(SizeDropDown); Set(varShowSuccess, true); Set(varShowSuccessTimer, true);
Awesome videos sir, your videos are always clear and very helpful. Thank you for this. There is a Powerapps videos I would like you to assist me with and using Dataverse as your database please. Can you please create a Powerapps app when a user registers and login, after 24 hours the password will expire and they will be sent back to the registration page to re-register everytime the password has expired after 24 hours.
Hi, I am trying to patch my collection to a SharePoint list, all columns except the Qty column got patched. Please, how do I correct this? I am a beginner. This is the error message - cannot use a non record value in this context: ShowColumns(colshoppingcart, "ProductName", "SubTotal","Qty")
Shane one feedback, the size of your photo in bottom right corner is little too big, please make it small because while you are talking we are more interested in understanding how things done rather looking at your face ;) Its kinda distraction
This is strange, on my "Add to Cart" screen, placed sliders in the gallery to set quantities, if the gallery has 4 products, the slider quantity for the last product added (ex: product 4 - slider set to quantity: 3 units) is the quantity that registers on the "Checkout/Cart" screen for all items in the cart. Shouldn't each slider set the quantity for each respective product? :((
Great content as always. I often reference these videos over and over. You've been a big factor in me moving from general IT and management to App development in 2020.
I appreciate that!
Absolutely brilliant video. I will once again be able to trick my people into thinking I am smart, and I owe it all to you, Shane. Thank you. The only problem I am having is that I can't stop spelling the word "now", with an 'e' in the middle of it. I even added to the dictionary, so no more red squiggly lines.
😂
Quite simply, fantastic! If I can understand this video - anyone can. Thank you, Shane, for making this straightforward and helping me on my learning journey. I have just created my first shopping cart!
Good job! I love when people build awesome stuff.
Wow, I'm slowly getting there, so far I've setup HR, Accounting, Maintenance, Logistic, Daily OPS, and Emergency sections all into one app. I was just thinking wouldn't it be good if I could also move our online store to PowerApp, and look where it landed me, lol. Thank you Shane for your videos, been following from the beginning of my PowerApp development. Sooner or later PowerApp might take over the world
Happy to help. 🐈⬛😺
Thank you so much Shane, this is a very important component of a final project of one of the most important subjets of my school, so I really appreciate all the time and effort you put in your videos 🙏
Awesomeness 😁
Gold. Thank you. Took me a few to figure out how to patch the child table in dataverse by storing the varRecordId as a record rather than text. Perfect timing for my Powerup app challenge. Who Dey!
Glad it helped! Who Dey! 😍
@@ShanesCows I think I'm getting stuck at the same spot. I get "The specified column 'OrderID' does not exist" as a warning, and "Network error when using Collect fucntion: Field 'solsty_productname' is required" when I click Place Order to run it. Also trying to do this in Dataverse, but not sure what I need to do to store it as a record. Any ideas?
Never mind, I got some help and managed to get it to work. This was a great foundation though, thanks!
Thank you so much brother. I cannot describe how I want to say thank you to you. I'll be the one of your big fan forever.
Happy to help, have a great week!
Hi Shane, I just needed to say and appreciate your efforts, your videos are amazing, they have made learning power platform effortless, keep up the great work.
I appreciate that!
I've built a few apps based on your OG "shopping cart" video, so it's good to see how you've updated yours so I know how/where to update mine! One small enhancement I made is to make the icons used conditional. For example, in the gallery of items, if the particular item exist in the "cart", the plus (+) is replaced with a trash can. In the OnSelect for that icon, if it's displaying the plus, it will add it to the cart, but if it's displaying the trash can, the item is removed from the car. In most of my apps (used by faculty and staff to request new computers), we don't need to provide a quantity option, so either it's in the cart or not. Now my brain is spinning trying to figure out how to do the same thing with quantities involved.
Awesome to hear you have had fun with it Chad! I like your tweaks!
Wow, this was such a great tutorial Shane! This is my first attempt at a shopping cart and am very excited about learning more!
Glad it was helpful!
Shane, great video. Really good to be able to see an end to end solution being built and just what I was looking for
Awesome! Glad it was the right fit. 🐶
Shane, we can all tell you put A LOT into this video... THANK YOU! You are ThisItem.Appreciated!!! (LOL)
Thanks Shawn!
I love this! I want to use something similar to remove items from inventory and return the items that weren’t used. I saw your “check out check in” video but that layout might be too advanced for what I need.
I repied to your other comment, I am trying to think of other answers but drawing a blank
just saw how you do the popup .. i used that popup function in a few apps already, but i used the container control, set that background to the color i wanted and added all the stuff, that should show up .. i used the groups when i started with powerapps, but got annoyed as i had a lot of troubles adding new stuff to that .. so i started using containers instead as soon as they got available and i use the a lot! imho they are the best control ever! 😊
I like it! 🙌
Amazing content and so many new tricks I learned in this one (not to mention it being exactly what I needed). Thank you for sharing!!
Glad it was helpful!
Hi Shane, great video. Delighted to learn from someone who dominates Power Apps so well. Regards.
You are too kind. 😊
I audibly laughed at "I kind of did all this cuteness" 19:29. Hahaha
This helped me IMMENSELY!! THANK YOU!!
Happy to help Brenn!
I had developed a similar app in 2020. Anyways, thanks again Shane for these lovely tutorials.
Cool 🤩
Shane, you are the man! Thank you for great content!
Happy to help. Have a great day. 🐶
Thanks Shane - this is a great solution. I have what is probably an extra requirement. I have one list with the products and another list for the orders. The second list has other columns (name, email etc) that I want to populate as well as the product details. Is that possible, and how would it work? Thanks
You would use the LookUp function to pull in that additional data th-cam.com/video/W5Z61Q9Rehs/w-d-xo.html
awesome Shane! I will use your example to create an IT Shopping Assets for my staffs ;) you are the best!
Please do Ivan! That is a perfect fit!
@@ShanesCows Is there a way to also increase the QTY of the Cart Item with a + and - icons OnSelected?
Forget about my question I don´t need that at all, but I have a question: How can I made that when the Oder has check out also on My Assests the QTY of the item is affected... :/ Thanks.
Great video. Thank you so much. Do you know how I could code that I only have a certain amount of each product in and to not let the person purchasing go over that amount that is in stock? Those numbers would be linked to the item on a sharepoint list
Great videos as always! You´ve helped in many ways (with all of your videos!) you can´t imagine...Thanks for everything.
Great video! My collection isn't posting properly to the sharepoint list . Whats I need to fix?
Got to get those columns to line up. See if this video helps? PowerApps Performance Optimization - Use Monitor to understand Patch of data sources
th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
uauuuu its amazing. congratulations my friend. This video is very very good.
Thank you! Cheers!
Great walkthrough, easy to follow and understand. As continuation, I wonder what the correct method is for viewing these order in a master/detail list (i guess without doing lookups) and maybe send it to a Power Automate approval, so a person can approve or deny the orders before they actually get send out.
I have a whole series where I show those concepts. Start here. th-cam.com/video/xgznk4XlPCo/w-d-xo.html then search for approvals without flow video I did. 😎
Hi Shane. Amazing video. Question: how you manage to consolidate the collection items to make it unique items when a user adds more than one instances of the same product?
Check out the GroupBy function. th-cam.com/video/MDhIjM08u-w/w-d-xo.html
Very helpful video, thanks! Could you please format the bigger chuncks of code, so it's easier to read for my dyslexic brain?
I will try to remember to do that in the future. 😎 No promises though.
Thank you for sharing this with us!
Happy to help. Have a great day. 🐶
Hi Shane !! your videos are awesome!! I learned a lot and solved many situations thanks to them !!! Please let us know when you start recruiting outside US cause I would love to be part of your team, I would surely learn and contribute a lot!
Deal! One day we will be big enough to do so I hope. 😎
Fantastic video Shane, thank you. 👏🏼👏🏼👏🏼
Glad you enjoyed it!
Another great video, very helpful. Is there an easy way to add new/more items to the "web store". What is best practice? Add more items to the underlying excel-file or directly to the sharepoint-list? Do you have a video on this?
Add items to the a SharePoint list and show that data for your store. I only used excel here to make it easier for people to recreate
your content is great, thank you very much from Colombia
Thanks for watching!
What a splendid lecture, thanks for this
Happy to help
Thanks Shane. Would be great to see the OrderID in the child list as a lookup item to the ID in the parent list.
I don't like Lookup columns in SHarePoint. :) If you want to add it though the Patch is covered here th-cam.com/video/gsk14D-CYRE/w-d-xo.html
Hi, just to confirm the only way items end up in collection is if the + button is pressed. Can you not just have one Add to cart button that would look at all selections? If so, can you say with code how that would work if possible please? great video
Hi Shane, your videos have been very helpful for me to learn create an app. I am trying to create an input form for purchase order and save the data to SharePoint. I um unable to share a screenshot but basically the master details for a PO would have PO number, vendor name, approver, etc. The details part is where I add new lines via a button for Qty, unit price, Amount and would like to save each line to the same SharePoint list in a separate row and copy same master data such as PO number, vendor for each row. Would you be able to make a video to show how to do something like this? Thanks!
When you collect all the orders than a user generate, this collection is only for one user. I want to consolidate all the orders that alll user generated. Like order 1, 2, 3, etc. This is usefull when i want to review or analize the data.
You would do that on the SharePoint side. That is why we send it there.
I would love to see a follow-up video that combines this "Power Apps Shopping Cart new for 2021" with the "PowerApps PDF Generator using Microsoft Flow PDF Converter" video you made in Aug 2018. I am looking to create a PDF with some of the high level details of the order as well as all of the items ordered.
Chris try this video. It talks about creating table data using Concat, which is the key to what you want to do. :) th-cam.com/video/bfXV_GXc_JM/w-d-xo.html
@@ShanesCows Thank you. I am watching this video now. I appreciate the help!
Thanks Shane, as always great videos, they have helped me a lot, Is it possible to do one integrating Inventory. I would really like to have my inventory sharpoint list substract the quantitys made by the orders.
I am working on a similar concept for a soon video. I actually showed a screenshot of the app in the video I released yesterday.
Good video. If I want to trigger the order at minute 38 with Collect('Shopping Cart Ordered Items', AddColumns(colShoppingCart, "OrderID", varRecordID)) then I get the following error:
Network Error when using Collect function. The specified column is generated by the server and can't be specified.
I can't find the error because all the columns from the collection are there. Which column could be causing the error?
Do you have a calculated column of some sort maybe? I would try dropping columns one at a time and see if you can find the culprit. But look at special columns first.
Hi Shane. Thanks for providing such a terrific resource. I'm implementing a provisioning app for new hires that lets managers choose all the things their new employee will need on their first day: e.g. computer, account, telephone, office, furniture.... The asset/resource list is large and each option has sub-options that may be constrained by business rules (e.g. that model laptop does not support that piece of software). So it's a shopping cart of assemblies rather than a shopping cart of items. The app is model driven but ordering will be done from a canvas app (or at least I think so, since I don't think model UI is flexible enough for this). Where I'm running into trouble is the data model for the assemblies. Do you have any suggestions for how I should structure my tables, please?
Another Awesome Video! Great Content. One question - Is it better to dump the contents of SharePoint List to a collection, work with the data in the PowerApp and then write it back to the list when you are done or work directly with the data in the SharePoint List via a gallery?
It depends. 😀 If your list is smaller than the delegation limit, and the data will not be changed by someone else while you are using the app, then collections are great. If not calling the datasource directly is fine.
thx for chewy Merchandise :-) and great videos
Our pleasure! I am wearing my sweatshirt right now. I love it even if no one else does.
Hi Shane, I saw your app which you have given in description as a link. can you tell me how you are hosting your app in a website so that everyone can see it?
You can’t turn it into a public website. Everyone needs an account and a license to use your Power Apps
This video is great!! you always do the best demos and I have learned so much. I do have a question. I would like to be able to add an automated order number in my shopping cart checkout screen based on a 4 digit project code and the the next sequential number. Is this possible? and how would I do that? IE: (project ID)####0001, ####0002 etc
You could try applying what I showed in this video th-cam.com/video/plKw_xfVfwY/w-d-xo.html as one idea.
Wonderful Video Shane. Thanks a lot. How can I have my cart show items after reopening the app?
You have to save the contents of the collection to another list in a draft status. Then load that data up if the user came back in.
great video. lots of good info
how would you do this in a model driven app???
Awesome video!
I'm trying to figure out why my patch adds rows (records) for items on my Order Details table in Dataverse, but every row (record) is blank. The column names in the Dataverse and in my collection are exactly the same. Any ideas?
Are you using the system names or the display names? With DataVerse make sure it is the system name. The cr67_name version
@@ShanesCows I was using the display names. I was able to get it to work by enclosing my patch in ForAll and using the disambiguation operator. I'm sure it probably isn't the best way to get it to work.
Thank you!
Hi Shane! This video was a perfect instruction for a catering request app I'm doing. I'm trying to get it to output the qty and items ordered from the collection back to the sharepoint list and struggling with this (basically want to track what and how much is ordered for each order in one line item).
This video has the ForAll concept you need to save to the datasource 😎 th-cam.com/video/xgznk4XlPCo/w-d-xo.html
@@ShanesCows Thank you, this was perfect!
Hey, Shane another great video that has really helped me understand a lot of the nuances of canvas apps. I have one question: at around 36 mins you mentioned that you can use a collect function to patch to a Sharepoint site, does this work for Dataverse do you know?
Yes it does. I think this video will help you understand it all best. th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
Thanks, Shane -- wierdly enough I am just watching that one now. I wish I had known about this before would've saved me building a Power Automate flow to send up 115 columns to the datasource! Cheers
This has been a huge help. I run into an issue where when I click the submit order button, only certain columns/data is being entered into SharePoint. The submit button has the error "The specified column 'Location' Does not Exist.'. I am not sure why not all the data is being entered, I have tried creating fresh lists too.
Awesome video Shane, I've learnt alot! How would you handle stock control if two people are ordering at the same time?
It is a pain. You will have to create locks and manage it all very manually. Helped a customer do this 2 weeks ago and it ain't fun.
@@ShanesCows Damn it Shane, I thought you were going to give me the magic answer!! It's proving to be a pain in the butt to me too 🤣
@@ShanesCows
Tricky one but I would solve it with an extra column in the stock table called ’ReservedQTY’ and patch that as items are put in the basket.
Reserved qty could never be more than stock qty, then no further items in basket possible and then reset the column to 0 again as the order request is aborted or finished.
How did you solve it Shane?
Great video Shane. Can this be build for external customers and published to Google/Apple app store?
Not yet but Microsoft says that is coming.
@@ShanesCows This is like Wix for Mobile apps. If they can make 1 license pricing for external users, I think it would be a game changer
Hello Shane!
Thank you very much for this very useful tutorial. I would like to know if it is possible to add sending an email with all the info directly through PowerApps just by clicking on the "PlaceOrder" button?
Yes you can! th-cam.com/video/vpYkOccwn4Y/w-d-xo.html is a good intro to sending emails. Then in the body you will want to use Concat to send the table of data. This video will help you if that is new th-cam.com/video/AnERfGIE8gw/w-d-xo.html
Thanks Shane excellent video
Very welcome
Hi Shane, great video. How do I get hold of the template for the app?
Https://training.powerapps911.com and sign up for the Curated Library 😎
I am trying to use this for a sort of internal inventory system. I want to be sure if the PM requests materials that they can see how many we have available if any. I also need to do a reverse shopping cart where extra materials can be entered into inventory. Any suggestions?
Power Apps Check in Check out Inventory Management App
th-cam.com/video/HTY8AnMz5rw/w-d-xo.html
This video should give you some ideas on managing inventory.
good start, but i dropped out @14:49. Where or what is colshoppingcart? The title is also unknown and gives error. I was guessing its the name of the text label title? But i dont see you have it on your list, only title2
It is a collection. You have to create it with Collection or ClearCollect to use it. It is covered in the video.
@@ShanesCows - wow thanks for prompt reply. Im new to this, but will have a look at it. Thanks!
@@ShanesCows - I seem to get further but now stuck at 37:29. Everything is confirmed working fine until the Collect(shopping cart ordered items, Addcolumns)colShoppingCart, "OrderID", varRecordID)). The error i get is red under line and error message says:
The specified column Order ID does not exist. The column with the most similar name is Order ID.
I have checked the table Shopping cart ordered items and it does have the Order ID column. I tried to create different column, but it gives same error (but with the name of the new column used),
Been stuck here for days, any idea where the error is?
Added info, The ID column in the "Shopping cart orders" table (im using dataverse instead of SharePoint list) does not get any ID either, any reason why? Maybe issue is connected?
thanks!
@@LeJa-76 Did you ever figure this out?
@@EmoreeColey1 which part ? :D
I got the whole thing to work in the end.
Hi Shane, This video was excellent but can you explain in detail process of SharePoint for beginners.
Thankyou😊
Hi Shane. Great video as always. How do I reset the OrderID to 1. I built your app but the other ID keeps going up and for Production I want to start from 1.
If you are using the SharePoint ID column then you can’t reset it. You would have to create a new list to start back at zero
@@ShanesCows thank you Shane.
Great job Shane! I achieved Step 1 successfully, in step 2 (35:50) using the Collect function everything after Addcolumns is underlined with a blue line and says "The specified column "anyname" doesn't exist", I already changed the names (to avoid the accent we use in spanish languaje), deleted and added the datasource twice, I do't know what else to do, any suggestion?, I'm working in Teams environment with CDS as datasource. I found your video from October 28 (the Halloween one), I'll try with ForAll.
I hope you get it figured out. I am not sure.
hello Shane, thanks for the video. Any ideas how to attach a file to the multiple rows created in SP? Taking this demo for as an example, if the customer needs to attach an evidence of payment to the order, how do you achieve this in such a way that the attachment binds to all the rows of data submitted to the SP list. thanks in advance
Use this to upload the file th-cam.com/video/3QaiM8SeWfM/w-d-xo.html then store the link to the file at metadata of each row.
Some of these formula codes are long, like the greyed out arrow. anyway we can just copy and paste?
If hoodie size S has a article number and size M has another number, how would you set this up? If the warehouse person uses that number to pick right article.
Hey Shane, I was wondering when adding to the colShoppingCart is there a way to have the quantity increase rather than it add the same item again? At the moment if I add 2 coffee cups and then decide I want to add another it will add the coffee cup twice, one with qty 2 and one with qty 1.
I'm guessing it's something to do with the Patch command so I'll have a play but thought you may have come across this and have a simple solution.
Thanks again, really appreciate the work you put into this.
Lee - Take the concept from this video th-cam.com/video/Ap3_Ea9H8b0/w-d-xo.html on finding duplicates. Update your Patch to check for an existing row. If it finds one update it if not create a new one. :)
@@ShanesCows As always you are a star. Thanks Shane.
Hi Shane, your videos are awesome and it inspired me to create this app to use in my own workplace! You may not see this as this is an old video now, but there is one thing I am struggling to do to take this app further which is what I need to rollout the app, and that is to create a flow that will email out all of the items, and the total and name of the customer and other details (I put an account code in the the orders SharePoint list). Essentially I am looking for a way to lookup to the SharePoint list of the individual items, filter on the items with the same order ID and then also include the information from the order SharePoint list that pertain to the same order number. I’m very new with power apps and flow so I’m struggling to search for the functions that would help me with this! If you have any tips that would be much appreciated! :)
Hello Shane, how can one add to a cart and then print the cart? Is there a function that PowerApps provides to print the list of items from cart?
Shane, you are the man
Great video, great content :) but a little question: how do you manage your stock? I'm trying to build a system based on a basic amount of item in stock that can be updated when a customer buy something but i'm struggeling with this part.
Hii, have you find a good solution for it? I am looking for the same solution...
@@michaelcox3322 yes, i Can give you m'y solution. I'post it monday when i'm at work
@@giudicephilippe5644 thanks, i look forward to it 👍
@@michaelcox3322 so my solution is to simply patch my SharepointList as soon the client hit the basket buton for one product
perfect as usual, do you make your videos while you are standing up !
Yes, I have a stand up desk for recording. It is part of how I have more energy.
How would you discount the stock at the time of purchase?
Do you mean reduce the price or reduce the quantity from inventory?
Hi shane
Thank you very much for your help, I have a question I have a filtered gallery that depends on another gallery, example: The first gallery I have grocery categories and in the second gallery the products that make up that category, my problem is that when I change the category in the First gallery, the second one does not return to the first item, it stays in the middle or at the end. Would you help me?
Thanks
I think you can use Reset(GalleryName) and that should put it back to the top.
First and foremost, these videos are amazing and easy follow. Question though, when I “Collect” from the Place Order button, my colShoppingCart is double underlines in blue and I have the following message: The specified column ‘DESCRIPTION’ does not exist. The column with the most similar name is ‘DESCRIPTION’. Have I done something wrong?
That is odd. I would try retyping the name in both places. It seems like one isn’t happy but I am not sure. 😑
Hi, did you solve this one? I face the same issue, tried re-do all from the beginning and still face the same issue..
@@pulupulu-e4j I disconnected my SharePoint list. Renamed it and them reconnected and it worked. I'm not sure why or how but its fixed.
Hey Shane! Am I able to extract info (product list) from PDF using AI Builder then send it to power apps to create an order form/shopping cart for my technicians/installers to be able to order products for a service order and then have their order sent to a coordinator?
This video should give you some ideas. th-cam.com/video/ogFz7BbLfvc/w-d-xo.html But overall I think what you want is possible. :)
Thank you so much Shane! I learn a lot of thing from your vid
My pleasure!
Great video and app!
The all video is okay. But I can’t find “Collections” in the View. There is no view bar. Can you please tell me, how can I find the Collections? 16:03
Do you have a video for how to use the plus and minus with a text input? I'm creating an internal storefront for our business and I like the minus/add option if they type a number quantity in a textbox. The codes I've tried aren't working.
Hi Shane Young, where View Orders button will navigate to ?
Hi Shane. Great video! I am currently creating something similar with our learning offerings, where I want users to select the courses they want, add them to a cart and then checkout. This would then trigger a flow for manager approval of learning and then when approved, our learning coordinators would get a list of courses to enrol people in (in a separate LMS). I've started by building a data table of the courses rather than a gallery, but wondering if I should change that to Gallery as it looks easier to work with. What are your thoughts on this? Would this work okay using a Data table? I managed to get it all working fine but also want to capture Office365User data and send this back to a different SharePoint list along with the courses requested. Would you add this to a collection first or just send directly using 'For All'?
Can you set this to add a group of items to the basket if you had a bundle? Bundle One contains 1 cup, 1 mask, 1 hoody. Add bundle, this adds all items to basket. Then if I add 1 more mask separately, the basket would update to show 2 masks total
Hello Shane, I’m having quite a rough time building my inventory app. Every time I try to import from sharepoint to power app, I keep getting error messages. I really need your help as I’m running out of time. Thank you.
My image links from my SharePoint list are not converting to images in PowerApps. Wondering if I don't have the column set up properly in SP. Do you have any videos/quick troubleshooting tips on how to do this?!
Should be a Hyperlink column with the property in SharePoint for the column set to picture
Thank you so much Bro!!
Wonderful!!
Thank you! Cheers!
is there a way to check stock levels on something like this? I have this exact require coming up for a project but I need to manage stock levels, and have a user return items to stock after use.
Yes. Use the LookUp function to find the amounts. Or use your stock list as the base for this gallery.
Hey!How to save each collection to sharepoint with order id so that each collection can be identified by an order id
Couple of options.
1. You can user the GUID() function to generate a unquie idea to the order record and then save it to all of the collection so you can connect them later.
2. th-cam.com/video/xgznk4XlPCo/w-d-xo.html This video teaches child/parent relationships (which is what you need) watch it and then apply the concept to your shopping cart. YOu will be in business.
I would use option #2 if I was building it :)
Nice. Microsoft still waiting for an easy printing option Q1 2021. Not coding 60 plus columns in HtMl.
Hopefully one of these days :) I have done so much HTML at this point it is just second nature :)
Shane - i cannot get my imagelink to appear. Do you have some advice on solution?
What are you putting for the image? Is it a url that requires authentication maybe
Quesiton: In the colShopping cart.
If someone were to select baby onesie size: NB QTY: 1 and add to cart and individually add to cart say 5 times the collection will show each item individually as opposed to baby onesie NB QTY: 5.
how would I set it up to where if somewhere does select the same item it just increases the quantity as opposed to an individual item line in the collection.
Figured it out:
In the Add to cart button OnSelect:
If(
// Check if the item with the same Title and Storage already exists in the collection
CountRows(
Filter(
colShoppingCart,
Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value
)
) > 0,
// If exists, update the quantity of the existing item
Patch(
colShoppingCart,
LookUp(
colShoppingCart,
Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value
),
{
Quantity: LookUp(
colShoppingCart,
Title = ThisItem.Title && Storage = SizeDropDown.Selected.Value
).Quantity + QTYDropDown.Selected.Value
}
),
// If it does not exist, add a new item to the collection
Collect(
colShoppingCart,
{
Title: ThisItem.Title,
Storage: SizeDropDown.Selected.Value,
Quantity: QTYDropDown.Selected.Value
}
)
);
// Resetting dropdowns and setting success variables
Reset(QTYDropDown);
Reset(SizeDropDown);
Set(varShowSuccess, true);
Set(varShowSuccessTimer, true);
Awesome job, glad you got it working.
is your merch storefront built with power apps? if not, why not?
Just some TH-cam tie in. 😎
Awesome videos sir, your videos are always clear and very helpful. Thank you for this. There is a Powerapps videos I would like you to assist me with and using Dataverse as your database please. Can you please create a Powerapps app when a user registers and login, after 24 hours the password will expire and they will be sent back to the registration page to re-register everytime the password has expired after 24 hours.
Great. Very helpful. I need to know how you view SharePoint list item version history in Powerapps. Can you make a video on it.
Not that I have ever done. Maybe via calling the API but not sure.
Hope you plan it some day. It would be helpful to many of your viewers
How do you create a collections? i just really want to create an app where I don't have to plug form the data.
Hi,
I am trying to patch my collection to a SharePoint list, all columns except the Qty column got patched. Please, how do I correct this? I am a beginner. This is the error message - cannot use a non record value in this context: ShowColumns(colshoppingcart, "ProductName", "SubTotal","Qty")
Thanks!
Wow. Thank you Chris! 🥰
Shane whats the code for the delete order?
Remove. I talk a lot about Delete here th-cam.com/video/xKXPmK00DCA/w-d-xo.html
Shane one feedback, the size of your photo in bottom right corner is little too big, please make it small because while you are talking we are more interested in understanding how things done rather looking at your face ;) Its kinda distraction
I kept help it I am so pretty I am a distraction.
This is strange, on my "Add to Cart" screen, placed sliders in the gallery to set quantities, if the gallery has 4 products, the slider quantity for the last product added (ex: product 4 - slider set to quantity: 3 units) is the quantity that registers on the "Checkout/Cart" screen for all items in the cart. Shouldn't each slider set the quantity for each respective product? :((