Saw the title and thought, “nah, I won’t learn anything, I have an idea for how to solve for that...” but seeing how you would have solved differently was really helpful!
Hi Shane, your videos have been incredibly helpful in developing my PowerApp knowledge and building my own app. I watched many of your videos and wanted to thank you for your help and expertise! Now in all transparency I'm still watching your videos from 2 years ago but wanted to come by here to thank you.
Cool idea. Filtered galleries could make this solution a pain. Luckily mine was by date so I added a date of "01/01/3000" to ensure it stayed at the bottom. Also, since the collection needed to be sent to Sharepoint, I set the button to first delete that record from the collection, collect to Sharepoint and then re-add that row. Love being inspired by these videos. Thanks Shane
I think you covered it at the back end re data source and patching, My initial thought was it’s trying to patch that last record to the SharePoint list etc. Would a work around be listing the columns to patch rather that the complete collection as a whole ? Bit more coding but at least you could exclude that final ‘buttongoesherecolumn’
Near trick Shane. I would have called it David Copperfield if you do this. The button does appear till the users fill all the fields. Just like SurveyMonkey surveys?? Chew on those thoughts maybe??
I have done it. 😀 What you need to do is have a way to filter the collection for rows that have blanks. If that filter is empty show the button, if not then hide it.
Nice tip! Think you could also get the same result by "borrowing" the form canvas and having the gallery in the top section and the button in a new section below. (I believe I learned that from one of your previous videos and I use it for scrolling sections. It works really well)
Sorry for my confusing post, it was late at night. With the submit button. Could I exclude that field when patching to a SharePoint list? To avoid having a strange column in the list. If still confusing I can explain next online working session 😊
Thanks for all your videos! Very helpful. I have an form where I'm reading data from a sharepoint list, and would then like to email it out to someone, but also add who it got emailed to as a column of the sharepoint list. Any tips?
Good morning Shane, excellent content, thank you very much for sharing all this knowledge, you are a master in the field. I am creating an App but I have a problem with the handling of the data since there are more than 400 operators and more than 300 airport assistance vehicles to which it is necessary to carry out three check lists every day for each one. I would like to share with you my project to see if I am on the right track, I know that with all this knowledge you can give me an idea of how to continue with the development. How can I contact you? . Thank you again very much for sharing all this knowledge.
I think you covered it at the back end re data source and patching, My initial thought was it’s trying to patch that last record to the SharePoint list etc. Would a work around be listing the columns to patch rather that the complete collection as a whole ? Bit more coding but at least you could exclude that final ‘buttongoesherecolumn’
Saw the title and thought, “nah, I won’t learn anything, I have an idea for how to solve for that...” but seeing how you would have solved differently was really helpful!
That is great to hear. Thanks 🐶
Hi Shane, your videos have been incredibly helpful in developing my PowerApp knowledge and building my own app. I watched many of your videos and wanted to thank you for your help and expertise! Now in all transparency I'm still watching your videos from 2 years ago but wanted to come by here to thank you.
Thanks. Very kind. Even all of the 3 and 4 year videos should still be helpful. So enjoy.
Cool idea. Filtered galleries could make this solution a pain. Luckily mine was by date so I added a date of "01/01/3000" to ensure it stayed at the bottom. Also, since the collection needed to be sent to Sharepoint, I set the button to first delete that record from the collection, collect to Sharepoint and then re-add that row. Love being inspired by these videos. Thanks Shane
Awesome Nick! I love to hear how you adapt the ideas. That is the whole beauty.
I think you covered it at the back end re data source and patching,
My initial thought was it’s trying to patch that last record to the SharePoint list etc.
Would a work around be listing the columns to patch rather that the complete collection as a whole ? Bit more coding but at least you could exclude that final ‘buttongoesherecolumn’
Duplicate 😀
Great tricks. So is that how you did for the other input text and drop down in the gallery item??
Learn to build that whole other app here ua-cam.com/video/7XXo9wjnJvc/v-deo.html
Near trick Shane. I would have called it David Copperfield if you do this. The button does appear till the users fill all the fields. Just like SurveyMonkey surveys?? Chew on those thoughts maybe??
I have done it. 😀 What you need to do is have a way to filter the collection for rows that have blanks. If that filter is empty show the button, if not then hide it.
Cool hack Shane! Awesome work.
Thanks 🤩
Thanks Shane, your videos are the best
You are the best Juan! 😀
Nice tip!
Think you could also get the same result by "borrowing" the form canvas and having the gallery in the top section and the button in a new section below. (I believe I learned that from one of your previous videos and I use it for scrolling sections. It works really well)
Nice application Rooney. 🐶
Sorry for my confusing post, it was late at night. With the submit button. Could I exclude that field when patching to a SharePoint list? To avoid having a strange column in the list. If still confusing I can explain next online working session 😊
Yes you can! Use DropColumns to reshape the collection before saving back to SharePoint. 😀
Hi Shen Young I'm getting error: Expecting a Record value instead. What I need to do....
How do we have a button automatically to each item added to the powerapp list in the detail section
Thanks for all your videos! Very helpful. I have an form where I'm reading data from a sharepoint list, and would then like to email it out to someone, but also add who it got emailed to as a column of the sharepoint list. Any tips?
Function to send email then put a semicolon after it and then Patch the data source. This lets you run two formulas by pressing one button.
excellent Shane, another great one :)
Thanks :)
Hey another good one …. Life saver on a project
Awesome Frena! Glad it helped.
Do you have video using Search(Sort(Filter ? at the same browse-gallery? :(
whhhhaaat! That's out the box thinking right there! Thank you.
Thanks 😊
Since Collections have the limit with delegation, any thoughts on how to do this for a gallery that is not using a collection?
Ed I talk about it for a second at the end. In that case you would need to add a bogus record to your data source and then look for that record. 😀
@@ShanesCows Thanks. Sorry a bit too excited there in my commenting and posted 2 seconds before you mentioned that :D
I added a Button in Gallery. OnSelect, I want to navigate screen (value passing from SP List) but it is not working.. can you please help me on this
You would need an If to turn the value in SharePoint into the Screen name. SCreen Names are objects, not strings.
I love these hacks to workaround the missing features!
Thanks Bob
Nice, Simple solution Shane
Thanks. I thought it was a quick win.
Nice Tip, Shane! Thank you👍🏼
You bet!
Good morning Shane, excellent content, thank you very much for sharing all this knowledge, you are a master in the field. I am creating an App but I have a problem with the handling of the data since there are more than 400 operators and more than 300 airport assistance vehicles to which it is necessary to carry out three check lists every day for each one. I would like to share with you my project to see if I am on the right track, I know that with all this knowledge you can give me an idea of how to continue with the development. How can I contact you? . Thank you again very much for sharing all this knowledge.
Hey Julian edit the comment to remove your email. Hit www.PowerApps911.com and fill out the contact form there. 😎
😁👏👏👏👏👏👏 great idea!!! Perfect, thanks for all your videos!
You are so welcome! Have a great day Rico.
What a great solution! Thanks
You bet!
Very cool, thanks!
Happy to help. Have a great day. 🐶
Thx
No problem
Love you!
Thanks! 🥰
👍
🐶
I’m a bit smarter for spending u mins with 👍👍
Awesome hack. Always forget the !visible - Thanks!
Thanks 🙏
I think you covered it at the back end re data source and patching,
My initial thought was it’s trying to patch that last record to the SharePoint list etc.
Would a work around be listing the columns to patch rather that the complete collection as a whole ? Bit more coding but at least you could exclude that final ‘buttongoesherecolumn’
Sam not sure I follow. Sorry. Maybe leave a new comment, not a reply, and I can try to help.