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 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.
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!
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.
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
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'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 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!
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
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.
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.
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);
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.
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
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. 😎
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
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 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
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
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?
@@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?
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?
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?!
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
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.
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?
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!
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 :)
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?
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.
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.
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.
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?
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")
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
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.
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.
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.
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.
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. :)
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 !! 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!
Anyone know the "if" logic to remove the empty dropdown fields if a size was onesize or no value was entered... I must be either stupid or tired, but probably both; but I keep getting errors
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?
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
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'?
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.
Great video, thanks. But I have one Problem: when I create this app for a cell phone it simple don’t pass the shopingcart-Collection to a second screen if I only select one item. The collection is showing without any problems on the same page as the goods gallery. As soon as I collect a second item the Collection will be shown on the second screen. If i delete all items there all works fine from this moment on, when I now select a new item for the Shopping cart the Collection immediatelly is shown on the second page. Does anybody have an idea what went wrong? Is there an issue with transferring collections from one screen to another?
Collections are not dependent on screens, they live in memory for the whole app. So unless there is some code somewhere changing them, moving to another screen wouldn't affect them. Here is a primer on Collections that might help th-cam.com/video/4zM-Oyhpc3U/w-d-xo.html
@@ShanesCows I know, the strange fact is that when I store 2 records in the collection all works perfect. Also when I clear the collection , go back to the gallery page and put another item in the collection all works perfect without any problems. It’s only when I just put one record in the collection and go to the second page that nothing is shown there in the gallery. And another thing I had to say: thank you for all your videos, you are a perfect teacher for power apps.
You can't directly. But you could let them move the slider by 1 and then just multiple the slider's value by 10. Have a label that is Slider1.Value * 10 and you can create what you want. :)
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
Thank you for the video! I have a few questions / issues: My collection isn't posting properly to the sharepoint list - I have an item name and quantity, with the added orderID, and the quantity and orderID post fine, but the name is blank when posting. The error I get when hovering over the collection is "The specified column 'OrderedItem' does not exist. The column with the most similar name is 'OrderedItem'. Any thoughts on how to get it to post the name of the item to that column in the SharePoint list? Additionally, how do you combine the two lists to give a holistic picture of the ordered in total: In your scenario it would be the name and comment, in mine it's their name and contact info, but pairing that with the item they ordered in one view so it can be tracked. Lastly, is there a way to deduct the amount the person ordered from your original inventory once it's been "shipped"? Thank you so much!
Recently I have not been able to make SP and Excel work together like they once did by importing a spreadsheet into a list and maintaining the column names, SP only recognizes them a s field_1, etc. Others have suggested that you use the Table Design/Export function in excel and create the list that way, which maintains the column titles.
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? :((
Hi, insted of put a slider, i put a text input to complete la qty with a number, but when i collect the data it dont reconize the qty, i put the exactly title's name. But i think there are problem with the format. I see the all are number but nothing :c
Is it possible to patch a datasource using the data from a collection? For example I am trying to update the quantity in my datasource based on the quantity of the Shopping Cart Collection. Currently I am using the slider value to patch the quantity in my datasource but with this method it only updates the quantity of one product. I am not sure how to get the values from the collection to patch the quantitiy for all products. I hope somone understands the problem and can help me out a little bit.
Yes you can. Collections are data sources so you can get data from them the same. I think in this video I show saving to a collection and then patching from the collection. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
I use excel rather than sharepoint for data source. Why when i can't change my dropdown based on the excel, it is not working? I mean not change happen. Please help me
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 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 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 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
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!
Thanks!
Wow. Thank you Chris! 🥰
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!
@@HappyLifeAbroadStories Did you ever figure this out?
@@EmoreeColey1 which part ? :D
I got the whole thing to work in the end.
Shane, we can all tell you put A LOT into this video... THANK YOU! You are ThisItem.Appreciated!!! (LOL)
Thanks Shawn!
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. 🐶
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.
Thanks
Thank you Chrisy.
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
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! 🙌
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!
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!
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!
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
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.
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.
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.
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.
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.
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.
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. 😎
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
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
I had developed a similar app in 2020. Anyways, thanks again Shane for these lovely tutorials.
Cool 🤩
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!
Hi Shane, great video. Delighted to learn from someone who dominates Power Apps so well. Regards.
You are too kind. 😊
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.
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
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
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?
How would you discount the stock at the time of purchase?
Do you mean reduce the price or reduce the quantity from inventory?
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
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
Great videos as always! You´ve helped in many ways (with all of your videos!) you can´t imagine...Thanks for everything.
Shane, you are the man! Thank you for great content!
Happy to help. Have a great day. 🐶
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, 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.
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.
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. :)
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!
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 :)
Some of these formula codes are long, like the greyed out arrow. anyway we can just copy and paste?
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.
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 audibly laughed at "I kind of did all this cuteness" 19:29. Hahaha
This helped me IMMENSELY!! THANK YOU!!
Happy to help Brenn!
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
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.
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.
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.
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
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
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.
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?
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")
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
Hi Shane Young, where View Orders button will navigate to ?
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
@@ai_lordofthedarkshadows 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
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.
If the quantity is given in a textinput instead of that slider, how could I proceed
Value(TextInput1.Text) is how you turn a text number into an actual number :)
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.
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.
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.
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 !! 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. 😎
Anyone know the "if" logic to remove the empty dropdown fields if a size was onesize or no value was entered... I must be either stupid or tired, but probably both; but I keep getting errors
If(Self.Selected.Value = 0, Remove(collection, ThisItem)) Something like that should work.
@@ShanesCows thank you for your comment, I'm getting an incompatible type for comparison, these types can't be compared record, number
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?
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 :)
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!
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'?
great video. lots of good info
how would you do this in a model driven app???
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.
Great video, thanks.
But I have one Problem: when I create this app for a cell phone it simple don’t pass the shopingcart-Collection to a second screen if I only select one item. The collection is showing without any problems on the same page as the goods gallery.
As soon as I collect a second item the Collection will be shown on the second screen.
If i delete all items there all works fine from this moment on, when I now select a new item for the Shopping cart the Collection immediatelly is shown on the second page.
Does anybody have an idea what went wrong? Is there an issue with transferring collections from one screen to another?
Collections are not dependent on screens, they live in memory for the whole app. So unless there is some code somewhere changing them, moving to another screen wouldn't affect them. Here is a primer on Collections that might help th-cam.com/video/4zM-Oyhpc3U/w-d-xo.html
@@ShanesCows I know, the strange fact is that when I store 2 records in the collection all works perfect. Also when I clear the collection , go back to the gallery page and put another item in the collection all works perfect without any problems. It’s only when I just put one record in the collection and go to the second page that nothing is shown there in the gallery.
And another thing I had to say: thank you for all your videos, you are a perfect teacher for power apps.
Hi,
How can you increment the slider in amounts of 10?
You can't directly. But you could let them move the slider by 1 and then just multiple the slider's value by 10. Have a label that is Slider1.Value * 10 and you can create what you want. :)
What a splendid lecture, thanks for this
Happy to help
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
uauuuu its amazing. congratulations my friend. This video is very very good.
Thank you! Cheers!
How do you create a collections? i just really want to create an app where I don't have to plug form the data.
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
If the product is in out of stock how should I disable the cart?
your content is great, thank you very much from Colombia
Thanks for watching!
Thank you for the video! I have a few questions / issues: My collection isn't posting properly to the sharepoint list - I have an item name and quantity, with the added orderID, and the quantity and orderID post fine, but the name is blank when posting. The error I get when hovering over the collection is "The specified column 'OrderedItem' does not exist. The column with the most similar name is 'OrderedItem'. Any thoughts on how to get it to post the name of the item to that column in the SharePoint list?
Additionally, how do you combine the two lists to give a holistic picture of the ordered in total: In your scenario it would be the name and comment, in mine it's their name and contact info, but pairing that with the item they ordered in one view so it can be tracked.
Lastly, is there a way to deduct the amount the person ordered from your original inventory once it's been "shipped"?
Thank you so much!
Recently I have not been able to make SP and Excel work together like they once did by importing a spreadsheet into a list and maintaining the column names, SP only recognizes them a s field_1, etc. Others have suggested that you use the Table Design/Export function in excel and create the list that way, which maintains the column titles.
Did you get the solver about the collection list isn't posting in the sharepoint?
Fantastic video Shane, thank you. 👏🏼👏🏼👏🏼
Glad you enjoyed it!
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? :((
Hi, insted of put a slider, i put a text input to complete la qty with a number, but when i collect the data it dont reconize the qty, i put the exactly title's name. But i think there are problem with the format. I see the all are number but nothing :c
Value(TextInput.Text) will make it a number. 😎
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 we add to cart if not using collections ?
Is it possible to patch a datasource using the data from a collection? For example I am trying to update the quantity in my datasource based on the quantity of the Shopping Cart Collection. Currently I am using the slider value to patch the quantity in my datasource but with this method it only updates the quantity of one product. I am not sure how to get the values from the collection to patch the quantitiy for all products.
I hope somone understands the problem and can help me out a little bit.
Yes you can. Collections are data sources so you can get data from them the same. I think in this video I show saving to a collection and then patching from the collection. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
I use excel rather than sharepoint for data source. Why when i can't change my dropdown based on the excel, it is not working? I mean not change happen. Please help me
An excel table works the same way that a SharePoint list does. Shouldn’t be different
Alright. Thanks again
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
How do I do to separate product by category?
is your merch storefront built with power apps? if not, why not?
Just some TH-cam tie in. 😎
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! :)