Thanks for the huge video library on PowerApps. I keep going back to it when I get stuck on a problem. Your work is extremely valuable!
@ShanesCows
3 жыл бұрын
Glad you like them!
@EricaShapland
3 жыл бұрын
You are my hero! "Save - Hard Way" is exactly what I've been looking for to make my complicated, batch upsert work.
@ShanesCows
3 жыл бұрын
Great to hear!
@forgotrafe
4 жыл бұрын
Watching a whole bunch of your videos and they’re really good. As a very experienced developer they’re a little slow, but I think you’ve got the balance perfect for people like me and newbies. Thank you.
@ShanesCows
4 жыл бұрын
Thanks. A lot of different levels watch so I try to find that balance.
@OOAK-Ireland
Жыл бұрын
agree with you totally. they are sometimes too slow. 9 minutes before we get to the actual coding... but you do know your stuff.
@bettingru
5 жыл бұрын
Extremely happy to have Finally found your "PowerApps Save Data - Patch, Collect, and ForAll" video. Took 4 days to find it however, because it was never matched with my google searches, which included [how to copy a record to another data source], [update a SharePoint list from selected gallery], [copy selected record to a SharePoint list], Etc.
@ShanesCows
5 жыл бұрын
Thanks I added one of the tags.
@s.andres3744
5 жыл бұрын
Best Video of all!... I spent a entire day trying what you've got solve in 5 minutes. Thanks a lot!
@ShanesCows
5 жыл бұрын
Awesome
@ezeononuju2714
3 жыл бұрын
@@ShanesCows Thank you for these amazing videos, one button I didn't quite catch was the button at the top right corner you click to create additional forms which you then add to the collection
@jonathanchen6652
4 жыл бұрын
Watching this now. Halloween 2019!!! Love the energy.
@ShanesCows
4 жыл бұрын
Thanks. I had Halloween stuff in my video today
@ondrejtomiska8738
2 жыл бұрын
Little whacky but man did this help me with my project. Great work. Straight to the point.
@ShanesCows
2 жыл бұрын
Thank you :)
@vijaysavarimuthu
2 жыл бұрын
Hi Shane, One of the best tutorial video for Powerapps
@ShanesCows
2 жыл бұрын
Thank you Vijay. 🥰 I have about 250 videos on the same at this point. I hope you subscribe and enjoy.
@fklatecki
5 жыл бұрын
Timely video...just the last step I need, in a complex app I have been working on! Ahhh, the clarity of knowledge. Thank you Shane for lifting the veil for me.
@ShanesCows
5 жыл бұрын
Great!
@LaurenceBoulter
4 жыл бұрын
A genuinely really useful video. Brilliant. Got me out of a hole this week. One useful tip to add, when constructing a long patch statement the field name and destination list field name can be cut and pasted from the card's advanced properties.... might want unlocking first though! Thanks Shane, you are well and truly my number 1 place to go for PowerApps info.
@ShanesCows
4 жыл бұрын
Awesome 😎
@at3941
4 ай бұрын
I really appreciate your videos I’ve learned a lot from them. Thanks
@ShanesCows
4 ай бұрын
Glad to hear it!
@hiteshkumar797
2 жыл бұрын
Thankyou Shane... I am a fresher and new to this field... Your videos really help me a lot.. Thankyou once again
@ShanesCows
2 жыл бұрын
You're so welcome!
@kamozzi1
2 жыл бұрын
Great video Shane. This is what I’m looking for the app in working on. Just loved it 👍👍👍👍 life saver.
@ShanesCows
2 жыл бұрын
Awesomeness
@majahbrooks8158
2 жыл бұрын
Awwwww! I love how you said you respond to every comment and that "we are worth it", you're awesome! Thank you! Loving your stuff and am excited to have subscribed! Looking forward to watching more! I'm addicted now
@ShanesCows
2 жыл бұрын
🐶 Truth be told I don’t get all of the comments any more. Boo! But I try like heck. 😎
@Amr-Ibrahim-AI
4 жыл бұрын
Thank you Shane for your very helpful videos. I learn something new each time I watch one of your videos. Please keep it up.
@ShanesCows
4 жыл бұрын
Glad to help. 😀
@SundayOgali
2 жыл бұрын
Thanks Shane. This video really helped me complete my app.
@ShanesCows
2 жыл бұрын
You're welcome!
@vutanphuoc6325
2 жыл бұрын
You shared your knowledge and also experiences, thank you much for your kind sharing.
@deepanshsaxena5677
4 жыл бұрын
How to use ForAll and Patch together to update existing record in my data source: ForAll(ChangeAssignmentOrStatus, Patch(MemoEDI, LookUp(MemoEDI, ID=ChangeAssignmentOrStatus.ID, ID), {CurStatus: Dropdown1.SelectedText.Value})) This is not fetching the record. Thank You. Got the answer, I have to use {ID: ID} :) Thanks Shane, I love your way of approach to problems.
@shanc77
5 жыл бұрын
Man, your videos have helped me so much in the last month! Thank you so much.
@ShanesCows
5 жыл бұрын
Awesome
@toanuk
5 жыл бұрын
HI Shane. One of the best idea to do this genius frame work. Fully understand Patch, Collect and ForAll Functions in the Columns of its functions. You are the best Teacher, Thump UP>>>>
@ShanesCows
5 жыл бұрын
Thanks
@roshmisengupta7182
5 жыл бұрын
This is the most useful video I found for patching
@ShanesCows
5 жыл бұрын
Thanks. Good to know this one is helpful. :)
@ashokpershad
5 жыл бұрын
Appreciate your time and effort for making these amazing videos..
@ShanesCows
5 жыл бұрын
You are welcome
@xMikeDx
Жыл бұрын
these are still going strong and how timely as well being a Halloween from the future.
@ShanesCows
Жыл бұрын
I loved this video. 🎃
@iiii05
3 жыл бұрын
Dude you are awesome! Really enjoyed this video. Explained it very well and very charismatic. Thanks.
@ShanesCows
3 жыл бұрын
Thanks Ian. 🐶
@the_n8
4 жыл бұрын
Great Video! Very thorough and helpful for different scenarios
@ShanesCows
4 жыл бұрын
Glad you enjoyed it!
@alangustavo8249
3 жыл бұрын
Shane, thank you so much for sharing your knowledge! Helped me a lot!
@ShanesCows
3 жыл бұрын
Awesome 😎
@MSandovalPhD
4 жыл бұрын
Thanks for sharing this with the community. Power apps brings me bad memories from Infopath, and apparently, it's the same idea to reduce coding but "improved".
@ShanesCows
4 жыл бұрын
So much better than infopath 😎
@redefinelife2720
3 жыл бұрын
HI Shane, your learning videos are really helpful
@ShanesCows
3 жыл бұрын
😎🐶 Awesome
@alexandrunegoita7534
4 жыл бұрын
Very well explained and detailed. Helped greatly with my project. Thanks!
@ShanesCows
4 жыл бұрын
Glad it helped!
@melissaedwards6225
4 жыл бұрын
Great video, just learning PowerApps. Trying to collect static data from an excel table (model, part type) using drop downs and write the selected items along with other data input by users to a Sharepoint list. Having issues making it work. Probably easier ways to do still learning. Will try something’s I learned here. Thanks for doing these.
@ShanesCows
4 жыл бұрын
Glad to help Melissa.
@br31woodlands69
4 жыл бұрын
Love your energy Shane!
@ShanesCows
4 жыл бұрын
Thanks 😊
@ShashiBhushanSaurabh
4 жыл бұрын
Thanks Shane!!! You are my savior!!
@ShanesCows
4 жыл бұрын
Glad to help. 😀
@bolopez9642
5 жыл бұрын
OMG a video for exactly what I want to do! Track my halloween candy.. All jokes aside, Great video! I learned powerapps through watching your videos and have started creating some for my Org. Keep up the good work.
@ShanesCows
5 жыл бұрын
Candy is important. 😝 Glad they are helping.
@lukaskuemmerle650
3 жыл бұрын
Shane you´re just great!
@ShanesCows
3 жыл бұрын
Thanks Lukas, you are too kind.
@SandeepSingh-lg7bq
4 жыл бұрын
Thanks Shane for this wonderful tutorial.
@ShanesCows
4 жыл бұрын
Glad to help. 😀
@j_ltz_
3 жыл бұрын
t-rex lookin real fly, shane
@ShanesCows
3 жыл бұрын
Thanks 🐱🐉
@andressebastianmontalvosua8193
4 жыл бұрын
Love it Shane! haha informative and fun. Good job mate!
@ShanesCows
4 жыл бұрын
Thanks 😊
@rengiesbrecht6670
4 жыл бұрын
Thanks Shane, your videos are really helpful!
@ShanesCows
4 жыл бұрын
Glad to help. 😀
@UCanDoIt2Mike
4 жыл бұрын
Thanks for all the great videos!! A couple of questions. (1) When recording field data (assume no Internet), it appears that I would want to store that data into a collection, then later push to SharePoint. Is there any issue with losing the data in the Collection prior to being able to push it to SharePoint (closing the app, or other action?). (2) If multiple people are using the App, are their Collections separate, or are they creating records in the same Collection? Recent Subscriber... your organization of the information you teach is golden! Mike
@ShanesCows
4 жыл бұрын
Try this video kzitem.info/news/bejne/r62Y15h3cpxpeKA
@SITG2023
3 жыл бұрын
Great explanation
@ShanesCows
3 жыл бұрын
Thanks 😊
@petcharatsangkamkad6798
11 ай бұрын
Very very very good vdo It effectable, can apply to my work
@ShanesCows
11 ай бұрын
Awesome. Happy to help!
@mrpappagone
2 жыл бұрын
nice what I needed - thanks
@ShanesCows
2 жыл бұрын
Awesome 😎
@treybrewington3286
4 жыл бұрын
Hey Shane, I have been creating this app to order inventory on and all you do is go down the list, enter quantities and then the store number and hit the restock button and they send to a share point. I am having troubles with my formulas. When you hit the restock button it sends only 1 of the products 2 times. Lets say I ordered cat and dog food from the app, only the dog food shows up in the share point 2 separate times when the cat food and dog food should both show up. My formulas are 'PowerApp->Createitem'.Run(Title1.Text,Subtitle1.Text,TextInput6.Text,TextInput1.Text,DatePicker1.SelectedDate); ClearCollect(ColInventory,{Title:Title1.Text,Skuu:Subtitle1.Text,StoreNum:TextInput6.Text,Quan:Value(TextInput1.Text),Datee:DatePicker1.SelectedDate}); ForAll(ColInventory, If(!IsBlank(ColInventory[@Quan]), Patch('Inventory by apps',Defaults('Inventory by apps'), {Product:ColInventory[@Title], 'Sku #''s':ColInventory[@Skuu], 'Store Number':ColInventory[@StoreNum], Quantity:ColInventory[@Quan], Date:ColInventory[@Datee]}))) Thank you
@ShanesCows
4 жыл бұрын
Try simplfing the ForAll patch(datasource, defaults(datasource), {datasource column: Title}) and what does the flow do?
@DraaElMizan
5 жыл бұрын
Thanks Shane, You've been great help.
@ShanesCows
5 жыл бұрын
😀
@dineshtalekar8980
3 жыл бұрын
He Shane the way you teach is really awesome. I learned a lot of things from you in power apps. Can you please make video on creating the custom component (Callout in SharePoint) like callouts in sharepoint and the input to the custom component should be and html string so that I can have formattings like text bold and color those should be visible in callout
@ShanesCows
3 жыл бұрын
I have never done that before. Sorry but sounds cool
@dineshtalekar8980
3 жыл бұрын
@@ShanesCows Thanks for quick response can you please try and create one video on this that will be great
@manjeetsinghutube
2 жыл бұрын
This is fantastic video thanks
@Shellbell292
10 ай бұрын
Hi Shane, On the formula for Save - Hard Way, where would you the Lookup function to ensure the collection updates and existing item?
@vinylmike
2 жыл бұрын
You rock man! 🤘
@ShanesCows
2 жыл бұрын
Thanks Mike!
@yaynative
10 ай бұрын
You can use Collect to patch? Mind blown 🤯
@ShanesCows
10 ай бұрын
Do you want to melt further? Check out this one that talks about Performance of the moving pieces. kzitem.info/news/bejne/z6Gmn4Goe3p_YKg 😳
@ambujaable
5 жыл бұрын
Great ! Thanks for your efforts!
@ShanesCows
5 жыл бұрын
You are welcome 😀
@michelleklonicke1456
4 жыл бұрын
I have a SharePoint list that is set up to receive the information from a collection but when I start the Patch( it only shows the list in single quotes. I've tried with other SharePoint lists and they look like the Easy Way - I will take ANY way at this point to somehow get rid of the single quotes. I learn new things every time I watch a video and built up skills all from your videos~!
@ShanesCows
4 жыл бұрын
Single quotes is because you have spaces in your names.
@jamelstringer6734
5 жыл бұрын
FYI, You cannot reset controls that are within a Gallery or Edit form control from outside those controls. You can reset controls from formulas on controls within the same gallery or form.
@ShanesCows
5 жыл бұрын
True. Good reminder.
@labahlabahoren
3 жыл бұрын
Patch with Default() is for new record, i.e. new row of items.
@ShanesCows
3 жыл бұрын
😎 you got it
@heloisaheng3189
3 жыл бұрын
Thank you so much Shane, i really need your 911. I have question, as a beginner : If the user always need to complete the 80% of the form at screen A, save it, and later open it and proceed to fill up another 20% of the form at screen B then only submit, may i know in this case should i use Collection or Set? I want to also insert a preview page of the 80% completed form (view mode, with button to choose save or go right to screen B to complete), how to make that preview page that display the data just put in?
@ShanesCows
3 жыл бұрын
That is a complicated question for a beginner. I don't have a video on it but will add it to my list.
@TheNilyog
3 жыл бұрын
This is really good article but i am trying to create a collection and add collection data in sp list on single button click is that possible submit button? i have use sepecial combobox and toggel control which are not a part of datacard or gallery. your help much helpful. Thank you.
@ShanesCows
3 жыл бұрын
Collect(YourCollection, {TimeColumnInCollection: Now()});Patch(SharePointLists, Defaults(SharePointLists), {TimeColumn: Now()}) Something like that should give you ideas.
@virginiaashley1838
5 жыл бұрын
Great work this was really helpful. I'm considering your online courses after this:)
@ShanesCows
5 жыл бұрын
Thanks. Would be happy to have you. We have a full load for this week's class but we should have another offering end of Feb. You can email me shane @powerapss91.com for more info or use the code "Chewy on KZitem" for 10% off www.powerapps911.com/training
@ElRogerJugadorMaster
2 ай бұрын
I'm creating a Todo app, but how can I save the Date, when the user clicks the check box?
@user-em3li8wq7y
4 жыл бұрын
Hi I have a questions about save data! 1. Can you save date in excel? And how? 2. If you save data using collection does the list resets after you trun off the app?
@ShanesCows
4 жыл бұрын
Yes an Excel hosted on OneDrive can be a datasource. kzitem.info/news/bejne/jpCVl2eAaWSDg4o Yes collections are temporary kzitem.info/news/bejne/2ols04iIpZ-mn6g
@chrischris711
5 ай бұрын
Helpful video ! A + + + +
@ShanesCows
5 ай бұрын
Glad to hear that!
@sacwgar
5 жыл бұрын
Hi Shane, thank you for taking the time to create these videos, they have been a tremendous help. I have built this flow and even modified the OnSelect option to work with a collection. The problem I am running in to is I need the Create File action to also create a new folder and name it using user input in the form. The collection would then be saved in the newly created folder. Any help is greatly appreciated. Thanks!!
@ShanesCows
5 жыл бұрын
Just add the folder name input to the path in Flow. It will automatically create the folder.
@sacwgar
5 жыл бұрын
It should be that easy, but unfortunately it is not...maybe I am doing something incorrectly. When I select add dynamic content, none of the fields from my PowerApps form appear. What am I missing? Thanks!
@ShanesCows
5 жыл бұрын
Did you tell your Flow to ask in PowerApps?
@sacwgar
5 жыл бұрын
When I select ask in PowerApps I get CreateFile_Folder.... "trggerBody()['Create_FolerPath_1']" If I test the flow it fails and says the template language expression 'triggerBody()['Createfile_FolderPath_1']' cannot be evaluated because property 'Createfile_FolderPath_1' doesn't exist.
@ShanesCows
5 жыл бұрын
After you ask in PowerApps did you update you PowerApps button to send the content?
@guggilamdivyasai3451
2 жыл бұрын
Instead of using patch, can't we update a column value in new form while submitting form to SharePoint list?
@marcelomoreira9620
3 жыл бұрын
Looks like new version of PowerApp doesn´t take Selected.Value. What would be the alternative?
@ShanesCows
3 жыл бұрын
Selected.YourColumnName type Selected. And Power Apps will show you the available fields.
@aboubakr1993
3 жыл бұрын
Excellent
@ShanesCows
3 жыл бұрын
Thanks 😊
@salmanb3655
Жыл бұрын
By using Patch function whether it could be possible to save a data in sharepoint list without making a new column...?
@matthiasvancampen3770
5 жыл бұрын
Is there a best choice for speed (e.g. when writing multiple records to excel)? Or do all functions need the same time per record to be stored?
@ShanesCows
5 жыл бұрын
I would say all the same
@hexipo2352
Жыл бұрын
Hi Shane, Really appreciate you vids! Is there a way to patch a collection with all the collected results being concatenated into one column to sharepoint?
@ShanesCows
Жыл бұрын
You could use Concat function to turn your table data into a string of data and then write that string to a single column. kzitem.info/news/bejne/oqR7uJp9gndpmqw not exact but will help you with the function.
@hexipo2352
Жыл бұрын
@@ShanesCows thanks Shane. Really appreciated. My own research wasn’t turning up much results!
@richardclowes6166
4 жыл бұрын
as usual a brilliant video... can you answer one fundamental thing please... At 12:59 of the video you have the patch for the various columns... and you do.... Title: TextInput1.Text (I get) TypeofItem: Dropdown1.Selected.Value (why not text? - when do you text here vs. value) CandyQty: Slider.Value (the value makes sense to me because the field is a numeric...but the typeofitem is a text field in your SP List). Can you just explain .text vs. .value...
@ShanesCows
4 жыл бұрын
Hey Richard. Dropdown.Selected. Your column name is what you are after. In this case Value was the name of the column. You never use SelectedText. I wish they would remove it from the product.
@simondu8520
4 жыл бұрын
how to use incremental date in the forall loop? (like to patch just the date based on the number of days input), your help is much appreciated.
@ShanesCows
4 жыл бұрын
You can use DateAdd function to add dates. kzitem.info/news/bejne/ppiPs4JqqKeAqYY
@kyawzinlatt3712
4 жыл бұрын
How to prevent data loss from using ForAll and Patch? Because I have been experiencing this problem in my app Depends on the Internet connection it just perform partially
@ShanesCows
4 жыл бұрын
I would do the ForAll then do a filter of the data source to make sure all of the data got created before deleting the collection.
@user-xi4zq6vv5c
Жыл бұрын
Hey Shane, your videos are awesome! Thanks so much!! Just wondering if you have a video showing the patching of 3 pieces of information from a qr barcode scan back to 3 separate columns in sharepoint? It would be super helpful!
@kanishkaroychowdhury4050
4 жыл бұрын
great one
@ShanesCows
4 жыл бұрын
Thanks 🙏
@alejandrolazo3766
2 жыл бұрын
Hello Shane. Thank you very much for those wonderful videos. I have a question. I have a small app for package delivery internal on my company. I have a form where I enter User info and Package info. When the package is being delivered to the recipient I have a "Deliver Yes or NO toggle button" just to confirm that package has been delivered to the recipient ON the Detail Form Screen. My question is, can I save the Yes Or no Value to my Sharepoint List. Is Patch necessary Or I can use Submit Form? thank You very much.
@ShanesCows
2 жыл бұрын
Patch or form will work. SharePoint has a yes no column I would store the value in. Shouldn’t be different than other fields.
@subhraghosh8434
3 жыл бұрын
In customizing forms cant I use patch function to update records ?? in app it is working properly
@shalinideshpande2024
4 жыл бұрын
can the user who doesn't have write access to sharepoint still add the record using the form? I don't want a user to directly go to sharepoint and add new record manually
@ShanesCows
4 жыл бұрын
Nope. They have to have permissions to SharePoint to write to it.
@kathlynmercado5604
3 жыл бұрын
Hi Shane, once the data is save, how to view it on same way it will open like a form?
@ShanesCows
3 жыл бұрын
Use the LookUp function to get the record and save it to a variable. The you can use the variable.columnname to show the various fields.
@gangadharambati6507
Жыл бұрын
Hi Shane, Thank you very much for your Vedios.. I have a question for you..Can you write back content from Poweapps into SAP HANA database? Please tell me..
@pankajdubey2650
4 жыл бұрын
Hi Shane, i have some question on Power Apps search record history. Just wanted to know if 5 people have selected multiple drop down as per there requirement and being as a owner i want to know that all 5 people what kind of selection they have used so for that case where i can go and see saved selection history of all five people ? Looking forward for your valuable response. Thanks in advance.
@ShanesCows
4 жыл бұрын
You have to save their response to a data source.
@vaibhavsingh461
2 жыл бұрын
You are awesome
@ShanesCows
2 жыл бұрын
Thanks! 🐶
@jenfrie7043
2 жыл бұрын
Hey Shane, I just found your video an Channel and I would like to say THANK YOU. I am totally new to PowerApps I have no idea what I am doing but I agreed to help my boyfriend to create a simple tracking app for his employees :D Your vidoe helps a lot with this. But I got one question: Your Data Source is a Sharepoint list. Is it possible that the sharepoint list is an excel sheet? Because we have to send the lists with each persons working hours to our tax consultant every month. Isn´t it a bit complicated with a sharepoint list?
@ShanesCows
2 жыл бұрын
Hi Jen - Excel is possible but not ideal. Instead what you might want to do is learn how to make a Power Automate flow that runs once a month, grabs all of the hours, and then puts them in a CSV file, which opens in Excel. You can get an idea of how that would work here kzitem.info/news/bejne/yqOe3q1pi3eYi5g
@WhatIsThis.WhyDoINeedIt
3 жыл бұрын
I need help! I have made a powerapp with various toggles and radio buttons and it is standalone, it's not liked to a dataset. But I need to be able to save and load the selections when the app is closed and reopened. Any ideas?
@ShanesCows
3 жыл бұрын
YOu would need to save the information to a data source. YOu can likely use OneDrive Excel file or a SharePoint list without any additional licenses.
@QQ_HH
3 жыл бұрын
Love your video. I found many videos, but cannot find one exactly like my example. I am creating a form in Powerapp, the form will look like a Word document, with data input fields in between, with no data card in the content. The content looks like a letter. After submit, the input filed values will be save to Sharepoint list, do you have any video showing such scenario? Thanks a lot
@ShanesCows
3 жыл бұрын
I don't. SOrry. But it is possible.
@learningtechs1267
4 жыл бұрын
Hi Shane, Your videos are Awesome!! Can you please show how can we patch Lookup column data into CDS Entities
@ShanesCows
4 жыл бұрын
One of these days I will get to CDS. One day. Sigh. I need to hurry up.
@traceyhemley6160
3 жыл бұрын
Shane, how do you add a Note to a Parent table that has related Notes? I just can't find any documentation on how to use just the Notes (not attachements) - Parent/Child relationships in Dataverse.
@ShanesCows
3 жыл бұрын
Hey Tracey I haven't worked with Notes in Dataverse so not sure. 😑
@traceyhemley6160
3 жыл бұрын
@@ShanesCows it's pretty awesome that Dataverse allows any table to have a relationship (one-to-many) with Notes, so one can add as many notes to a table record. And it prevents our core tables from bulking out in size. So the code I finally found was: Patch( Notes, Defaults(Notes), { notetext: richtextNote.HtmlText, _objectid_value: First(colSurveyDetail), /*
@RaviChauhan-un6bb
4 жыл бұрын
Hi, I have been running into a problem with exporting data to SQL. I'm Importing data to a scroll bar from one SQL table, And exporting it to another. After I successfully export, I go to my SQL Table and execute the query to refresh it. The problem is, even though I've entered data to the scroll bars, some fields display as NULL. The fields which are text or numbers show quite right, only the scroll bars result in this issue. Help will be much appreciated. Thanks
@ShanesCows
4 жыл бұрын
Not sure. Sorry 😐
@Ter1x
2 жыл бұрын
Hey Shane, Is it possible to save all the elements of the collection, provided that each element of the collection contains a collection of photos?I can't do this (
@sunatohhogaabdekhobhi640
4 жыл бұрын
Hello Shane, Is there any connector or API that can be used to display the device's internet speed on the PowerApp apps?
@ShanesCows
4 жыл бұрын
Not that I know of.
@toughbama
4 жыл бұрын
How would I have used this same concept for the collection to patch existing sharepoint list entries instead of making new ones? Like if I wanted it to compare collection to sharepoint list, and ForAll where SerialNumber = collection entry, patch these columns. Struggling to find and answer unfortunately.
@ShanesCows
4 жыл бұрын
Try UpdateIf. That will let you update only the records that meet your need.
@shikhagupta1810
3 жыл бұрын
Hi Shane, Your video really helps!! I have a collection that stores the GUID of records, say: Collect(TempCollection, ["58d95af1-xxxxxx-bacc-0022480a1560","xxxxxx-00c8-eb11-bacc-0022480a1560"]); and I am trying to use values stored in it do a Lookup/Filter but it doesn't Patch my data if i use collection ForAll(TempCollection,Patch('Concession Products',First(Filter('Concession Products','Concession Product' = GUID(Value))), { 'Concession Type':DdConcessionType.Selected.Value, 'Conceded Amount': Value(TxtConcededAmount.Text), 'Conceded Percentage': Value(TxtConcededPercentage.Text), 'Discount % off List Price': Value(TxtDiscountPercentageOffListPrice.Text), 'Concession Frequency': DdConcessionFrequency.Selected.Value, 'Pricing Scale':DdPricingScale.Selected.Value })); Same thing works if i hardcode that value as Patch('Concession Products',First(Filter('Concession Products', 'Concession Product' = GUID("5f6b62eb-00c8-xxxx-bacc-0022480a1560"))), { 'Concession Type':DdConcessionType.Selected.Value, 'Conceded Amount': Value(TxtConcededAmount.Text), 'Conceded Percentage': Value(TxtConcededPercentage.Text), 'Discount % off List Price': Value(TxtDiscountPercentageOffListPrice.Text), 'Concession Frequency': DdConcessionFrequency.Selected.Value, 'Pricing Scale':DdPricingScale.Selected.Value }); Can you help me here?
@carlaprieto8123
4 жыл бұрын
Hi Shane, Say you have a three screen form you are collecting data from (with Clearcollect()) and on the third screen you want to have a datatable for user to review values before using a patch() to submit into a sharepoint list. I would like to input a datatable where all the names are rows and the selected values are columns. How to I transpose the powerapps datatable?
@ShanesCows
4 жыл бұрын
Sorry I am behind on comments. Carla I have no idea. That is a fabulous question. I hope you figureged it out. 😀 ANd if you did leave a new comment with the answer
@MARIALEXA777
2 жыл бұрын
Hello Shane, love your videos. Do you have a link to how to do the easy save data of a form? I created two forms in the same app on separate screens and I need to save those two forms to the data list when they press submit before the exit screen. I'm new to Power Apps . Thanks
@ShanesCows
2 жыл бұрын
SubmitForm(FormName) is how you submit a form. If you have 2 forms then the button is SubmitForm(Form1);SubmitForm(Form2)
@geralddahl9159
5 жыл бұрын
I use PowerApps to create records using values from two lists in Sharepoint called contacts and items and then save those records in a third list called records. The problem is that when I edit a contact name in the Sharepoint contacts list it doesn't update items for that contact in the records list. I think a patch function relating the ID from my contacts list with its matching contactID value in the records list might work along with some If /ForAll coding. Am I off track or would you please consider doing a video related to this? Alternately, would a model-driven approach be better? PS - Merry Christmas to all the Youngs (and Chewie).
@ShanesCows
5 жыл бұрын
Two videos to help. There is a SharePoint lookup video start with it. Then watch PowerApps repeating table video. They will help you get this worked out. Merry Christmas to you and yours also.
@geralddahl9159
5 жыл бұрын
@@ShanesCows Thanks, Shane. Just watched repeating table part 1 and feel like I'm on my way. Look forward to part 2 and 3 and I will also revisit lookup. Really appreciate it!
@jenfrie7043
2 жыл бұрын
Hey Shane, I am nearly finished with my App. I connected the Sharepoint to my Data and the Dataspurce to my Code (Save - easy way). But the Data doesnt appear in my Sharpoint list. Do you know what I could have done wrong?
@shubhamchavan7338
3 жыл бұрын
Hey Shane Sir, How to create patch solution for parent table? what is 'CloneAsPatchRequest' or' CloneasPatchAction'? can you explain me this?
@ShanesCows
3 жыл бұрын
Sorry, not sure. I do talk about parent/child in this series a lot though kzitem.info/news/bejne/2Z2w1J9qkZ6BdqQ
@tomaseriksson6416
5 жыл бұрын
Hey Shane! Thanks for all the work you are doing, its helps me alot! I have a question, can i do the "easy way"with a choicefield from my sharepoint list? What should the code be for the "easy way"to patch a choice field?
@ShanesCows
5 жыл бұрын
This video has it covered. kzitem.info/news/bejne/yKmhl2h6ZnWKhXo
@jeffcenter1720
2 жыл бұрын
Good Evening Shane, I am looking for some advice/help in creating a form to collect data that will be updated by the user as a purchase order is created and completed, then I will need to creat reports in excel or my leadership to use. How can I doo this? Thank You Jeff
@ShanesCows
2 жыл бұрын
PowerApps Repeating Tables like InfoPath Part 1 - Enter the data kzitem.info/news/bejne/2Z2w1J9qkZ6BdqQ I have a multi part series on all of the fun. 😁
@martindasdas5834
3 жыл бұрын
Hi Shane Thanks for the Session ... Can we patch camera pictures in the attachement coloum in sharepoin list with the other datas..?
@ShanesCows
3 жыл бұрын
Not directly that i know of. YOu would have to use a flow to add them as attachemtns I think.
@mark_axtell
4 жыл бұрын
Loving your work! What do you need to do if there are spaces in between your cols in the sharepoint list?
@ShanesCows
4 жыл бұрын
The names are encoded. If you look in SharePoint list settings you can see the encoded name.
@imranfc
4 жыл бұрын
Hello Shane how to update Share Point list data with ForAll function formula ?
@ShanesCows
4 жыл бұрын
Patch inside your ForAll should work. Maybe thsi video will help with Patch? kzitem.info/news/bejne/yKmhl2h6ZnWKhXo
@farahfarhana172
3 жыл бұрын
Thanks. This error "the form you are trying to submit is in read only view mode . only editable form can be submitted powerapps" keep pop up on my submitForm(formname). Is there any solution ?
@ShanesCows
3 жыл бұрын
You need to change the form mode. kzitem.info/news/bejne/o6Swx4d6kp5poHY
@milinprkh
4 жыл бұрын
As always very amazing and useful videos! Can you please tell me, if it is possible to save the record to a new row instead of updating the same row in excel ? When i click on the copy icon on my detailform1, it will take me to EditForm1 with my textboxes and dropdowns auto-populated which were present in my detailform1. I will update just one dropdown and click on the check icon and this will be saved as a new row in my excel sheet. Currently, the DetailForm1 has edit (pencil) button which updates the existing row in my excel. I want to be able to update the existing row and also save as a new row if i update just one textbox. Thanks and regards!
@ShanesCows
4 жыл бұрын
Yes you need the form in New mode. kzitem.info/news/bejne/o6Swx4d6kp5poHY
Пікірлер: 498