Тёмный
No video :(

New Version in description - PowerApps Shopping Cart 

Shane Young
Подписаться 164 тыс.
Просмотров 59 тыс.
50% 1

Опубликовано:

 

27 авг 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 223   
@ShanesCows
@ShanesCows 3 года назад
New 2021 Version of the Shopping Cart is available now ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ztn39KuOW0g.html
@alistairlong2424
@alistairlong2424 5 лет назад
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.
@ShanesCows
@ShanesCows 5 лет назад
Cool. Congrats
@26390
@26390 3 года назад
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!!!!!!
@ShanesCows
@ShanesCows 3 года назад
Nice! :)
@altino91255268
@altino91255268 3 года назад
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
@ShanesCows
@ShanesCows 3 года назад
This makes me happy. Thanks
@HeManojWorld
@HeManojWorld Месяц назад
Your videos are very helpful to me. Thank you Shane ! If you could provide us the data files, it would be great
@ShanesCows
@ShanesCows Месяц назад
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
@altino91255268
@altino91255268 3 года назад
I love these concepts !!! Microsoft should pay you for every video kkkk
@ShanesCows
@ShanesCows 3 года назад
Thanks 😊
@OutnProudover30
@OutnProudover30 5 лет назад
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!
@ShanesCows
@ShanesCows 5 лет назад
I honestly don't remember. :) Send me an email and I will see if I can find it for you. shane @powerapps911.com
@tonjewaasj8155
@tonjewaasj8155 6 лет назад
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 =)
@ShanesCows
@ShanesCows 6 лет назад
Awesome. :) Let me know how it goes.
@SawanKumar-tr9xz
@SawanKumar-tr9xz 3 года назад
Hi Shane... please make 2nd part of the video.
@ShanesCows
@ShanesCows 3 года назад
I need to. This video has been super popular the last month.
@catalogofhappiness
@catalogofhappiness 4 года назад
You are a legend ! Thanks for making it look so simple.
@ShanesCows
@ShanesCows 4 года назад
Happy to help 👍
@ConfidencePoint1
@ConfidencePoint1 3 года назад
Amazing video Shane. Please share the link of another video where you added edit functionality.
@ShanesCows
@ShanesCows 3 года назад
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
@michaelk1991
@michaelk1991 4 года назад
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.
@michaelk1991
@michaelk1991 4 года назад
Don't forget to refresh the data source if you added the picture column to the t-shirts list after the fact!
@ShanesCows
@ShanesCows 4 года назад
Thanks for sharing Michael
@UnkindledTarnishedMeg
@UnkindledTarnishedMeg 4 года назад
This video was SO helpful Shane, thanks so much. Looking forward to Part 2 *hint hint* ;)
@ShanesCows
@ShanesCows 4 года назад
Hi Meg. I need to revisit this video for sure. Hopefully one day sooner than later.
@clairehodgson4235
@clairehodgson4235 3 года назад
really need to know how to edit the items
@ShanesCows
@ShanesCows 3 года назад
@@clairehodgson4235 Part 3 of this series is the best I have on editing right now. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
@EatUpBros
@EatUpBros 5 лет назад
You are awesome Shane young .I love your videos Thank you so much....
@ShanesCows
@ShanesCows 5 лет назад
Glad to help. 😀
@ehabatme5324
@ehabatme5324 4 года назад
Appreciate all your materials.
@ShanesCows
@ShanesCows 4 года назад
Happy to help
@tonykuiper9127
@tonykuiper9127 3 года назад
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
@ShanesCows 3 года назад
Tony the series here shows exactly that. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
@tonykuiper9127
@tonykuiper9127 3 года назад
@@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.
@leonghz
@leonghz 3 года назад
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?
@ShanesCows
@ShanesCows 3 года назад
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.
@leonghz
@leonghz 3 года назад
Sure. Thanks so much.
@t0sma470
@t0sma470 4 года назад
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
@ShanesCows
@ShanesCows 4 года назад
Maybe try this video? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html
@leonghz
@leonghz 3 года назад
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
@ShanesCows
@ShanesCows 3 года назад
Do you have ThisItem.Field name? It just works for me in my demos.
@tonyz1616
@tonyz1616 4 года назад
Very cool, Shane.. as always :) Thanks
@ShanesCows
@ShanesCows 4 года назад
Glad to help. 😀
@facun_OK
@facun_OK 5 лет назад
Thank you very much for sharing your knowledge, this is a fantastic topic and helped me to understand how it works.
@ShanesCows
@ShanesCows 5 лет назад
Cool
@azamjamal6340
@azamjamal6340 5 лет назад
Would love to see the add-ons for this app in another video!
@ShanesCows
@ShanesCows 5 лет назад
I do need to revisit this. 😑 On the list.
@azamjamal6340
@azamjamal6340 5 лет назад
Shane Young haha no worries at all! Your videos are super helpful
@crimsonfox2398
@crimsonfox2398 3 года назад
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?
@ShanesCows
@ShanesCows 3 года назад
Look to combine ForAll and Patch to loop through the collection
@o0L337method0o
@o0L337method0o 3 года назад
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?
@ShanesCows
@ShanesCows 3 года назад
This series is this concept on steroids and will help with Edit. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
@o0L337method0o
@o0L337method0o 3 года назад
Beautiful. Thank you for the response, sir. I'll check it out!
@jhoncarlospenaarias9837
@jhoncarlospenaarias9837 3 года назад
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.
@ShanesCows
@ShanesCows 3 года назад
This video shows how to use ForAll to select records. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0xZ4fMJbLvk.html
@martijnquaedvlieg9828
@martijnquaedvlieg9828 4 года назад
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!
@ShanesCows
@ShanesCows 4 года назад
You cannot make PowerApps anonymous so I think that would stop you.
@jamesmccartney7707
@jamesmccartney7707 4 года назад
You’re awesome man. Thank you for this video.
@ShanesCows
@ShanesCows 4 года назад
My pleasure!
@clairehodgson4235
@clairehodgson4235 3 года назад
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>
@ShanesCows
@ShanesCows 3 года назад
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
@user-zv2zg3rr8q
@user-zv2zg3rr8q 4 года назад
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: )
@ShanesCows
@ShanesCows 4 года назад
Try this video on saving data ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html
@serafinprador.1009
@serafinprador.1009 4 года назад
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?
@ShanesCows
@ShanesCows 4 года назад
No. Each collection is for only the users session.
@NewPlayer4U
@NewPlayer4U 5 лет назад
Collections worked .. !!! I am fcking so suprised and so proud Microsoft!!!
@ShanesCows
@ShanesCows 5 лет назад
Glad you got it.
@scott8131
@scott8131 4 года назад
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
@ShanesCows
@ShanesCows 4 года назад
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.
@adriennemcgowan8242
@adriennemcgowan8242 4 года назад
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?
@ShanesCows
@ShanesCows 4 года назад
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
@adriennemcgowan8242
@adriennemcgowan8242 4 года назад
@@ShanesCows What would cause the Gallery.Selected to give an invalid formula error?
@adriennemcgowan8242
@adriennemcgowan8242 4 года назад
Disregard, starting over helps too
@moizahmed7593
@moizahmed7593 3 года назад
Where do we have to declare variables ItemType , ItemCost etc. they are not defined.
@ShanesCows
@ShanesCows 3 года назад
In PowerApps you never have to declare variables. I believe in this video though they were column names in a collection. :)
@ramakavitha
@ramakavitha 4 года назад
Can I know where the other video is with Edit and delete functionality in shopping cart please? great video. Thanks.
@ShanesCows
@ShanesCows 4 года назад
Sorry that one never got made. 😔 Check our repeating tables like infopath for some help that is like this.
@slomo9725
@slomo9725 4 года назад
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
@ShanesCows
@ShanesCows 4 года назад
Look for my video on ForAll to patch
@williepinaga7046
@williepinaga7046 4 года назад
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.
@ShanesCows
@ShanesCows 4 года назад
Maybe one day I will do that in a shopping cart part 2 😀
@tonykuiper9127
@tonykuiper9127 3 года назад
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
@ShanesCows 3 года назад
Did you see this video? If you hover over the column does it show ItemQTY or Date? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-mwXnJUkTug0.html
@tonykuiper9127
@tonykuiper9127 3 года назад
@@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)
@robbierbower8771
@robbierbower8771 3 года назад
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!
@keerthanasharmaa5922
@keerthanasharmaa5922 4 года назад
Hello Shane, awesome content. But the shopping cart doesn't show notification as to how many items are currently in the cart.
@ShanesCows
@ShanesCows 4 года назад
You can use CountRows to get the number of items in the collection
@lawrenceparker5045
@lawrenceparker5045 4 года назад
Excellent Video! How did you code the pencil icon to modify the shopping cart?!!
@ShanesCows
@ShanesCows 4 года назад
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.
@shreyasidutta7902
@shreyasidutta7902 4 года назад
Can this be done with Excel sheets? I could import all the data but I couldn't save the final name and cart total.
@ShanesCows
@ShanesCows 4 года назад
Patch to save data back to Excel. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html
@shreyasidutta7902
@shreyasidutta7902 4 года назад
@@ShanesCows Thanks a lot
@Xal18
@Xal18 4 года назад
Your videos are amazing thank Shane , however every time that I click on shopping cart icon it adds a blank item to shopping cart
@ShanesCows
@ShanesCows 4 года назад
Check your collect function
@ResponsibleXI
@ResponsibleXI 4 года назад
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?
@ShanesCows
@ShanesCows 4 года назад
Either should work. You would just need to use ForAll with Patch
@Vishalkumar-vj7hx
@Vishalkumar-vj7hx 11 месяцев назад
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!
@bwebmasta1
@bwebmasta1 4 года назад
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?
@ShanesCows
@ShanesCows 4 года назад
Look for my Video on Concat function
@bwebmasta1
@bwebmasta1 4 года назад
@@ShanesCows Thanks Shane! Checking it out.
@NewPlayer4U
@NewPlayer4U 5 лет назад
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!
@ShanesCows
@ShanesCows 5 лет назад
Thanks. Glad you got it all sorted. 😻
@TheShubham743
@TheShubham743 4 года назад
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
@ShanesCows
@ShanesCows 4 года назад
Yes, that should work if the column names match between the two.
@TheShubham743
@TheShubham743 4 года назад
@@ShanesCows i will try it
@TheShubham743
@TheShubham743 4 года назад
It is not working with excel 😭
@shreyasidutta7902
@shreyasidutta7902 4 года назад
@@TheShubham743 Same for me. Didn't work
@TheShubham743
@TheShubham743 4 года назад
@@ShanesCows i did it and it worked ....thanks shane
@reginaldoelgueta9061
@reginaldoelgueta9061 5 лет назад
Hi Shane excellent video, but I dontt understand a part, how you save the detail of the order in your sharepoint list
@ShanesCows
@ShanesCows 5 лет назад
Check out my video repeating tables like Infopath. It covers it better.
@debraspeed
@debraspeed 6 лет назад
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?
@ShanesCows
@ShanesCows 6 лет назад
Sendemail(....);Clear(ShoppingCart) should do it for you. Same as the delete button.
@tonykuiper9127
@tonykuiper9127 3 года назад
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?
@tonykuiper9127
@tonykuiper9127 3 года назад
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.
@ShanesCows
@ShanesCows 3 года назад
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
@schitti7031
@schitti7031 5 лет назад
Great Videos, Helped a lot to develop app. Thank you for your great support.
@ShanesCows
@ShanesCows 5 лет назад
Glad you liked it.
@charlessaffar3668
@charlessaffar3668 4 года назад
How should I go about creating + or - buttons for a quantity? Increments of 1. Thx
@ShanesCows
@ShanesCows 4 года назад
I haven’t done it but here is a way powerapps.microsoft.com/en-us/blog/powerapps-ten-reusable-components/
@The.truth..
@The.truth.. 4 года назад
This was awesome
@ShanesCows
@ShanesCows 4 года назад
Thanks 😊
@joeboskie
@joeboskie 4 года назад
Is there a way to remove item in original share point once the collection is saved in shopping cart
@ShanesCows
@ShanesCows 4 года назад
Yes. Use the patch function to decrease the quantity in SharePoint
@danielbell9192
@danielbell9192 5 лет назад
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!
@ShanesCows
@ShanesCows 5 лет назад
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.
@bellstudiostesting3261
@bellstudiostesting3261 4 года назад
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, "; "),
@bellstudiostesting3261
@bellstudiostesting3261 4 года назад
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)
@YoshisBigAdventurenz
@YoshisBigAdventurenz 4 года назад
Hi Shane, Where can I find the video on how to Edit and delete functionality in shopping cart please?
@ShanesCows
@ShanesCows 4 года назад
I still haven't made that. Closest I have is this series ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-xgznk4XlPCo.html
@hitasajil3869
@hitasajil3869 5 лет назад
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.
@ShanesCows
@ShanesCows 5 лет назад
You need to save the items to a data source in a status of incart.
@marciokataoka
@marciokataoka 5 лет назад
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?
@ShanesCows
@ShanesCows 5 лет назад
I don’t. Did you publish the app?
@jrpvenous
@jrpvenous 5 лет назад
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
@ShanesCows 5 лет назад
Yikes. I have never tried to make new lists. Maybe with the Graph api you could but not really sure.
@jrpvenous
@jrpvenous 5 лет назад
Shane Young Understood. I will see intro it. Thank you
@jrpvenous
@jrpvenous 5 лет назад
@@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?
@jrpvenous
@jrpvenous 5 лет назад
@@ShanesCows I mean there has to be a way to see the collection from power apps within sharepoint right?
@darraghcunnane2576
@darraghcunnane2576 5 лет назад
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
@ShanesCows
@ShanesCows 5 лет назад
I replied on Twitter
@guyinazo
@guyinazo 6 лет назад
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.
@ShanesCows
@ShanesCows 6 лет назад
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?
@guyinazo
@guyinazo 6 лет назад
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?
@ShanesCows
@ShanesCows 6 лет назад
Covering CDS is on my list for sure. :) Might be a few weeks, until after I go out to Redmond though. Fingers crossed.
@johnmizell4683
@johnmizell4683 5 лет назад
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?
@ShanesCows
@ShanesCows 5 лет назад
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
@johnmizell4683
@johnmizell4683 5 лет назад
@@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!
@alistairlong2424
@alistairlong2424 5 лет назад
Is there a video that explains how you did the edit and delete line items on the collection items?
@ShanesCows
@ShanesCows 5 лет назад
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.
@lukelacefield8234
@lukelacefield8234 5 лет назад
Hey Shane, where is the link to the video of the more in-depth PowerApp you created that is mentioned 27:37?
@ShanesCows
@ShanesCows 5 лет назад
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. :)
@lukelacefield8234
@lukelacefield8234 5 лет назад
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!
@jamelstringer6734
@jamelstringer6734 5 лет назад
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.
@ShanesCows
@ShanesCows 5 лет назад
Use AddColumns function to make your own column and then for the expression add the two columns. 😀
@edgardevidsanchezamaya3674
@edgardevidsanchezamaya3674 4 года назад
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)
@ShanesCows
@ShanesCows 4 года назад
😎
@joan322
@joan322 4 года назад
Do you have a video about inventory management connected to orders? :)
@ShanesCows
@ShanesCows 4 года назад
I don’t. Use Patch to adjust the inventory items. I do have videos on that. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gX5q_V3U8-s.html
@michaelk1991
@michaelk1991 4 года назад
This was amazing! So now how do we surface this app to end users in a SharePoint site?
@ShanesCows
@ShanesCows 4 года назад
There is a web part for showing your app in modern pages
@oliverfuglsang2355
@oliverfuglsang2355 6 лет назад
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.
@ShanesCows
@ShanesCows 6 лет назад
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. 😀
@cecilieseberg5067
@cecilieseberg5067 5 лет назад
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?
@ShanesCows
@ShanesCows 5 лет назад
You need to use ForAll to Patch your collection back.
@DJJohn6935
@DJJohn6935 5 лет назад
I used a concatenate of the collection to have all details summarized in a text box: Concat(Carrito;Cliente& " " & Pais& " " & Sede; "/// ")
@imranfc
@imranfc 4 года назад
Hello Sir, wonderful Video one question how to the show cart quantity
@ShanesCows
@ShanesCows 4 года назад
Sum function
@HerbertAlston
@HerbertAlston Год назад
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?
@ShanesCows
@ShanesCows Год назад
Did you see this video on Search? ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lYi24okXDPs.html Should give you some ideas.
@noksa8453
@noksa8453 4 года назад
could you please share me the next video link???
@ShanesCows
@ShanesCows 4 года назад
I still haven’t made that one. 😐 Boo me.
@siegmundpanitz4991
@siegmundpanitz4991 4 года назад
How can I send a list with Word or Exel ?
@ShanesCows
@ShanesCows 4 года назад
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
@siegmundpanitz4991
@siegmundpanitz4991 4 года назад
@@ShanesCows thank you
@gatskopsoftware8357
@gatskopsoftware8357 5 лет назад
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
@ShanesCows
@ShanesCows 5 лет назад
Not sure. Haven’t seen that before 😑
@mblherry
@mblherry 6 лет назад
Hey, Shane. What about the Order Details - How are they written back to SharePoint?
@ShanesCows
@ShanesCows 6 лет назад
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?
@ShanesCows
@ShanesCows 6 лет назад
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?
@mblherry
@mblherry 6 лет назад
Would PowerApps know to write multiple records?
@ShanesCows
@ShanesCows 6 лет назад
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.
@cesaritriago7038
@cesaritriago7038 6 лет назад
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 ;)
@charlesmchenry1146
@charlesmchenry1146 4 года назад
Great videos! But I'm having issues sending the shopping cart to my outlook email. Driving me insane.
@ShanesCows
@ShanesCows 4 года назад
I think this will help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AnERfGIE8gw.html turn the data into a table
@imranfc
@imranfc 4 года назад
How can we show the purchased item inside the cart?
@ShanesCows
@ShanesCows 4 года назад
Maybe a lookup?
@imranfc
@imranfc 4 года назад
@@ShanesCows thanks Shane
@imranfc
@imranfc 4 года назад
LookUp(ShoppingCart, OrderQuantity = Slider2.Value) use this Formula but not work can you help me to solve this problem
@imranfc
@imranfc 4 года назад
Can you send me helping video about Cart view
@imranfc
@imranfc 4 года назад
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.
@amycarl9165
@amycarl9165 4 года назад
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?
@amycarl9165
@amycarl9165 4 года назад
After I walked away from it for a while I was able to figure it out my update issue.
@ShanesCows
@ShanesCows 4 года назад
Glad you got it Amy 😻
@kevinschick9735
@kevinschick9735 6 лет назад
Hey Shane, I was wondering how I would make it so the cart is cleared upon submitting it.
@ShanesCows
@ShanesCows 6 лет назад
Clear(CollectionName) will wipe it out.
@kevinschick9735
@kevinschick9735 6 лет назад
Shane Young thank you that worked
@chelseaacosta4259
@chelseaacosta4259 4 года назад
Thanks, awesome🤩
@ShanesCows
@ShanesCows 4 года назад
You are awesome
@gerusnero
@gerusnero 6 лет назад
great! so no success yet in writing the current user to the collection so that it is correctly patched back to sharepoint?
@ShanesCows
@ShanesCows 6 лет назад
Was that a comment on a different video I forgot to reply to?
@gerusnero
@gerusnero 6 лет назад
yes, sir, the video was "PowerApps Collection - Send emails, sum, and format"
@TheShubham743
@TheShubham743 4 года назад
can you help in making a leave application app
@ShanesCows
@ShanesCows 4 года назад
You can contact us at www.PowerApps911.com for building your app.
@muhammadsamiullahsiddiqui5241
@muhammadsamiullahsiddiqui5241 6 лет назад
how can store collection data into list ?
@ShanesCows
@ShanesCows 6 лет назад
You can do Collect(SharePointList, CollectionName) for example.
@ShanesCows
@ShanesCows 6 лет назад
Glad you found what you wanted and thank you for sharing.
@NewPlayer4U
@NewPlayer4U 5 лет назад
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.
@ShanesCows
@ShanesCows 5 лет назад
Hope it worked.
@khargos7602
@khargos7602 2 года назад
If I watch all your videos and leave a comment on each one, can I get a prize? 😬
@ShanesCows
@ShanesCows 2 года назад
Hope you enjoyed your run of videos Khar. I enjoyed all of the random comments. 🤪
@NewPlayer4U
@NewPlayer4U 5 лет назад
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.
Далее
PowerApps Timer Control
15:27
Просмотров 90 тыс.
Power Apps Shopping Cart new for 2021
41:28
Просмотров 95 тыс.
Cute kitty gadgets 💛
00:24
Просмотров 15 млн
나랑 아빠가 아이스크림 먹을 때
00:15
Просмотров 1,9 млн
Developing Microsoft PowerApps - Exporting to PDF
33:47
PowerApps Patch Function
26:45
Просмотров 212 тыс.
PowerApps Password Screen
16:41
Просмотров 62 тыс.
Intro to PowerApps Variables
19:23
Просмотров 204 тыс.
Shopping Cart in PowerApps
18:42
Просмотров 44 тыс.
PowerApps Collection - Send emails, sum, and format
21:53
Cute kitty gadgets 💛
00:24
Просмотров 15 млн