Thank you for a great video! I have a question: How do you reset all field to blank after you submit the form without deleting them from collection? Thank you!
One thing to mention is that for the first two records, because there was no change, nothing was submitted on Genre, so for dropdowns a different approach is required, especially due to the "Select..." value too (resetting the control wouldn't work as it would reset the others too).
Hey Adi.. Yes I noticed that while I was filming the video but glazed over it as I thought nobody would really pick up on what I did and just fix it in their own app :)... You are completely correct you do need to implement a little bit of extra code to get the drop down field 'Genre' (or any drop down field) to work correctly. In this instance, on the Default property of Genre the following code should fix the issue - 'If(IsBlank(ThisItem.crd96_genre),"Select...",ThisItem.crd96_genre)'
All super happy, this will help, only one thing, there are a few fields I need to update, is there no better visual than text boxes, like an excel grid?
@@ChinoDoesStuff pretty much exactly what I needed, will see if I can add them to a collectiom and patch the collection, else I may get many blank rows if the user gets distracted (i will be addinfmg logic that it only show ñs recirds that user modified and do a somehow recent (likely the need for the collect) but the inspiration is there
Great Tutorial. I have two questions hope you can advise :) 1. How to make it auto populate to other column once we pick from the drop down list? for example once pick item from column A then automatic populate defined data on Column B and C? 2. I'm on processing to create monthly timesheet, Can you advise once select month and relate to the date on the label?
On the Save button portion of the code (the last section) my application is erroring out saying: 'The specified column 'crfde_PartDescription' does not exist. The column with the most similar name is 'Part Description'.' However, when I try using the 'human readable' name of the field with 'Part Description' (that is what the error suggests) it also doesn't work.
Hi. Thanks for the video. I got stuck in a problem with the save button. As the example you show, I also have a date field, that in the Sharepoint List is set as a Date/Time (only date). I setted On Change = Patch( DataInput; ThisItem; {dt_impact : dtpicker_impact.SelectedDate}) I also tried = Patch( DataInput; ThisItem; {dt_impact : DateValue(dtpicker_impact.SelectedDate)}) But save button has the error like: The type of this argument does not match the expected type. The expected type is Date and you are using text. Could you help??
This was a great video! I have a couple questions. 1-The Patch command clears out the TextInput once it is clicked out. The values are still being collected, but they are not visible in the TextInput. I tried adding the default value to ThisItem.fieldname but it causes a delay when trying to go to the next field. It didn't look like you had this issue in your video. any suggestions? 2- a few of the fields have a default value that I don't want visible. Because the default value doesn't cause a change, the data isn't being Patched. Is there a way that I can still have that patch?
Hi , we can create multiple new records in sharepoint also? I have user requirement where user wants to create more than 1 record using single click of button in powerapps.
@@ChinoDoesStuff okk. Is there any other way of creating multiple records into sp list. I tried using for all and patch but it creates duplicate copies of same record in my list .
New to PowerApps, stuck on the ClearCollect at the start :( I have a dropdown in my DS and I think this might be throwing the error if you could point me in the right direction! Just subbed, videos really helpful for someone starting out :)
Thank you very much. Does it work on Model-driven app as well?
Thank you for a great video! I have a question: How do you reset all field to blank after you submit the form without deleting them from collection? Thank you!
One thing to mention is that for the first two records, because there was no change, nothing was submitted on Genre, so for dropdowns a different approach is required, especially due to the "Select..." value too (resetting the control wouldn't work as it would reset the others too).
Hey Adi.. Yes I noticed that while I was filming the video but glazed over it as I thought nobody would really pick up on what I did and just fix it in their own app :)... You are completely correct you do need to implement a little bit of extra code to get the drop down field 'Genre' (or any drop down field) to work correctly. In this instance, on the Default property of Genre the following code should fix the issue - 'If(IsBlank(ThisItem.crd96_genre),"Select...",ThisItem.crd96_genre)'
@@ChinoDoesStuff Exactly, now your viewers have all they need to start patching records in one go, great video!
All super happy, this will help, only one thing, there are a few fields I need to update, is there no better visual than text boxes, like an excel grid?
Something like this perhaps? ruclips.net/video/Y5G5p84mD84/видео.html
@@ChinoDoesStuff pretty much exactly what I needed, will see if I can add them to a collectiom and patch the collection, else I may get many blank rows if the user gets distracted (i will be addinfmg logic that it only show ñs recirds that user modified and do a somehow recent (likely the need for the collect) but the inspiration is there
HI, Thanks for the video, will the saving process work exactly for SharePoint too???
Yes it will
@@ChinoDoesStuff How can one do this ? I am struggling to figure out how to do this for Sharepoint.
Hi! thank you for this video. Can I use this approach to Update a record that's already in the SharePoint list?
Yes you should be able to loop through records in the same way.
Great Tutorial. I have two questions hope you can advise :)
1. How to make it auto populate to other column once we pick from the drop down list? for example once pick item from column A then automatic populate defined data on Column B and C?
2. I'm on processing to create monthly timesheet, Can you advise once select month and relate to the date on the label?
Sorry for taking so long to get back to you..did you get this working?
@@ChinoDoesStuff Not yet
Hi Chino, Is it possible on clicking plus button not to copy previous data when adding multi lines?
On the Save button portion of the code (the last section) my application is erroring out saying:
'The specified column 'crfde_PartDescription' does not exist. The column with the most similar name is 'Part Description'.'
However, when I try using the 'human readable' name of the field with 'Part Description' (that is what the error suggests) it also doesn't work.
Hi. Thanks for the video.
I got stuck in a problem with the save button.
As the example you show, I also have a date field, that in the Sharepoint List is set as a Date/Time (only date).
I setted On Change = Patch( DataInput; ThisItem; {dt_impact : dtpicker_impact.SelectedDate})
I also tried = Patch( DataInput; ThisItem; {dt_impact : DateValue(dtpicker_impact.SelectedDate)})
But save button has the error like:
The type of this argument does not match the expected type. The expected type is Date and you are using text.
Could you help??
Remove the DateValue() function. :)
@@ChinoDoesStuff
My first try there was no DateValue()
@@marcelomachado254 Did you manage to solve it?
Thanks, really good. Obviously we could add some data validation too. Nice and clean and fast.
Hey Ryan.. glad you liked the video! And yes you are right, some validation in there pretty much would compete the solution :)
Do this still state collections now adays?
Not sure I understand your question
If I have new records and updated records in the collection can I still use the collect collection to the datasource? What would the syntax be?
You definitely need to handle updating exisiting records and adding new records to a collection / data connection differently.
How to proceed with the collections , when there is a lookup field in sharepoint list?
Lookup fields in your output list can complicate things.. Did you get this working?
Great video! :D
But missing the relaxed music I'm used to on this channel ;)
Shut up!!!!! :)
This was a great video!
I have a couple questions.
1-The Patch command clears out the TextInput once it is clicked out. The values are still being collected, but they are not visible in the TextInput. I tried adding the default value to ThisItem.fieldname but it causes a delay when trying to go to the next field. It didn't look like you had this issue in your video. any suggestions?
2- a few of the fields have a default value that I don't want visible. Because the default value doesn't cause a change, the data isn't being Patched. Is there a way that I can still have that patch?
Hi , we can create multiple new records in sharepoint also? I have user requirement where user wants to create more than 1 record using single click of button in powerapps.
Yes should work for saving to SharePoint.lists.
@@ChinoDoesStuff okk. Is there any other way of creating multiple records into sp list. I tried using for all and patch but it creates duplicate copies of same record in my list .
New to PowerApps, stuck on the ClearCollect at the start :(
I have a dropdown in my DS and I think this might be throwing the error if you could point me in the right direction!
Just subbed, videos really helpful for someone starting out :)
Hey Jake.. Did you work out how to get the ClearCollect working?
@@ChinoDoesStuff nope! The error I'm getting is that the drop down column I am trying to use is of an incompatible type.
What's your data source and what is the column type?
@@ChinoDoesStuff It is set up as a dropdown, have tried googling to try and convert it in the code but unsure how!
it is not working on update , what if i want to update the same record ?
Similar...but slightly different method.. Hopefully you worked this out.. The clue is using ForAll() function.