I must have watched your video on inline editing 1000 times in the past week trying to understand the process and implement that into the shopping cart example as shown in this video. I was just about to give up, but today I had a breakthrough!! I have finally managed to get this to work. Thank you for sharing these videos, you have been a great help and I have learned so much from watching them.
This is awesome!. Just what I needed for our office supply inventory. We track who ordered, what, when and will add one more element of how much is on hand after order. Also setting up to where when a quantity hits a certain number, it will send an alert and highlight the item in SharePoint that supply is low!!!!!!
It may seem simple but I was able to make the application myself. For me it is magnificent because I feel that I am learning and you are helping me to grow ... Thank you very much Shane I love your videos with logic
Shane this is just what I needed to replace a system. Where can I find the other videos you mention that go over how to brand and add the additional functionality?
I never made another video in this. I should. The closest I have that talks about saving the data is th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html I hope it helps
Hi Shane. Great one. But at the end of the video, the place order only saves the general details of the orders of name and total. How did you save the rest of the order details example the each items of the shirts in terms of quantity for each added shirt?
This video is on my list to remake. Try this series for now. th-cam.com/video/xgznk4XlPCo/w-d-xo.html It talks about relationships and I think will help.
Hi Shane, I am trying to rebuilt the shopping cart you made but I need to see the order details in a excel file I have connected to it to know what was in the order. How can I get power apps to send the collection detials to an excel file?
Hi yet again Shane.... A funny little problem (not affecting operation of app) has popped up and I'm not sure where the issue has arrived from. Doing this cart application. I have the master list and the details list. In the details list I have a column that everywhere I look it is called ItemQty. Its a number field and works fine. However when I try to pull the data from this list its referred to as "Date" in flow and power BI. Any ideas how that name changed? Did I bury something in the app somehow? In the SP settings for the list the name is shows as ItemQty as well. I appreciate this is probably hard to understand. I can email you some screen shots if you want. Its got me stumped but am hesitant to add a new ItemQty column in the SP list and dump the old one as I'm sure I'll break it and that will be quite depressing... (crying emoji inserted here)
@@ShanesCows Dammit.... I must have done this when I started the list. I created a new column and moved the various parts of the form to the new column. I found another one too after reviewing all the columns on all the lists I am using. Details, details, details eh. Thanks for the hover tip. Now I just have to figure out how to get the two tables merged using the master id into a new list... (I wish that MS would build a "relationships building pop up screen" in Flow, like in Access/PowerBI etc so that in flow you could drag and drop and create relationships)
Hey Luke. Do you mean the how I made it all so pretty video? I never did that one. I should do something on branding though. If you meant another video let me know. I confuse me sometimes. :)
That is correct! I'd be highly interested in seeing that video [branding]. On a side note, greatly appreciate these videos! Best thing to happen to PowerApps. You need to create an area that would allow individuals to leave tips/donations!
hi shane, Could you help me with this query. I have a gallery where I show some data, in that data there is a price value. I need to select the elements of the gallery that I need and add them without passing an x value.
Another query... I have the fields which are "once per order" and outside the cart collection gallery. I have multiple items in the cart but do not have a total. I would like to write each line using the "outside the gallery" data as a common item, but have the rest related to the different cart items. I believe the idea is to user ForAll() for this, but I'm unsure of how to treat the collection now.
@@ShanesCows Thanks Shane. I went and reviewed the info path series. I had actually watched them before but remembered that you used a totaling where I needed "less complications". The info path videos held the answer though. Thanks again.
hey Shane, how do u display Image type from Lists in Power App Gallery. mine is not showing. it just show the default grey image in the Power App Gallery
Hi Shane, I'm really new to powerapps, and have created an order app from watching this video. One thing, and I don't know if it's possible, but if you have multiple items which you've ordered, when you push it back to SharePoint it creates separate list items for each item ordered. Is there a way to just create one SharePoint list item which show all the order items for that one order>
Hey Claire. Yes, but I don't follow exactly how you are doing it. You could use Concat function to combine the values in the collection. Or maybe use this concept to create relationships? th-cam.com/video/xgznk4XlPCo/w-d-xo.html
This is a great video! Thank you so much for all the awesome information. I would like to see the follow-up video on how you did the edit button, but I wasn't able to find it. Do you go over that functionality, or a similar solution, in a different video? I also am wondering about having a link off of your details screen that allows the user to select more options (each with their own costs) that would update the shopping cart total. I guess for your example it could be a screen that let's them select a logo if they want (bumps up the price $10) or if they wanted the material to be a different kind it would bump the price up or down. Do you have a video that covers something along those lines?
Hi Shane, great vid, thank you for that. So far I'm a bit confused where the boundaries are until where it's sensible to build a web shop on top of PowerApps. Do you have an opinion about that? Did you e.g. deploy some of those in the fields and found out it did or did not work with a certain load? Or with typical web shop things like SEO requirements? Thanks!
Hey, @shaneyoung this is a great video, I learned a lot. I am building out a shopping cart as such, but how would I display all the items purchased and have it displayed on the Orders list? Is there a way to save the items in the collection into a text box?
2 Things 1 - Downloads for some videos are avaiable via this training.powerapps911.com/courses/video-library 2 - There is an updated version of this video th-cam.com/video/Ztn39KuOW0g/w-d-xo.html
Hi Shane... I have a list that I'm trying to use with the cart gallery. Instead of the icon I want to use the image that I have added for each item in a column called ItemImage (image type column). When I add an image control to the gallery item and pull the only image related thing I can find (called Thumbnail instead of my ItemImage column) it returns "text" as a result. Any idea how to get the actual thumbnail image that shows in Sharepoint?
OK... so a LOT of searching and I ended up needing to create another text column (multi line) and paste the Base64 data for the image (meaning converting all the images). So now it works fine. Its a strange way of doing it given that SP renders a nice thumbnail itself.
Shane Thanks this was very helpful getting my app off the ground one question how do I get the shopping carts items to push to the “orders” connection? My app only pulls in the “quantity ,location,user,.....all inputs I added however the shopping cart never Uploads....trouble some for an order if no item information is sent....lol
Hey Shane! I would like to see another video on how you wrote the If statements to do all the crazy stuff on the finished app. Exactly what I am looking to do. Or just send me a explanation either would be fantastic. Thanks you're amazing!
Hey Shane, thanks for the video. Very informative. One question ...and it relates heavily to a project I am doing at work. So after the order is placed, how is it cleared without the shopper clearing it all out? In my case, I am sending multiple records via email and I have tried to put a Reset() after my SendEmail but it doesn't like it. Any suggestions?
Hi Shane, is there a way to write the order details back to the SharePoint list, I get that you could do a collection or patch to a SharePoint list, but how do you configure your list in the first place as you would have to add, at a minimum a column per order item and that would be if you concatenated all the individual items together per gallery item, but potentially a customer could order 100 items! Would you have to pre create all these columns just in case? As if so 99% of the time all but a few will be blank! Is there not a way to write a collection, table or gallery to a single record in a list? If so, how? If not, how would you get around ensuring your list is large enough to career for large orders? Would you maybe do 5 columns and have a maximum order qty per each order an the user would have to place several orders!? Thoughts please!? Ps. Great video as always!
Think of the problem differently where you store the ordered items in a related list. Check out this video on an expense report for the concept. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data th-cam.com/video/xgznk4XlPCo/w-d-xo.html It is exactly what you want to do from a storage point of view.
Here's how I accomplished this. It is simple and considering it will not ever have a huge shopping cart. Order is my column name in the SP List. Order: Concat(ShoppingCart, ItemType & ", " & OrderSize & ", " & OrderQuantity, "; "),
Sorry I am behind on comments. I don't remember and can't find the app. I really need to make this video again. 😀 Adding it to my video list. Thanks for the motivation.
Hi Young, your video is so helpful and l just wonder how to get this shopping cart apps better so how to let end users can save their favorite caddy on mobile or I don’t know where so they no need to input next time and get all they want by 1 click? Long for your reply: )
Great video! It gave me aome many ideas to work with. One concer nonetheless, if multiple user are sending information to a collection are these useres able to see or delete others people input?
Hey Shane, Just wondering How can I write a full collection back to one SharePoint List item? Here's the scenario- I have a food purchasing system built that I want that when a new PO is created all the contents of order are then collected and emailed across as one whole PO. Only issue is is that when I click submit they create multiple list items. Thanks Darragh
This video is so helpful! At the end, you show a finished app with a pencil that brings up a combo box with the current quantity selected and allows you to change quantity. I am having trouble having the combo box populate with the chosen quantity by default. I have tried several things with DefaultSelectedItems. Do you have a video that touches on how to do this? Thanks!
I didn’t write them back. Meant to talk about it in the video. If you want To add them then add columns to the Orders list in SharePoint and add them to the collect button. Make sense?
I didn’t write them back. Meant to talk about it in the video. If you want To add them then add columns to the Orders list in SharePoint and add them to the collect button. Make sense?
Interesting. So you can write a collection to the SharePoint list and that would do it. Collect (orders, shoppingcart) but they would have to have the same columns.
Great Video Shane. This was the question that I had 3 Videos ago about passing information from a collection to table in Excel (Or sharepoint List in Sharepoint) and viceversa. Ty so much. You are a Great teacher!!!! I´m goint to try this in my App ;)
Hi Shane! Great video! Everything is working just fine in the development environment but I am having a hard time trying to run the app on my iPhone or even in Teams. It simply does not work and I get a blank screen! Do you know what could be happening?
Hey Shane! Thanks a lot for such a wonderful video. Lot many things have covered in it. Just one question. For "Place Order", why have you used Collect and not Patch Function? How does it make a difference if we use Patch here?
Hi, Thank you so much for your video. It's working well. I wondering if you have done a video how to add individual item to the SharePoint List. Thanks
Hi, Shane! My co-worker and I are trying to make an app similar to this one where people can place orders on food. However, we are having difficulties in getting the app to write the exact number of orders of each item back to the sharepoint list. So that if a person wants for example 2 hamburgers, 3 salads and 4 cupcakes, the SharePoint List only returns the first item and not the rest. We need to make the app return the items ordered and the number of items ordered, not just the first one but all of them. Do you have an answer to how we can fix this?
Hello Shane great video. I want to implement this but one drawback is that i want to create a new list which will contain the order details for each order. The way i see it is to dynamically create a new list with the name of the customer and the date/time with the order details each time the submit button is pressed. Do you think this is possible? Thank you for sharing your expertise with us.
@@ShanesCows One other approach could be to have a predefined list and a new item to be added with the collection items attached as a file (excel file for example) each time an order takes place. What do you think about that?
Sadly I never did. Good news is I am working on redoing this video series on shopping carts. IN the meantime this series walks you through almost the same concept. th-cam.com/video/xgznk4XlPCo/w-d-xo.html
Shane, First - AWESOME. Second, can you send me the link for the other video you reference (updating the items in the Shopping Cart and Disappearing buttons through IF statements
Hey Scott I never made the follow up video. Boo me. Check out this video. This 3 part series was completed and shows you a lot of the concepts I think you are looking for. th-cam.com/video/xgznk4XlPCo/w-d-xo.html If not feel free to leave another comment and I will try to help more.
Try this video. Much deeper explanation of the concepts. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data th-cam.com/video/xgznk4XlPCo/w-d-xo.html of that doesn’t help make a new comment to ask again.
Hey! Can you somehow make sure, that the user can only add an item to the cart ones? If the same item is in the cart more than one time, the PATCH function will get confused. Hope you can help.
Does any know how to subtract two columns in a Collection? It's funny that you can use the "Sum" function to both add and multiply, but I am not so lucky using it for subtraction.
Hi, Shane can you maybe help on my text field on android I can use a . only allow me to use , on currency field android if I type 123.78 when I get to the . it just clear but when I use , it work the manipulation [$-enUS] that stuff and Substitute don't work please help. Sorry my English is not the best
In this video th-cam.com/video/HTY8AnMz5rw/w-d-xo.html I talk about Check in and out and show changing number of items in Inventory. So you could steal that concept and add it to this one. FWIW - There is an even newer version of this shopping cart video th-cam.com/video/Ztn39KuOW0g/w-d-xo.html
Shane this is a great application. I started with your older version. I have been able to customize this for my specific application. I would like to add a search feature on the Supply list screen. How could i do that?
What if I want a blue long-sleeve shirt :) Another good video from you. I am in the midst of writing a Power App that is using a number of SharePoint lookup columns that are giving me issues and fits and I have to find a work around for them. And using the RTF text boxes in Power Apps (editing) I wish did work too. Sadly not yet.
Yeah. Look up columns and PowerApps just are not BFFs. :) Do you have to have them? Could you rework your SharePoint data and maintain the connections with PowerApps instead?
I do use variables at times as a "work around". In my apps I do use the Office365Connection quite a bit and those lookups to the AD are a pain when trying to save back to a SP list. They are better now that Power Apps uses the "Choice" fields. On a separate topic, would you do a video covering Common Data Service and the big update coming to Power Apps using Model Driven apps versus using the Canvas?
You probably already know this but here is super simple way to get your images loaded automatically. Step 1 create a picture library. Step 2. Add a picture column to your t-shirts list in SP. Step 3. copy link from each image in the pic library and add it to the picture column in the t-shirt list. Now when you select "Image, title, and sub title" as your layout and then PowerApps does the rest.
I am building my first app and have found your videos to be extremely helpful! I can't find the video where you edited fields in the shopping cart. For some reason I can't get the field I'm using for Quantity (text input) to update with the new number entered. Help! Also, could you make a video on how to create a barcode scan so that when you scan one item three times it doesn't show as three items in the collection?
real life case: what if i want to save my cart and next day i come again.. add few more stuff to my cart, deduct one or two previously selected items from cart and then place order? Plz do video on such too.
Hi Shane, great tutorial videos! Where is the follow up video that explains how to add the functionality of changing the quantity of each item from the cart screen?
hello John. I am not sure I ever made that one. Email me with the part you are struggling with and I will try to help. Screenshots help. shane at powerapps.com
@@ShanesCows Hi Shane, I actually opted out with a OnChange and Patch function with a text input for the quantity on the carts screen. I appreciate your help, watching your Powerapps PDF generator video as we speak. Thanks a million!
Muy buen video me ayudo bastante, como podria guardar toda la coleccion de pedidos en la lista de SharePoint en una columna de varias lineas. para un solo pedido. y luego de haber guardado el pedido como poder cambiar los detalles del producto (por ejemplo la cantidad)
Shane Actually my question about cart icon i want cart icon show purchase quantity number . i am trying to use lookup function but not solve my problem.
Ufff & Uhhh, I made it. Fuck you Microsoft! Thank you Shane :)! It was epic video! Everything worked and You explained all of this in pretty cool way. Everything is understandable. I really appreciate your help and the situation in which you spend your time to show us this functionality of PowerApps. Thank you very much for your help again! Good luck in the future!
So, let's get it started .. Let's see which thing of those powershitapps won't work properly cuz smth already changed there in this fcking Microsoft mind.
New 2021 Version of the Shopping Cart is available now th-cam.com/video/Ztn39KuOW0g/w-d-xo.html
I must have watched your video on inline editing 1000 times in the past week trying to understand the process and implement that into the shopping cart example as shown in this video. I was just about to give up, but today I had a breakthrough!! I have finally managed to get this to work. Thank you for sharing these videos, you have been a great help and I have learned so much from watching them.
Cool. Congrats
This is awesome!. Just what I needed for our office supply inventory. We track who ordered, what, when and will add one more element of how much is on hand after order. Also setting up to where when a quantity hits a certain number, it will send an alert and highlight the item in SharePoint that supply is low!!!!!!
Nice! :)
It may seem simple but I was able to make the application myself.
For me it is magnificent because I feel that I am learning and you are helping me to grow ... Thank you very much Shane
I love your videos with logic
This makes me happy. Thanks
Shane this is just what I needed to replace a system. Where can I find the other videos you mention that go over how to brand and add the additional functionality?
I never made another video in this. I should. The closest I have that talks about saving the data is th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html I hope it helps
@@ShanesCows What would cause the Gallery.Selected to give an invalid formula error?
Disregard, starting over helps too
This was just what I needed! Your channel is definitely going to be on my screen a lot in the days and weeks to come, so thank you soo much =)
Awesome. :) Let me know how it goes.
Hi Shane. Great one.
But at the end of the video, the place order only saves the general details of the orders of name and total. How did you save the rest of the order details example the each items of the shirts in terms of quantity for each added shirt?
This video is on my list to remake. Try this series for now. th-cam.com/video/xgznk4XlPCo/w-d-xo.html It talks about relationships and I think will help.
Sure. Thanks so much.
Hi Shane,
I am trying to rebuilt the shopping cart you made but I need to see the order details in a excel file I have connected to it to know what was in the order. How can I get power apps to send the collection detials to an excel file?
Look to combine ForAll and Patch to loop through the collection
I love these concepts !!! Microsoft should pay you for every video kkkk
Thanks 😊
Hi yet again Shane.... A funny little problem (not affecting operation of app) has popped up and I'm not sure where the issue has arrived from. Doing this cart application. I have the master list and the details list. In the details list I have a column that everywhere I look it is called ItemQty. Its a number field and works fine. However when I try to pull the data from this list its referred to as "Date" in flow and power BI. Any ideas how that name changed? Did I bury something in the app somehow? In the SP settings for the list the name is shows as ItemQty as well. I appreciate this is probably hard to understand. I can email you some screen shots if you want. Its got me stumped but am hesitant to add a new ItemQty column in the SP list and dump the old one as I'm sure I'll break it and that will be quite depressing... (crying emoji inserted here)
Did you see this video? If you hover over the column does it show ItemQTY or Date? th-cam.com/video/mwXnJUkTug0/w-d-xo.html
@@ShanesCows Dammit.... I must have done this when I started the list. I created a new column and moved the various parts of the form to the new column. I found another one too after reviewing all the columns on all the lists I am using. Details, details, details eh. Thanks for the hover tip. Now I just have to figure out how to get the two tables merged using the master id into a new list... (I wish that MS would build a "relationships building pop up screen" in Flow, like in Access/PowerBI etc so that in flow you could drag and drop and create relationships)
Hey Shane, where is the link to the video of the more in-depth PowerApp you created that is mentioned 27:37?
Hey Luke. Do you mean the how I made it all so pretty video? I never did that one. I should do something on branding though. If you meant another video let me know. I confuse me sometimes. :)
That is correct! I'd be highly interested in seeing that video [branding]. On a side note, greatly appreciate these videos! Best thing to happen to PowerApps. You need to create an area that would allow individuals to leave tips/donations!
hi shane,
Could you help me with this query. I have a gallery where I show some data, in that data there is a price value. I need to select the elements of the gallery that I need and add them without passing an x value.
This video shows how to use ForAll to select records. th-cam.com/video/0xZ4fMJbLvk/w-d-xo.html
Another query... I have the fields which are "once per order" and outside the cart collection gallery. I have multiple items in the cart but do not have a total. I would like to write each line using the "outside the gallery" data as a common item, but have the rest related to the different cart items. I believe the idea is to user ForAll() for this, but I'm unsure of how to treat the collection now.
Tony the series here shows exactly that. th-cam.com/video/xgznk4XlPCo/w-d-xo.html
@@ShanesCows Thanks Shane. I went and reviewed the info path series. I had actually watched them before but remembered that you used a totaling where I needed "less complications". The info path videos held the answer though. Thanks again.
hey Shane, how do u display Image type from Lists in Power App Gallery.
mine is not showing. it just show the default grey image in the Power App Gallery
Do you have ThisItem.Field name? It just works for me in my demos.
Hi Shane, I'm really new to powerapps, and have created an order app from watching this video. One thing, and I don't know if it's possible, but if you have multiple items which you've ordered, when you push it back to SharePoint it creates separate list items for each item ordered. Is there a way to just create one SharePoint list item which show all the order items for that one order>
Hey Claire. Yes, but I don't follow exactly how you are doing it. You could use Concat function to combine the values in the collection. Or maybe use this concept to create relationships? th-cam.com/video/xgznk4XlPCo/w-d-xo.html
This is a great video! Thank you so much for all the awesome information. I would like to see the follow-up video on how you did the edit button, but I wasn't able to find it. Do you go over that functionality, or a similar solution, in a different video?
I also am wondering about having a link off of your details screen that allows the user to select more options (each with their own costs) that would update the shopping cart total. I guess for your example it could be a screen that let's them select a logo if they want (bumps up the price $10) or if they wanted the material to be a different kind it would bump the price up or down. Do you have a video that covers something along those lines?
This series is this concept on steroids and will help with Edit. th-cam.com/video/xgznk4XlPCo/w-d-xo.html
Beautiful. Thank you for the response, sir. I'll check it out!
Hi Shane, great vid, thank you for that. So far I'm a bit confused where the boundaries are until where it's sensible to build a web shop on top of PowerApps. Do you have an opinion about that? Did you e.g. deploy some of those in the fields and found out it did or did not work with a certain load? Or with typical web shop things like SEO requirements? Thanks!
You cannot make PowerApps anonymous so I think that would stop you.
Hey, @shaneyoung this is a great video, I learned a lot. I am building out a shopping cart as such, but how would I display all the items purchased and have it displayed on the Orders list? Is there a way to save the items in the collection into a text box?
Look for my Video on Concat function
@@ShanesCows Thanks Shane! Checking it out.
Your videos are very helpful to me. Thank you Shane ! If you could provide us the data files, it would be great
2 Things
1 - Downloads for some videos are avaiable via this training.powerapps911.com/courses/video-library
2 - There is an updated version of this video th-cam.com/video/Ztn39KuOW0g/w-d-xo.html
Hi Shane... I have a list that I'm trying to use with the cart gallery. Instead of the icon I want to use the image that I have added for each item in a column called ItemImage (image type column). When I add an image control to the gallery item and pull the only image related thing I can find (called Thumbnail instead of my ItemImage column) it returns "text" as a result. Any idea how to get the actual thumbnail image that shows in Sharepoint?
OK... so a LOT of searching and I ended up needing to create another text column (multi line) and paste the Base64 data for the image (meaning converting all the images). So now it works fine. Its a strange way of doing it given that SP renders a nice thumbnail itself.
I covered this in my latest video where I answer comments and yours was one of them. 😀 th-cam.com/video/8eoaSsXnh6Q/w-d-xo.html
Shane
Thanks this was very helpful getting my app off the ground one question how do I get the shopping carts items to push to the “orders” connection? My app only pulls in the “quantity ,location,user,.....all inputs I added however the shopping cart never Uploads....trouble some for an order if no item information is sent....lol
Look for my video on ForAll to patch
Hey Shane! I would like to see another video on how you wrote the If statements to do all the crazy stuff on the finished app. Exactly what I am looking to do. Or just send me a explanation either would be fantastic. Thanks you're amazing!
I honestly don't remember. :) Send me an email and I will see if I can find it for you. shane @powerapps911.com
Can this be done with Excel sheets? I could import all the data but I couldn't save the final name and cart total.
Patch to save data back to Excel. th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
@@ShanesCows Thanks a lot
Hi Shane, Where can I find the video on how to Edit and delete functionality in shopping cart please?
I still haven't made that. Closest I have is this series th-cam.com/video/xgznk4XlPCo/w-d-xo.html
You are a legend ! Thanks for making it look so simple.
Happy to help 👍
Hey Shane, thanks for the video. Very informative. One question ...and it relates heavily to a project I am doing at work. So after the order is placed, how is it cleared without the shopper clearing it all out? In my case, I am sending multiple records via email and I have tried to put a Reset() after my SendEmail but it doesn't like it. Any suggestions?
Sendemail(....);Clear(ShoppingCart) should do it for you. Same as the delete button.
Hi Shane, is there a way to write the order details back to the SharePoint list, I get that you could do a collection or patch to a SharePoint list, but how do you configure your list in the first place as you would have to add, at a minimum a column per order item and that would be if you concatenated all the individual items together per gallery item, but potentially a customer could order 100 items! Would you have to pre create all these columns just in case? As if so 99% of the time all but a few will be blank!
Is there not a way to write a collection, table or gallery to a single record in a list? If so, how?
If not, how would you get around ensuring your list is large enough to career for large orders? Would you maybe do 5 columns and have a maximum order qty per each order an the user would have to place several orders!?
Thoughts please!?
Ps. Great video as always!
Think of the problem differently where you store the ordered items in a related list. Check out this video on an expense report for the concept. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data th-cam.com/video/xgznk4XlPCo/w-d-xo.html It is exactly what you want to do from a storage point of view.
Here's how I accomplished this. It is simple and considering it will not ever have a huge shopping cart. Order is my column name in the SP List.
Order: Concat(ShoppingCart, ItemType & ", " & OrderSize & ", " & OrderQuantity, "; "),
Full String
Collect(List_Test_Store_Orders, {Title: "na", OrderPlaced: OrderDateTime.Text, Name: InputName.Text, Email: InputEmail.Text, Order: Concat(ShoppingCart, ItemType & ", " & OrderSize & ", " & OrderQuantity, "; "), OrderTotal: Sum(ShoppingCart, ItemCost * OrderQuantity)}); Navigate(Store); Clear(ShoppingCart)
How should I go about creating + or - buttons for a quantity? Increments of 1. Thx
I haven’t done it but here is a way powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/
Excellent Video! How did you code the pencil icon to modify the shopping cart?!!
Sorry I am behind on comments. I don't remember and can't find the app. I really need to make this video again. 😀 Adding it to my video list. Thanks for the motivation.
can you export this collection to excel like you did it for excel...... i tried to give the name of the excel table but it is not getting updated
Yes, that should work if the column names match between the two.
@@ShanesCows i will try it
It is not working with excel 😭
@@TheShubham743 Same for me. Didn't work
@@ShanesCows i did it and it worked ....thanks shane
Hi Young, your video is so helpful and l just wonder how to get this shopping cart apps better so how to let end users can save their favorite caddy on mobile or I don’t know where so they no need to input next time and get all they want by 1 click? Long for your reply: )
Try this video on saving data th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
Great video! It gave me aome many ideas to work with. One concer nonetheless, if multiple user are sending information to a collection are these useres able to see or delete others people input?
No. Each collection is for only the users session.
Hey Shane, Just wondering How can I write a full collection back to one SharePoint List item? Here's the scenario- I have a food purchasing system built that I want that when a new PO is created all the contents of order are then collected and emailed across as one whole PO. Only issue is is that when I click submit they create multiple list items. Thanks Darragh
I replied on Twitter
Hello Shane, awesome content. But the shopping cart doesn't show notification as to how many items are currently in the cart.
You can use CountRows to get the number of items in the collection
This video is so helpful! At the end, you show a finished app with a pencil that brings up a combo box with the current quantity selected and allows you to change quantity. I am having trouble having the combo box populate with the chosen quantity by default. I have tried several things with DefaultSelectedItems. Do you have a video that touches on how to do this? Thanks!
Hey, Shane. What about the Order Details - How are they written back to SharePoint?
I didn’t write them back. Meant to talk about it in the video. If you want To add them then add columns to the Orders list in SharePoint and add them to the collect button. Make sense?
I didn’t write them back. Meant to talk about it in the video. If you want To add them then add columns to the Orders list in SharePoint and add them to the collect button. Make sense?
Would PowerApps know to write multiple records?
Interesting. So you can write a collection to the SharePoint list and that would do it. Collect (orders, shoppingcart) but they would have to have the same columns.
Great Video Shane. This was the question that I had 3 Videos ago about passing information from a collection to table in Excel (Or sharepoint List in Sharepoint) and viceversa. Ty so much. You are a Great teacher!!!! I´m goint to try this in my App ;)
Hi Shane... please make 2nd part of the video.
I need to. This video has been super popular the last month.
You are awesome Shane young .I love your videos Thank you so much....
Glad to help. 😀
Hi Shane! Great video! Everything is working just fine in the development environment but I am having a hard time trying to run the app on my iPhone or even in Teams. It simply does not work and I get a blank screen! Do you know what could be happening?
I don’t. Did you publish the app?
Appreciate all your materials.
Happy to help
Hey Shane! Thanks a lot for such a wonderful video. Lot many things have covered in it. Just one question. For "Place Order", why have you used Collect and not Patch Function? How does it make a difference if we use Patch here?
Either should work. You would just need to use ForAll with Patch
Hi, Thank you so much for your video. It's working well. I wondering if you have done a video how to add individual item to the SharePoint List. Thanks
Maybe try this video? th-cam.com/video/MclJ_O9HvJQ/w-d-xo.html
Hi, Shane! My co-worker and I are trying to make an app similar to this one where people can place orders on food. However, we are having difficulties in getting the app to write the exact number of orders of each item back to the sharepoint list. So that if a person wants for example 2 hamburgers, 3 salads and 4 cupcakes, the SharePoint List only returns the first item and not the rest. We need to make the app return the items ordered and the number of items ordered, not just the first one but all of them. Do you have an answer to how we can fix this?
You need to use ForAll to Patch your collection back.
I used a concatenate of the collection to have all details summarized in a text box:
Concat(Carrito;Cliente& " " & Pais& " " & Sede; "/// ")
Hello Shane great video. I want to implement this but one drawback is that i want to create a new list which will contain the order details for each order. The way i see it is to dynamically create a new list with the name of the customer and the date/time with the order details each time the submit button is pressed. Do you think this is possible? Thank you for sharing your expertise with us.
Yikes. I have never tried to make new lists. Maybe with the Graph api you could but not really sure.
Shane Young Understood. I will see intro it. Thank you
@@ShanesCows One other approach could be to have a predefined list and a new item to be added with the collection items attached as a file (excel file for example) each time an order takes place. What do you think about that?
@@ShanesCows I mean there has to be a way to see the collection from power apps within sharepoint right?
Can I know where the other video is with Edit and delete functionality in shopping cart please? great video. Thanks.
Sorry that one never got made. 😔 Check our repeating tables like infopath for some help that is like this.
Hi Shane excellent video, but I dontt understand a part, how you save the detail of the order in your sharepoint list
Check out my video repeating tables like Infopath. It covers it better.
Amazing video Shane. Please share the link of another video where you added edit functionality.
Sadly I never did. Good news is I am working on redoing this video series on shopping carts. IN the meantime this series walks you through almost the same concept. th-cam.com/video/xgznk4XlPCo/w-d-xo.html
Shane, First - AWESOME. Second, can you send me the link for the other video you reference (updating the items in the Shopping Cart and Disappearing buttons through IF statements
Hey Scott I never made the follow up video. Boo me. Check out this video. This 3 part series was completed and shows you a lot of the concepts I think you are looking for. th-cam.com/video/xgznk4XlPCo/w-d-xo.html If not feel free to leave another comment and I will try to help more.
This video was SO helpful Shane, thanks so much. Looking forward to Part 2 *hint hint* ;)
Hi Meg. I need to revisit this video for sure. Hopefully one day sooner than later.
really need to know how to edit the items
@@clairehodgson4235 Part 3 of this series is the best I have on editing right now. th-cam.com/video/xgznk4XlPCo/w-d-xo.html
Is there a video that explains how you did the edit and delete line items on the collection items?
Try this video. Much deeper explanation of the concepts. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data th-cam.com/video/xgznk4XlPCo/w-d-xo.html of that doesn’t help make a new comment to ask again.
Hey! Can you somehow make sure, that the user can only add an item to the cart ones? If the same item is in the cart more than one time, the PATCH function will get confused. Hope you can help.
Set your function for adding to be an if. Have the if see if the item is already in the collection. Lookup is the key. 😀
Excellent video! I was wondering if you can share a video on how to add an actual image of the item hosted on a SPO list.
Maybe one day I will do that in a shopping cart part 2 😀
Very cool, Shane.. as always :)
Thanks
Glad to help. 😀
Where do we have to declare variables ItemType , ItemCost etc. they are not defined.
In PowerApps you never have to declare variables. I believe in this video though they were column names in a collection. :)
Your videos are amazing thank Shane , however every time that I click on shopping cart icon it adds a blank item to shopping cart
Check your collect function
Does any know how to subtract two columns in a Collection? It's funny that you can use the "Sum" function to both add and multiply, but I am not so lucky using it for subtraction.
Use AddColumns function to make your own column and then for the expression add the two columns. 😀
Hi, Shane can you maybe help on my text field on android I can use a . only allow me to use , on currency field android if I type 123.78 when I get to the . it just clear but when I use , it work the manipulation [$-enUS] that stuff and Substitute don't work please help. Sorry my English is not the best
Not sure. Haven’t seen that before 😑
Do you have a video about inventory management connected to orders? :)
I don’t. Use Patch to adjust the inventory items. I do have videos on that. th-cam.com/video/gX5q_V3U8-s/w-d-xo.html
Thank you very much for sharing your knowledge, this is a fantastic topic and helped me to understand how it works.
Cool
Is there a way to remove item in original share point once the collection is saved in shopping cart
Yes. Use the patch function to decrease the quantity in SharePoint
This is amazing video. Please share the link of video where edit pencil become cancl 28:04 you were showing us. thank you so much!
how can we update the remaining items once checkout from the main sharpoint list :D
In this video th-cam.com/video/HTY8AnMz5rw/w-d-xo.html I talk about Check in and out and show changing number of items in Inventory. So you could steal that concept and add it to this one.
FWIW - There is an even newer version of this shopping cart video th-cam.com/video/Ztn39KuOW0g/w-d-xo.html
Shane this is a great application. I started with your older version. I have been able to customize this for my specific application. I would like to add a search feature on the Supply list screen. How could i do that?
Did you see this video on Search? th-cam.com/video/lYi24okXDPs/w-d-xo.html Should give you some ideas.
Collections worked .. !!! I am fcking so suprised and so proud Microsoft!!!
Glad you got it.
You’re awesome man. Thank you for this video.
My pleasure!
What if I want a blue long-sleeve shirt :) Another good video from you. I am in the midst of writing a Power App that is using a number of SharePoint lookup columns that are giving me issues and fits and I have to find a work around for them. And using the RTF text boxes in Power Apps (editing) I wish did work too. Sadly not yet.
Yeah. Look up columns and PowerApps just are not BFFs. :) Do you have to have them? Could you rework your SharePoint data and maintain the connections with PowerApps instead?
I do use variables at times as a "work around". In my apps I do use the Office365Connection quite a bit and those lookups to the AD are a pain when trying to save back to a SP list. They are better now that Power Apps uses the "Choice" fields. On a separate topic, would you do a video covering Common Data Service and the big update coming to Power Apps using Model Driven apps versus using the Canvas?
Covering CDS is on my list for sure. :) Might be a few weeks, until after I go out to Redmond though. Fingers crossed.
You probably already know this but here is super simple way to get your images loaded automatically. Step 1 create a picture library. Step 2. Add a picture column to your t-shirts list in SP. Step 3. copy link from each image in the pic library and add it to the picture column in the t-shirt list. Now when you select "Image, title, and sub title" as your layout and then PowerApps does the rest.
Don't forget to refresh the data source if you added the picture column to the t-shirts list after the fact!
Thanks for sharing Michael
Hey Shane, I was wondering how I would make it so the cart is cleared upon submitting it.
Clear(CollectionName) will wipe it out.
Shane Young thank you that worked
I am building my first app and have found your videos to be extremely helpful! I can't find the video where you edited fields in the shopping cart. For some reason I can't get the field I'm using for Quantity (text input) to update with the new number entered. Help! Also, could you make a video on how to create a barcode scan so that when you scan one item three times it doesn't show as three items in the collection?
After I walked away from it for a while I was able to figure it out my update issue.
Glad you got it Amy 😻
real life case: what if i want to save my cart and next day i come again.. add few more stuff to my cart, deduct one or two previously selected items from cart and then place order? Plz do video on such too.
You need to save the items to a data source in a status of incart.
Would love to see the add-ons for this app in another video!
I do need to revisit this. 😑 On the list.
Shane Young haha no worries at all! Your videos are super helpful
How can I send a list with Word or Exel ?
Try this video to turn the collection into a table that you can put in the body of an email or a pdf. th-cam.com/video/AnERfGIE8gw/w-d-xo.html
@@ShanesCows thank you
great! so no success yet in writing the current user to the collection so that it is correctly patched back to sharepoint?
Was that a comment on a different video I forgot to reply to?
yes, sir, the video was "PowerApps Collection - Send emails, sum, and format"
Hi Shane, great tutorial videos! Where is the follow up video that explains how to add the functionality of changing the quantity of each item from the cart screen?
hello John. I am not sure I ever made that one. Email me with the part you are struggling with and I will try to help. Screenshots help. shane at powerapps.com
@@ShanesCows Hi Shane, I actually opted out with a OnChange and Patch function with a text input for the quantity on the carts screen. I appreciate your help, watching your Powerapps PDF generator video as we speak. Thanks a million!
Muy buen video me ayudo bastante, como podria guardar toda la coleccion de pedidos en la lista de SharePoint en una columna de varias lineas. para un solo pedido. y luego de haber guardado el pedido como poder cambiar los detalles del producto (por ejemplo la cantidad)
😎
How can we show the purchased item inside the cart?
Maybe a lookup?
@@ShanesCows thanks Shane
LookUp(ShoppingCart, OrderQuantity = Slider2.Value) use this Formula but not work can you help me to solve this problem
Can you send me helping video about Cart view
Shane Actually my question about cart icon i want cart icon show purchase quantity number . i am trying to use lookup function but not solve my problem.
Great Videos, Helped a lot to develop app. Thank you for your great support.
Glad you liked it.
could you please share me the next video link???
I still haven’t made that one. 😐 Boo me.
This was amazing! So now how do we surface this app to end users in a SharePoint site?
There is a web part for showing your app in modern pages
Great videos! But I'm having issues sending the shopping cart to my outlook email. Driving me insane.
I think this will help th-cam.com/video/AnERfGIE8gw/w-d-xo.html turn the data into a table
This was awesome
Thanks 😊
Hello Sir, wonderful Video one question how to the show cart quantity
Sum function
can you help in making a leave application app
You can contact us at www.PowerApps911.com for building your app.
Thanks, awesome🤩
You are awesome
how can store collection data into list ?
You can do Collect(SharePointList, CollectionName) for example.
Glad you found what you wanted and thank you for sharing.
Ufff & Uhhh, I made it. Fuck you Microsoft!
Thank you Shane :)! It was epic video! Everything worked and You explained all of this in pretty cool way. Everything is understandable. I really appreciate your help and the situation in which you spend your time to show us this functionality of PowerApps. Thank you very much for your help again!
Good luck in the future!
Thanks. Glad you got it all sorted. 😻
I am going to try this tomorrow. For sure smth won't fcking work because Microsoft changed anything for no fcking purpose. We will see .. tomorrow.
Hope it worked.
If I watch all your videos and leave a comment on each one, can I get a prize? 😬
Hope you enjoyed your run of videos Khar. I enjoyed all of the random comments. 🤪
So, let's get it started .. Let's see which thing of those powershitapps won't work properly cuz smth already changed there in this fcking Microsoft mind.