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.
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
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.
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 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
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. 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>>>>
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.
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.
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 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?
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?
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 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), /*
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.
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
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 They have the exact same names, no misspelling, white space or ". All are required, none is uploading. I think the problem might be the data types not matching.
Hi Shane, it really helpful to use it in my app, but i have a concern, am storing the data in Sharepoint list and used Email to screen to send a mail to list of the people. I want to store the data and time of the email sent, to and subject and message. I used patch command to get the Subject and Message content to share point list, but i am not able to get the TO field. ANy idea on this ( Email screen).
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. 😀
@@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 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!
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
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?
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, 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
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.
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, 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?
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
@@ShanesCows Baseline for me: Mind-Fried...I do not use collections (yet). This would be updating a live Azure SQL DB. Assumption / Obviously in an "Edit" screen. Any thoughts? Would it make sense to use "Company_ID" instead of "Company_Name", in case there are multiple companies with the same name, etc.? Set('[dbo].[company]', LookUp('[dbo].[company]', Company_Name=TextInput_Company_Name.Text), Patch('[dbo].[company]', Defaults('[dbo].[company]'), {Company_Name: TextInput_Company_Name})
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.
Hello Shane, Need your little assistance. I can't save my data on local storage using Save Data function. Everytime I comes back to my app, it clears out the previous store data from collection. Please help
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
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 ?
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, 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
I used the Collect() func just like you did, but I'm not able to get any data out into my Data Source. It's an entity on CDS so it should e straight forward, but so far nothing. Any ideas?
@@ShanesCows I did that. They where aligned. I had to use patch to finally manage. But working simply with Collect didn't work. Mind due that I was exporting my data to CDS in opposition to SharePoint and that might be the difference. Which to me doesn't make any sense at all. Intriguing at the least.
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 (
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
Hi Shane! I'm trying to upload a whole Collection into an Excel table (the collection has around 100 lines of data) but it takes almost 5min to upload once I press the button. Is there any way of speeding up the process?
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!
Hi Shane...any input on how to use a 'Copy This Item / Duplicate Item' button? We'd like to save users time and duplicate data via button click...then put them right into editing the new item.
We may just use a custom action FLOW on the item selected and do a 'copy item'. Then order the items by current logged in user descending so most recent is on top.
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
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~!
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.
Hello Shane!!! I'm a little desperate because I need to store data in Excel from the App but not from forms but from text boxes, rating evaluations or bottoms..... How can I do that? Please help ..... Thank You!!! I don't have SharePoint, just Excel...
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
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?
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.
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)?
Does saving a collection with the ForAll function work with CDS (creating records from the collection)? caus I tried with the same syntax you put up her for SP - and it aint workin.
@@ShanesCows I got it working. Two things to pay attention to: 1. In the Patch function, every CDS field MUST be in either one of two formats • Schema Name (precisely, upper & lower case sensitive). e.g. cr707_diameterinner • Or Display name surrounded by commas. e.g. 'Diameter - Inner' 2. If you're mapping a to a CDS Lookup field you'll need to use PowerApps Lookup function and make sure - that for the condition part in Lookup - you use ONLY the Schema Name of the field at the parent entity. e.g. LookUp('Factory Shipments',cr707_shipmentnumber=varShipNum)
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!
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!!
Hi Shane, I used the easy to save data it doesn't work and I got weird message when clicking the saving data that I created formula was: Collect(TBL_Link;CollectionLink) there is an error message that says: the specified column “Link_Control” does not exist. The column with the closest name is “Link_Control” . Which is the same ! Thanks for your help
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..
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!
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.
Please Help, I have been following your videos to make an app and they have been super helpful but for some reason when I'm doing the same step as you at the end of the video "the hard way" I can't seem to get it to work. when I press save records, if I have 3 items in the collection I'm patching into the table, it will take the last record and make 3 copies of it and save 3 identical records to my main table. Below is the formula I'm using. Am I missing something? ForAll(collectionEditRecords, Patch(TI_tbl_Transactions, Defaults(TI_tbl_Transactions), {str_SN: serialNumberUpdate.Text, str_LocationID: Concat(locationUpdateCbo.SelectedItems,str_LocationID) , dtm_Date: dateUpdate.Text, str_Name: nameUpdate.Text})); Navigate(searchRecords,ScreenTransition.UnCoverRight); when I take off the .Text like it is in your video none of it works
I have a question. How can I connect the powerapp with sharepoint because when I use the Patch function in a button to store a value to a sharepoint list from this button it says the function Patch has some invalid arguments so I assume because I didn't connect the sharepoint with the powerapp or it's due to other things? I'd really appreciate your help, I'm new to this btw and thanks a lot for your videos
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!
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.
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!
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!
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. 😎
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 😎
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!
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
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.
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
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. 😀
Thanks Shane. This video really helped me complete my app.
You're welcome!
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. 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
Watching this now. Halloween 2019!!! Love the energy.
Thanks. I had Halloween stuff in my video today
Hi Shane, On the formula for Save - Hard Way, where would you the Lookup function to ensure the collection updates and existing item?
Dude you are awesome! Really enjoyed this video. Explained it very well and very charismatic. Thanks.
Thanks Ian. 🐶
Man, your videos have helped me so much in the last month! Thank you so much.
Awesome
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
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!
Great Video! Very thorough and helpful for different scenarios
Glad you enjoyed it!
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.
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.
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.
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.
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.
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.
Hey Tracey I haven't worked with Notes in Dataverse so not sure. 😑
@@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),
/*
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.
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
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?
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.
18:10 I have the names in the list and in the collection the exact same but it won't add the collection content to the list :(
I've tried Collect and ForAll with Patch, keeps giving me an error
I would look at your columns in the data source. Do they match? Do you have any that are required that you are not uploading?
@@ShanesCows They have the exact same names, no misspelling, white space or ". All are required, none is uploading. I think the problem might be the data types not matching.
@@ShanesCows I tried a few things, including adding numbers to a collection using Value() but I still get the same error...
Hi Shane, it really helpful to use it in my app, but i have a concern, am storing the data in Sharepoint list and used Email to screen to send a mail to list of the people. I want to store the data and time of the email sent, to and subject and message. I used patch command to get the Subject and Message content to share point list, but i am not able to get the TO field. ANy idea on this ( Email screen).
Whatever value you have in the to setting is a string. You should be able to save that the same way.
I got it... And implemented in app... Thanks ...😊
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. 😀
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.
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!
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
Nope. They have to have permissions to SharePoint to write to it.
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.
Hi Shane, once the data is save, how to view it on same way it will open like a form?
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.
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 😎
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?
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.
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. 😁
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
Looks like new version of PowerApp doesn´t take Selected.Value. What would be the alternative?
Selected.YourColumnName type Selected. And Power Apps will show you the available fields.
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?
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
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
Hi Shane, what can be added to ensure that this does create a duplicate record in SQL?
You could lookup first to see if a duplicate exists. I show in the video ruclips.net/video/Ap3_Ea9H8b0/видео.html
@@ShanesCows Baseline for me: Mind-Fried...I do not use collections (yet). This would be updating a live Azure SQL DB.
Assumption / Obviously in an "Edit" screen. Any thoughts? Would it make sense to use "Company_ID" instead of "Company_Name", in case there are multiple companies with the same name, etc.?
Set('[dbo].[company]', LookUp('[dbo].[company]', Company_Name=TextInput_Company_Name.Text),
Patch('[dbo].[company]', Defaults('[dbo].[company]'), {Company_Name: TextInput_Company_Name})
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.
Try UpdateIf. That will let you update only the records that meet your need.
Shane, thank you so much for sharing your knowledge! Helped me a lot!
Awesome 😎
Hello Shane,
Need your little assistance. I can't save my data on local storage using Save Data function. Everytime I comes back to my app, it clears out the previous store data from collection. Please help
Learn about Offline here ruclips.net/video/NwbqdA9j8Ek/видео.html which teaches how to save your data to the local device.
By using Patch function whether it could be possible to save a data in sharepoint list without making a new column...?
Hey Shane Sir,
How to create patch solution for parent table?
what is 'CloneAsPatchRequest' or' CloneasPatchAction'?
can you explain me this?
Sorry, not sure. I do talk about parent/child in this series a lot though ruclips.net/video/xgznk4XlPCo/видео.html
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
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 ?
You need to change the form mode. ruclips.net/video/BnzaSDYl8mA/видео.html
You shared your knowledge and also experiences, thank you much for your kind sharing.
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.
In customizing forms cant I use patch function to update records ?? in app it is working properly
This is the most useful video I found for patching
Thanks. Good to know this one is helpful. :)
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
Not sure. Sorry 😐
I used the Collect() func just like you did, but I'm not able to get any data out into my Data Source. It's an entity on CDS so it should e straight forward, but so far nothing. Any ideas?
I would check your columns align. If it isn't pushing data there should be an error.
@@ShanesCows I did that. They where aligned. I had to use patch to finally manage. But working simply with Collect didn't work. Mind due that I was exporting my data to CDS in opposition to SharePoint and that might be the difference. Which to me doesn't make any sense at all. Intriguing at the least.
Hi, Shane
I have a question how to add our company logo or u can say image on powerapp welcome screen ?
There is an image control on the insert menu under media. Or do it even better with this ruclips.net/video/AqZkUQ78e50/видео.html
Hi bro ,
My question is weather there is possiblity to upload video in powerapps and send it to sharepoint ?
Please answer me its too urgent please bro 😊
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 (
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.
Does Collect still work as you show around 19:00? When I try I get the floating dots but nothing written to the SP list
It does. Do your columns maybe not match?
@@ShanesCows I @mentioned you at PowerAppug on this - the details are there - Thanks!
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.
Appreciate your time and effort for making these amazing videos..
You are welcome
Love your energy Shane!
Thanks 😊
Hi Shane!
I'm trying to upload a whole Collection into an Excel table (the collection has around 100 lines of data) but it takes almost 5min to upload once I press the button. Is there any way of speeding up the process?
Using Collect method instead of Patch might be faster and worth a shot.
Instead of using patch, can't we update a column value in new form while submitting form to SharePoint list?
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
Hi Shane...any input on how to use a 'Copy This Item / Duplicate Item' button? We'd like to save users time and duplicate data via button click...then put them right into editing the new item.
Have to set the default values for the fields
We may just use a custom action FLOW on the item selected and do a 'copy item'. Then order the items by current logged in user descending so most recent is on top.
Excellent video Shane!!! Just one question. How do I delete a specific record in a SharePoint list?
You can use the Remove function.
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)
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.
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.
Hello Shane!!! I'm a little desperate because I need to store data in Excel from the App but not from forms but from text boxes, rating evaluations or bottoms..... How can I do that? Please help ..... Thank You!!! I don't have SharePoint, just Excel...
Everything is exactly the same. Use Patch function
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
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.
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?
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.
Hello Shane how to update Share Point list data with
ForAll function formula ?
Patch inside your ForAll should work. Maybe thsi video will help with Patch? ruclips.net/video/gsk14D-CYRE/видео.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
Does saving a collection with the ForAll function work with CDS (creating records from the collection)? caus I tried with the same syntax you put up her for SP - and it aint workin.
It works for both SharePoint and CDS. Try it again and make it simple.
@@ShanesCows I got it working.
Two things to pay attention to:
1. In the Patch function, every CDS field MUST be in either one of two formats
• Schema Name (precisely, upper & lower case sensitive). e.g. cr707_diameterinner
• Or Display name surrounded by commas. e.g. 'Diameter - Inner'
2. If you're mapping a to a CDS Lookup field you'll need to use PowerApps Lookup function and make sure - that for the condition part in Lookup - you use ONLY the Schema Name of the field at the parent entity.
e.g. LookUp('Factory Shipments',cr707_shipmentnumber=varShipNum)
Very well explained and detailed. Helped greatly with my project. Thanks!
Glad it helped!
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.
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
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.
Hi Shane, can you please tell me how to break out of ForAll
Not possible that I know of.
Hi Shane, I used the easy to save data it doesn't work and I got weird message when clicking the saving data that I created formula was: Collect(TBL_Link;CollectionLink) there is an error message that says: the specified column “Link_Control” does not exist. The column with the closest name is “Link_Control” . Which is the same ! Thanks for your help
Weird. I am not sure on that one :(
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..
Can you demonstrate. Capture an image to text and compare the text to the SharePoint list column if it is match or not? Thank you in advance
Haven’t done that. Sorry.
@@ShanesCows Hi. I hope you can one Time. Thank you
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!
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.
Please Help, I have been following your videos to make an app and they have been super helpful but for some reason when I'm doing the same step as you at the end of the video "the hard way" I can't seem to get it to work. when I press save records, if I have 3 items in the collection I'm patching into the table, it will take the last record and make 3 copies of it and save 3 identical records to my main table. Below is the formula I'm using. Am I missing something?
ForAll(collectionEditRecords, Patch(TI_tbl_Transactions, Defaults(TI_tbl_Transactions), {str_SN: serialNumberUpdate.Text, str_LocationID: Concat(locationUpdateCbo.SelectedItems,str_LocationID) , dtm_Date: dateUpdate.Text, str_Name: nameUpdate.Text}));
Navigate(searchRecords,ScreenTransition.UnCoverRight);
when I take off the .Text like it is in your video none of it works
That is because you are patching your text inputs instead of the column names. 😀
I have a question. How can I connect the powerapp with sharepoint because when I use the Patch function in a button to store a value to a sharepoint list from this button it says the function Patch has some invalid arguments so I assume because I didn't connect the sharepoint with the powerapp or it's due to other things? I'd really appreciate your help, I'm new to this btw and thanks a lot for your videos
Yes you need to add your SharePoint list as a datasource
Thanks Shane!!! You are my savior!!
Glad to help. 😀