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.
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.
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 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
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.
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
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>>>>
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
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?
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".
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!
@@ShanesCows I have the list box choices coming from a table in excel & I would like it to save whatever the user selects in the SP list. Would that make it incompatible since I'm not actually inputting choices in the SP list?
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.
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?
You could use Concat function to turn your table data into a string of data and then write that string to a single column. ruclips.net/video/AnERfGIE8gw/видео.html not exact but will help you with the function.
Hi Shane. Great video as well as all others. Thanks a lot. In your video you describe how to upload new records from collection to data source. What about updating records in bulk mode? In my App I collected all records from an Entity (CDS) to a collection and added some functionality to update values in the collection or add new items into collection. And then I would like to upload all my changes to datasource. Can I use “Easy way” to upload changes or I have to use “Hard way” only. What if my collection contains new items and updated ones? Should I process these items one by one and check if this is a new one or just updated. Thank you in advance.
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.
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.
Shane, great video! One question when saving the "easy" way, what is the field in the powerapp that must match the data base column so you don't have error writing to the SharePoint list? Is it the DataCard itself or the DataCardValue or is it something else?. I'm having some issues, and I think it has to do with how I named my columns in the Sharepoint List, They have spaces and special Characters. Thanks Again!
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..
Thanks so much for making this/all your videos Shane! I follow exactly what you're trying to teach in this video, however I'm running into issues with attempts to save to SharePoint with Collect AND ForAll/Patch even when following your code exactly! Any chance the functions have changed since last year? Really pulling my hair out on this one.
Never mind! Finally figured it out, there was a collection that was the same name as a SP list that was preventing the connection from working properly.
Hi Shane, Thank you so much for all the videos. I have a question regarding saving data the easy way. Does same name collection/data source, one fell swoop save, only work if entering data into a gallery?
@@ShanesCows ah that would be my problem, its not table to table. I have data cards with a variety of text inputs, dropdowns and controls which need to be saved into a sql table. Is there an easy way for that, or will I have to go the hard route? It's a pretty extensive form.
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.
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
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?
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?
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 ruclips.net/video/imhxy3REgXc/видео.html
Thank you for this video. If we are using the ForAll and want to update two SharePoint lists with the information in the collection say Title and Qty on one list and rating and another column on the second list. What would function look like for that?
Thank you for your great videos! Question: I am working on an app that puts data that is input by the user through a couple of cascading dropdowns and text input boxes into a collection (this part of the app is working perfectly). I would then like to use some of that data in a new screen but also save all the data in a SharePoint list. Is it possible to save the data directly to the SharePoint list or must you add it to a collection first and then save to a SharePoint list (I am a bit confused about this). What are the pros/cons of either scenario? Thank you so much for your time!
Hi Shane, love your videos. I got a sharepoint list with data and a similar sharepoint list with "requests"... that are based on the first list. Some request are new orders, some are changes to existing orders and some are deletions of existing orders. I'm curious, is it possible to use the patch function to update the first list with the second list. Would you need to create one collection of each type of request (new, update, delete) from list two, before you update list 1? Or would a For all function be better in some cases? Would love a video on that! :-)
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...
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.
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!
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
Shane your stuff is great and has taught me a ton. I've been searching your videos for the scenario of patching two related(parent/child) data sources at the same time but I haven't been able to find if you have done that. I'm having trouble with creating a new record in the parent while simultaneously adding related records to the child list. Using your varNewRecord method I don't have access to the ID field of the parent so I'm struggling with how to manage the child. Is this worthy of one of your Thursday quick tips? Thanks in advance.
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~!
When you did the dropdown in powerapps for the candy to go into the sharepoint list did you make it a "single line text" or "choice" with drop down column in the sharepoint list?
Hi Shane! Thank you so much for taking the time to make these videos. Quick question - my app is using a gallery...after I save responses in a gallery to a collection (before saving to the Share Point list), how can I reset the gallery so that I can start fresh without seeing the previous responses in the gallery?
Very nice video! I still have one big question: Does ClearCollect also work the other way around? I want to replace my data source with my collection and it doesn’t work (same columns) 😭
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.
Collect(YourCollection, {TimeColumnInCollection: Now()});Patch(SharePointLists, Defaults(SharePointLists), {TimeColumn: Now()}) Something like that should give you ideas.
Thanks! One other question. Do you have a video on duplicating rows in a sharepoint table? User collects feedback, similar to another piece, instead of writing it up, duplicate and select a new feedback source being the example
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
Shane hi, the app was created exclusivly using Share Point, is it possible to follow the same procedure to store the data inside a specific entitie CDS? Also what are the reasons or conditions to take into consideration to select a between SharePoint vd CDS to store data from forms? In terms of data we are speaking of maximum 1000 lines per day Once again thank you for your videos and help!!
How I can use the collect function with a form if I want to save form multiple times and then add all at my SharePoint list? Thanks for your help you are amazing
Hi Shane, Very nice video. I am new in PowerApp and learning from your videos only. I am facing one issue i.e how do i implement this approach for SharePoint list attachment? Need your guidance.
Hello Shane. Thank you very much for investing time with the Power Apps videos. This video was very helpful. Question: How can you automate clearing of the collection data - collected from multiple sources and stored in a collection? It's duplicating the data every time I add and post from the collection to an online excel file in Onedrive.
Hi Shane, really helpful video thank you. I have two questions one is probably very basic. 1) is each collection unique to that user for example is my collection different to my colleagues when using the app, or do all users submit data to one collection? Seems obvious but it's not a query I can find an answer for! 2) about performance. When I do the first method you suggest of downloading the collection to my datasource (headers all the same as my datasource) it is taking a few minutes. This is only with a collection of 5 or 6 records. This isn't obviously acceptable for our users (main reason I chose collect over submitform was because each form was taking 5 seconds to submit & the user needs to easily see their entries (likely 5 each)). To combat this, I was thinking of bulk updating the app collection on a schedule to my data source (if all users submit to one collection) to avoid users experiencing any lags. But I don't believe this can be automated and would rely on me to undertake this task which is not not a great solution if I go on long term sick for example. Any suggestions? I have to use Excel and Box, as our ICT policy is not allowed to use SharePoint or OneDrive.
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 RUclips" for 10% off www.powerapps911.com/training
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?
Yes an Excel hosted on OneDrive can be a datasource. ruclips.net/video/-Z_13J02RPU/видео.html Yes collections are temporary ruclips.net/video/yS6mTRlmuls/видео.html
Hey Shane, this is great info. I'm looking into reworking all my old Infopath forms using Powerapps but I have a question about using the Patch function. Is there a max number of columns in a record can it update? I have a 60 question quiz that sometimes loses data when it hits the max number of changes the SharePoint server can handle and 'm hoping Powerapps can overcome this limitation so my 60 question quiz works consistently. Thanks again!
Been watching your videos obsessively, thank you immensely for all of your guidance. One question: what do you do if one of your column names is a date (eg. '3/3/2019') and you are trying to patch a value to it? Cant seem to get the syntax right... (see the very last update) If(DatePicker2.SelectedDate= Date(2019,3,3),Patch(Table1,Defaults(Table1),{Resource: ResourceEnter.Text, 'Project Number': ProjectNumberEnter.Text, 'Project Name': ProjectNameEnter.Text, Client: ClientEnter.Text, Status: StatusDrop_N.Selected.Value, 'Work Type': WorkTypeDrop_N.Selected.Value, Team: TeamEnter.Text, Practice: PracticeEnter.Text, '3/3/2019':HoursInput_N.Text}),false)
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.
Hi Shane, First of all I would like to say Big thank you for your videos. These videos are awesome! before couple of days i encountered an issue, just wanted your help to sort this or have an understanding so that i donot make the same mistake next time. issue: I have a collection which has 28 columns and i had to add two more columns in the same. before adding these two columns my patch function was working perfectly fine. I had used the easy method that you showed in this video. So before adding the column in collection added those two columns in my sharepoint list also and then added them in the collection. for collection it was working fine but the patch function was throwing an error stating that patch function requires record and it was throwing error for Collection and showing it as Table . could please advise what could be the reason for this ?
Thanks for your response, just wanted to have an understanding that can we add columns in collection and Sharepoint list at any point of time and what is the limit of adding columns in collection and sharepoint list?
Hi Shane, Thanks a lot for your great videos! On my editform, I have a dropdown (combo box) connected to a Sharepoint list with a choice column. This list provides the list of products I want to use. What I need to do is to then patch selected items from this drop down to a field (column) in CDS. I keep getting errors with any formula I try for patch. Is there any specific formula/combination I need to use?
Hi Shane. I think I can use this video to improve my request form but quick question, does the patch function work with multiple choices selection? I built a sharepoint list and I have a question where the requestor can select several options, if this is possible with the patch function, how will the "code" be?
Hi Shane, thanks for this amazing video! May I ask if there is a way to also patch user id (email or anything that an indivudual user uses to login) and save this information in a SQL table when patching? but without the user to type in their name when completing this form? I am building a survey app and want to capture the user ID without asking them to type it in when they complete the survey questions. Thanks!
Thanks Shane, what to do if you want to capture username and date/time from the app and then add it to the SharePoint list once click on submit button (with the other inputs of course)?
Question for you... I have a form that is from a sharepoint list, can I have the edit function write a new line in the sharepoint list vs editing the same line?
If the form mode is Edit then it will update the record. If the form mode is new then it will create a new record. Set the form to the mode you need. 😀
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).
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.
@@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!
HI Shane, Loving all your videos. i have a text input that takes a number and i need to make a collection with that many items in it. for example if the user types in 20 then 20 rows of data are inserted into a sharepoint list. each row contains 2 column. the first is the same for all rows but the second needs to be a number (from 0 to the number the user puts in the box) is there a way of doing this? i tried with flow but it only does up to 60 records. thanks
@@ShanesCows HI Shane, I watched your bar scanner app and got inspired. I used a timer and some variables and solved the problem. increase the variable each time the timer run and using an if statement to say when the variable gets to a certain value then set time start to false and then open a new screen (or do whatever)
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
PowerApps Repeating Tables like InfoPath Part 1 - Enter the data ruclips.net/video/xgznk4XlPCo/видео.html I have a multi part series on all of the fun. 😁
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?
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 (
Shane, your videos are amazing for a beginner like me... I'm stuck on a for all patch. I have a collection that gets created with the ID of the selected item in a gallery in one column, and a status from a combo box in another. What I'm trying to do is forall patch, but I can't workout how to use the ID in the collection (from the gallery selected item) and get the patch to identify the sharepoint record to update. Any help would be greatly appreciated.
Hey Shane, I am in Sydney Australia, a big fan of yours since years. I even got to meet you in one of the Microsoft conferences in Sydney years ago. Anyways, great video as always. A quick question please - with the easy way of saving the whole collection to your data source (e.g. SharePoint), how do you deal with when you have a choice column in SP list, while in your collection you have captured that data as text with a textinput or a dropdown? Thanks bunch.
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!
Glad you like them!
You are my hero! "Save - Hard Way" is exactly what I've been looking for to make my complicated, batch upsert work.
Great to hear!
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.
Thanks I added one of the tags.
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.
Thanks. A lot of different levels watch so I try to find that balance.
agree with you totally. they are sometimes too slow. 9 minutes before we get to the actual coding... but you do know your stuff.
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.
Awesome 😎
Best Video of all!... I spent a entire day trying what you've got solve in 5 minutes.
Thanks a lot!
Awesome
@@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
Little whacky but man did this help me with my project. Great work. Straight to the point.
Thank you :)
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.
Great!
Thankyou Shane... I am a fresher and new to this field... Your videos really help me a lot.. Thankyou once again
You're so welcome!
Watching this now. Halloween 2019!!! Love the energy.
Thanks. I had Halloween stuff in my video today
Thank you Shane for your very helpful videos. I learn something new each time I watch one of your videos.
Please keep it up.
Glad to help. 😀
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
🐶 Truth be told I don’t get all of the comments any more. Boo! But I try like heck. 😎
I really appreciate your videos I’ve learned a lot from them. Thanks
Glad to hear it!
Great video Shane. This is what I’m looking for the app in working on. Just loved it 👍👍👍👍 life saver.
Awesomeness
Man, your videos have helped me so much in the last month! Thank you so much.
Awesome
Hi Shane,
One of the best tutorial video for Powerapps
Thank you Vijay. 🥰 I have about 250 videos on the same at this point. I hope you subscribe and enjoy.
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>>>>
Thanks
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
Try this video ruclips.net/video/NwbqdA9j8Ek/видео.html
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?
This video has it covered. ruclips.net/video/gsk14D-CYRE/видео.html
Loving your work! What do you need to do if there are spaces in between your cols in the sharepoint list?
The names are encoded. If you look in SharePoint list settings you can see the encoded name.
Shane, thank you so much for sharing your knowledge! Helped me a lot!
Awesome 😎
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".
So much better than infopath 😎
You shared your knowledge and also experiences, thank you much for your kind sharing.
Appreciate your time and effort for making these amazing videos..
You are welcome
Thanks Shane. This video really helped me complete my app.
You're welcome!
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!
Dude you are awesome! Really enjoyed this video. Explained it very well and very charismatic. Thanks.
Thanks Ian. 🐶
Great Video! Very thorough and helpful for different scenarios
Glad you enjoyed it!
This is the most useful video I found for patching
Thanks. Good to know this one is helpful. :)
Excellent video Shane!!! Just one question. How do I delete a specific record in a SharePoint list?
You can use the Remove function.
Very helpful, thank you! Question - is it possible to use Patch with a list box?
Yes, for sure. Try listbox.Selected.columnname
@@ShanesCows I have the list box choices coming from a table in excel & I would like it to save whatever the user selects in the SP list. Would that make it incompatible since I'm not actually inputting choices in the SP list?
I watched your 'PowerApps SharePoint Complex Columns' video, but you actually had choices in your SP 'Law' list.
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.
Candy is important. 😝 Glad they are helping.
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?
You could use Concat function to turn your table data into a string of data and then write that string to a single column. ruclips.net/video/AnERfGIE8gw/видео.html not exact but will help you with the function.
@@ShanesCows thanks Shane. Really appreciated. My own research wasn’t turning up much results!
Hi Shane. Great video as well as all others. Thanks a lot.
In your video you describe how to upload new records from collection to data source. What about updating records in bulk mode? In my App I collected all records from an Entity (CDS) to a collection and added some functionality to update values in the collection or add new items into collection. And then I would like to upload all my changes to datasource. Can I use “Easy way” to upload changes or I have to use “Hard way” only. What if my collection contains new items and updated ones? Should I process these items one by one and check if this is a new one or just updated.
Thank you in advance.
You have to use ForAll to patch back all of your changes since they are edits.
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.
Hi Shane, On the formula for Save - Hard Way, where would you the Lookup function to ensure the collection updates and existing item?
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.
Glad to help Melissa.
Very well explained and detailed. Helped greatly with my project. Thanks!
Glad it helped!
HI Shane, your learning videos are really helpful
😎🐶 Awesome
Hi Shane Thanks for the Session ... Can we patch camera pictures in the attachement coloum in sharepoin list with the other datas..?
Not directly that i know of. YOu would have to use a flow to add them as attachemtns I think.
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?
I would say all the same
Shane, great video! One question when saving the "easy" way, what is the field in the powerapp that must match the data base column so you don't have error writing to the SharePoint list? Is it the DataCard itself or the DataCardValue or is it something else?. I'm having some issues, and I think it has to do with how I named my columns in the Sharepoint List, They have spaces and special Characters. Thanks Again!
The column name has to match the name in SharePoint.
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..
Thanks so much for making this/all your videos Shane! I follow exactly what you're trying to teach in this video, however I'm running into issues with attempts to save to SharePoint with Collect AND ForAll/Patch even when following your code exactly! Any chance the functions have changed since last year? Really pulling my hair out on this one.
Never mind! Finally figured it out, there was a collection that was the same name as a SP list that was preventing the connection from working properly.
Awesome! 😎
Hi Shane, Thank you so much for all the videos. I have a question regarding saving data the easy way. Does same name collection/data source, one fell swoop save, only work if entering data into a gallery?
Nope. Should just work writing any table to a table.
@@ShanesCows ah that would be my problem, its not table to table. I have data cards with a variety of text inputs, dropdowns and controls which need to be saved into a sql table. Is there an easy way for that, or will I have to go the hard route? It's a pretty extensive form.
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.
Patch or form will work. SharePoint has a yes no column I would store the value in. Shouldn’t be different than other fields.
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
Try simplfing the ForAll patch(datasource, defaults(datasource), {datasource column: Title}) and what does the flow do?
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?
That is a complicated question for a beginner. I don't have a video on it but will add it to my list.
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?
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 ruclips.net/video/imhxy3REgXc/видео.html
Thank you for this video. If we are using the ForAll and want to update two SharePoint lists with the information in the collection say Title and Qty on one list and rating and another column on the second list. What would function look like for that?
ForAll(collection, patch(firstlist...);patch(secondlist...))
@@ShanesCows thank you.
Thank you for your great videos! Question: I am working on an app that puts data that is input by the user through a couple of cascading dropdowns and text input boxes into a collection (this part of the app is working perfectly). I would then like to use some of that data in a new screen but also save all the data in a SharePoint list. Is it possible to save the data directly to the SharePoint list or must you add it to a collection first and then save to a SharePoint list (I am a bit confused about this). What are the pros/cons of either scenario? Thank you so much for your time!
Watch the vid again..... it's all in there! Patch worked great for me.
Hi Shane, love your videos.
I got a sharepoint list with data and a similar sharepoint list with "requests"... that are based on the first list.
Some request are new orders, some are changes to existing orders and some are deletions of existing orders.
I'm curious, is it possible to use the patch function to update the first list with the second list.
Would you need to create one collection of each type of request (new, update, delete) from list two, before you update list 1?
Or would a For all function be better in some cases?
Would love a video on that! :-)
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...
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.
Thank so much, Shane, Is it possible to save to the sharepoint list, without changing the screen?
Yes. You control where you go. So if you don’t put in a navigate function you will not go anywhere.
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!
Yes you need the form in New mode. ruclips.net/video/BnzaSDYl8mA/видео.html
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
SubmitForm(FormName) is how you submit a form. If you have 2 forms then the button is SubmitForm(Form1);SubmitForm(Form2)
Shane your stuff is great and has taught me a ton. I've been searching your videos for the scenario of patching two related(parent/child) data sources at the same time but I haven't been able to find if you have done that. I'm having trouble with creating a new record in the parent while simultaneously adding related records to the child list. Using your varNewRecord method I don't have access to the ID field of the parent so I'm struggling with how to manage the child. Is this worthy of one of your Thursday quick tips? Thanks in advance.
Sorry I am slow to repond Jack. This series shows exactly what you want. ruclips.net/video/xgznk4XlPCo/видео.html
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~!
Single quotes is because you have spaces in your names.
When you did the dropdown in powerapps for the candy to go into the sharepoint list did you make it a "single line text" or "choice" with drop down column in the sharepoint list?
Single line of text.
Hi Shane! Thank you so much for taking the time to make these videos. Quick question - my app is using a gallery...after I save responses in a gallery to a collection (before saving to the Share Point list), how can I reset the gallery so that I can start fresh without seeing the previous responses in the gallery?
You would have to clear the collection. So maybe save collection 1 to collection 2. Then clear collection 1 to show in the gallery again?
Very nice video! I still have one big question: Does ClearCollect also work the other way around? I want to replace my data source with my collection and it doesn’t work (same columns) 😭
I don't follow your question. Sorry. Leave another comment (new) with more details and I can try to help.
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.
Collect(YourCollection, {TimeColumnInCollection: Now()});Patch(SharePointLists, Defaults(SharePointLists), {TimeColumn: Now()})
Something like that should give you ideas.
Thanks! One other question. Do you have a video on duplicating rows in a sharepoint table? User collects feedback, similar to another piece, instead of writing it up, duplicate and select a new feedback source being the example
I don’t. Trying to think of the easiest path to put you down but I don’t have one. I have never ad to do it for a real app. 🤔
these are still going strong and how timely as well being a Halloween from the future.
I loved this video. 🎃
t-rex lookin real fly, shane
Thanks 🐱🐉
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
I don't. SOrry. But it is possible.
Shane hi, the app was created exclusivly using Share Point, is it possible to follow the same procedure to store the data inside a specific entitie CDS? Also what are the reasons or conditions to take into consideration to select a between SharePoint vd CDS to store data from forms? In terms of data we are speaking of maximum 1000 lines per day
Once again thank you for your videos and help!!
Yes saving to CDS should be roughly the same. CDS is MUCH better at scale. If you have the license it is always better than SharePoint
How I can use the collect function with a form if I want to save form multiple times and then add all at my SharePoint list? Thanks for your help you are amazing
Unfortunately collections don’t work with forms.
Hi Shane,
Very nice video. I am new in PowerApp and learning from your videos only. I am facing one issue i.e how do i implement this approach for SharePoint list attachment? Need your guidance.
For list attachments you have to use a Form and an attachment control.
@@ShanesCows Is it possible with this approach which you have shown in video?
Hello Shane. Thank you very much for investing time with the Power Apps videos. This video was very helpful. Question: How can you automate clearing of the collection data - collected from multiple sources and stored in a collection? It's duplicating the data every time I add and post from the collection to an online excel file in Onedrive.
ClearCollect will wipe out a collection before saving the new values to it.
@@ShanesCows Thank you. It worked
Love your energy Shane!
Thanks 😊
Hi Shane, really helpful video thank you.
I have two questions one is probably very basic.
1) is each collection unique to that user for example is my collection different to my colleagues when using the app, or do all users submit data to one collection?
Seems obvious but it's not a query I can find an answer for!
2) about performance. When I do the first method you suggest of downloading the collection to my datasource (headers all the same as my datasource) it is taking a few minutes. This is only with a collection of 5 or 6 records. This isn't obviously acceptable for our users (main reason I chose collect over submitform was because each form was taking 5 seconds to submit & the user needs to easily see their entries (likely 5 each)).
To combat this, I was thinking of bulk updating the app collection on a schedule to my data source (if all users submit to one collection) to avoid users experiencing any lags. But I don't believe this can be automated and would rely on me to undertake this task which is not not a great solution if I go on long term sick for example.
Any suggestions?
I have to use Excel and Box, as our ICT policy is not allowed to use SharePoint or OneDrive.
Great work this was really helpful. I'm considering your online courses after this:)
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 RUclips" for 10% off www.powerapps911.com/training
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.
You can use DateAdd function to add dates. ruclips.net/video/EbYMN4ouOvQ/видео.html
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?
Yes an Excel hosted on OneDrive can be a datasource. ruclips.net/video/-Z_13J02RPU/видео.html
Yes collections are temporary ruclips.net/video/yS6mTRlmuls/видео.html
Hi Shane, Your videos are Awesome!! Can you please show how can we patch Lookup column data into CDS Entities
One of these days I will get to CDS. One day. Sigh. I need to hurry up.
Thanks Shane!!! You are my savior!!
Glad to help. 😀
Thanks Shane, your videos are really helpful!
Glad to help. 😀
Hey Shane, this is great info. I'm looking into reworking all my old Infopath forms using Powerapps but I have a question about using the Patch function. Is there a max number of columns in a record can it update? I have a 60 question quiz that sometimes loses data when it hits the max number of changes the SharePoint server can handle and 'm hoping Powerapps can overcome this limitation so my 60 question quiz works consistently. Thanks again!
Not sure. I have never hit a limit but also not sure I ever had 60 columns
Ok, well here goes nothing. Thanks for the reply.
Been watching your videos obsessively, thank you immensely for all of your guidance. One question: what do you do if one of your column names is a date (eg. '3/3/2019') and you are trying to patch a value to it? Cant seem to get the syntax right... (see the very last update)
If(DatePicker2.SelectedDate= Date(2019,3,3),Patch(Table1,Defaults(Table1),{Resource: ResourceEnter.Text, 'Project Number': ProjectNumberEnter.Text, 'Project Name': ProjectNameEnter.Text, Client: ClientEnter.Text, Status: StatusDrop_N.Selected.Value, 'Work Type': WorkTypeDrop_N.Selected.Value, Team: TeamEnter.Text, Practice: PracticeEnter.Text, '3/3/2019':HoursInput_N.Text}),false)
I second that!
I don’t know. I have never tried that. If I get a chance I will try.
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.
You have to save their response to a data source.
Hi Shane, First of all I would like to say Big thank you for your videos. These videos are awesome!
before couple of days i encountered an issue, just wanted your help to sort this or have an understanding so that i donot make the same mistake next time.
issue: I have a collection which has 28 columns and i had to add two more columns in the same. before adding these two columns my patch function was working perfectly fine. I had used the easy method that you showed in this video. So before adding the column in collection added those two columns in my sharepoint list also and then added them in the collection. for collection it was working fine but the patch function was throwing an error stating that patch function requires record and it was throwing error for Collection and showing it as Table . could please advise what could be the reason for this ?
Did you maybe need to refresh your data source in Power Apps to get the new columns loaded?
Thanks for your response, just wanted to have an understanding that can we add columns in collection and Sharepoint list at any point of time and what is the limit of adding columns in collection and sharepoint list?
Hi Shane,
Thanks a lot for your great videos! On my editform, I have a dropdown (combo box) connected to a Sharepoint list with a choice column. This list provides the list of products I want to use. What I need to do is to then patch selected items from this drop down to a field (column) in CDS. I keep getting errors with any formula I try for patch. Is there any specific formula/combination I need to use?
Sorry need more info. Try leaving a new comment with the formula
Love it Shane! haha informative and fun. Good job mate!
Thanks 😊
Hi Shane. I think I can use this video to improve my request form but quick question, does the patch function work with multiple choices selection? I built a sharepoint list and I have a question where the requestor can select several options, if this is possible with the patch function, how will the "code" be?
This video ruclips.net/video/gsk14D-CYRE/видео.html
Hello Shane, Is there any connector or API that can be used to display the device's internet speed on the PowerApp apps?
Not that I know of.
Thanks Shane for this wonderful tutorial.
Glad to help. 😀
Hi Shane, thanks for this amazing video! May I ask if there is a way to also patch user id (email or anything that an indivudual user uses to login) and save this information in a SQL table when patching? but without the user to type in their name when completing this form? I am building a survey app and want to capture the user ID without asking them to type it in when they complete the survey questions. Thanks!
This video :) ruclips.net/video/tNKcsuL72ks/видео.html
Thanks Shane, what to do if you want to capture username and date/time from the app and then add it to the SharePoint list once click on submit button (with the other inputs of course)?
This video :) ruclips.net/video/tNKcsuL72ks/видео.html
Question for you... I have a form that is from a sharepoint list, can I have the edit function write a new line in the sharepoint list vs editing the same line?
If the form mode is Edit then it will update the record. If the form mode is new then it will create a new record. Set the form to the mode you need. 😀
Hi Shane! Is it possible to have one Excel file as data source and another Excel file for the collection of data?
Yes. Look for my video on multiple data sources
By using Patch function whether it could be possible to save a data in sharepoint list without making a new column...?
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).
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.
@@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!
HI Shane, Loving all your videos.
i have a text input that takes a number and i need to make a collection with that many items in it. for example if the user types in 20 then 20 rows of data are inserted into a sharepoint list. each row contains 2 column. the first is the same for all rows but the second needs to be a number (from 0 to the number the user puts in the box) is there a way of doing this? i tried with flow but it only does up to 60 records. thanks
Someone else asked this. I never solved it. 😑 I need to one of these days. Let me do if you do.
@@ShanesCows Thank Shane. keep up the great videos.
@@ShanesCows HI Shane, I watched your bar scanner app and got inspired. I used a timer and some variables and solved the problem. increase the variable each time the timer run and using an if statement to say when the variable gets to a certain value then set time start to false and then open a new screen (or do whatever)
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
PowerApps Repeating Tables like InfoPath Part 1 - Enter the data
ruclips.net/video/xgznk4XlPCo/видео.html I have a multi part series on all of the fun. 😁
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?
Shane you´re just great!
Thanks Lukas, you are too kind.
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 (
Shane, your videos are amazing for a beginner like me... I'm stuck on a for all patch. I have a collection that gets created with the ID of the selected item in a gallery in one column, and a status from a combo box in another. What I'm trying to do is forall patch, but I can't workout how to use the ID in the collection (from the gallery selected item) and get the patch to identify the sharepoint record to update. Any help would be greatly appreciated.
Hey Shane, I am in Sydney Australia, a big fan of yours since years. I even got to meet you in one of the Microsoft conferences in Sydney years ago. Anyways, great video as always. A quick question please - with the easy way of saving the whole collection to your data source (e.g. SharePoint), how do you deal with when you have a choice column in SP list, while in your collection you have captured that data as text with a textinput or a dropdown? Thanks bunch.
That is a complex column. This video talks about those ruclips.net/video/gsk14D-CYRE/видео.html