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
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ztn39KuOW0g.html
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!
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
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.
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.
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html It talks about relationships and I think will help.
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
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 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?
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, 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.
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!
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? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
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?
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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html If not feel free to leave another comment and I will try to help more.
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html I hope it helps
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
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)
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!
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.
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?
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?
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!
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... 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. 😀 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-8eoaSsXnh6Q.html
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 ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.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, "; "),
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 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?
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?
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
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?
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!
Try this video. Much deeper explanation of the concepts. PowerApps Repeating Tables like InfoPath Part 1 - Enter the data ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html of that doesn’t help make a new comment to ask again.
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!
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.
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)
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.
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?
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?
Try this video to turn the collection into a table that you can put in the body of an email or a pdf. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AnERfGIE8gw.html
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
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 ;)
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.
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?
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.