Power Apps Shopping Cart new for 2021 

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.

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.

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!

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 🙏

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.

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.

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

Wow, this was such a great tutorial Shane! This is my first attempt at a shopping cart and am very excited about learning more!

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.

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!

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! 😊

Shane, great video. Really good to be able to see an end to end solution being built and just what I was looking for

I had developed a similar app in 2020. Anyways, thanks again Shane for these lovely tutorials.

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!!

Hi Shane, great video. Delighted to learn from someone who dominates Power Apps so well. Regards.

Very helpful video, thanks! Could you please format the bigger chuncks of code, so it's easier to read for my dyslexic brain?

Shane, we can all tell you put A LOT into this video... THANK YOU! You are ThisItem.Appreciated!!! (LOL)

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 audibly laughed at "I kind of did all this cuteness" 19:29. Hahaha This helped me IMMENSELY!! THANK YOU!!

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!

Thanks Shane. Would be great to see the OrderID in the child list as a lookup item to the ID in the parent 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).

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.

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.

awesome Shane! I will use your example to create an IT Shopping Assets for my staffs ;) you are the best!

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.

Shane, you are the man! Thank you for great content!

Great videos as always! You´ve helped in many ways (with all of your videos!) you can´t imagine...Thanks for everything.

Nice. Microsoft still waiting for an easy printing option Q1 2021. Not coding 60 plus columns in HtMl.

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?

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

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

Awesome video Shane, I've learnt alot! How would you handle stock control if two people are ordering at the same time?

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!

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! :)

Hi Shane, This video was excellent but can you explain in detail process of SharePoint for beginners. Thankyou😊

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?

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?

your content is great, thank you very much from Colombia

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, 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

Thank you for sharing this with us!

uauuuu its amazing. congratulations my friend. This video is very very good.

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.

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?

Wonderful Video Shane. Thanks a lot. How can I have my cart show items after reopening the app?

What a splendid lecture, thanks for this

Great video! My collection isn't posting properly to the sharepoint list . Whats I need to fix?

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

Great video Shane. Can this be build for external customers and published to Google/Apple app store?

great video. lots of good info how would you do this in a model driven app???

Fantastic video Shane, thank you. 👏🏼👏🏼👏🏼

perfect as usual, do you make your videos while you are standing up !

Great. Very helpful. I need to know how you view SharePoint list item version history in Powerapps. Can you make a video on it.

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

Hi Shane, great video. How do I get hold of the template for the app?

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 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.

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 content i found here. Maybe if you don't mind to add search bar on Find Items. Thank you

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. 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?

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.

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?

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?

thx for chewy Merchandise :-) and great videos

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.

Hey!How to save each collection to sharepoint with order id so that each collection can be identified by an order id

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.

Thanks Shane excellent video

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

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?

Thank you so much Shane! I learn a lot of thing from your vid

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

is your merch storefront built with power apps? if not, why not?

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

How would you discount the stock at the time of purchase?

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.

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'?

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?!

If the quantity is given in a textinput instead of that slider, how could I proceed

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

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.

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.

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? :((

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.

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, How can you increment the slider in amounts of 10?

Some of these formula codes are long, like the greyed out arrow. anyway we can just copy and paste?

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?

Shane, you are the man

Shane - i cannot get my imagelink to appear. Do you have some advice on solution?

Thank you so much Bro!!

Shane whats the code for the delete order?

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 Shane Young, where View Orders button will navigate to ?

I'm just learning Power Apps, and i saw this video a few days ago, but could not done it because at the end of the tutorial, (where he is sending the values of the collection to the sharepoint), gave me an error where says something like: the colum "ItemSize" does not exist, the most similar is "ItemSize" so, exacly the same name but anyways, gave me the error... so a could not finish the tutorial... after that i saw many other tutorials to keep learning and found a solutions for this problem and came back to implement it, and finally it works!! So this is another way to finish the formula: Set( varRecordID, Patch( ListForOrders, Defaults(ListForOrders), { Title: TextInput1.Text, 'Order Comments': TextInput1_1.Text, 'Order Total': With( { ST: Sum( colShoppingCart, SubTotal ) }, ST + ST * .07 + 4.99 ) } ).ID ); ForAll( colShoppingCart, Patch( ListForOrdersDetailss, Defaults(ListForOrdersDetailss), { ProductName: Title, ProductPrice: ProductPrice, ProductId: ProductId, QTY: QTY, ItemSize: ItemSize, SubTotal: SubTotal, OrderID: varRecordID } ) ); Please, change the list name to your list name, You welcome guys.

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.