Hi Andrew, very interesting and valuable video as usual. However I have a remark regarding the use of For all while patching the data to the sharepoint list. Indeed I watched a video from another Power apps expert and he explained how to directly patch a collection to a sharepoint list. basically what he does is to patch a collection specifying the ID in the clear collect function and the other fields to be patched. He does not use the For All function at all. What do you think ? Patrick
Hi Jeanlouis, I think both ways are possible, and both ways are good. It's still beneficial to know the ForAll, in case there is a reason to loop through again, maybe a count = count + 1, or some sort of math, although it can still be done and put into the collection and then patch the entire collection after the math. All depends on the requirements and the app. Usually in my videos, I try to give ideas, instead of telling someone exactly what to do. A lot of times I try to give alternate ideas compared to the other Power Apps experts, bc they are great: like Shane, Reza, Daniel, Matthew, and Darren. I watch them all too, don't wanna copy them 😜 Thanks for sharing though, Hopefully others will see your comment and be able to decide the best way forward for their app!😀
Hi Jeanlouis, I was just doing a ForAll again, and one main reason to use the ForAll Collect or ForAll Patch, is so you don''t have to collect or use all the columns. Sometimes you want to only do a few columns. This was a huge reason I use the ForAll Collect or ForAll Patch.
This is awesome! I was just recently thinking about how I can do something similar for requesting items to be purchased for a specific project. This helps thinking about that process. Thanks!
Hi Andrew, Thanks for your video! I’m working on a similar project, creating a 'sign-in form' Power App for guests, contractors, or groups of people visiting my company. The data is stored in a SharePoint list with the following structure: Company Name | Name of Employee | Signature | Date Each sign-in form accommodates 10-12 rows of data, with each form submission stored as a single record in the SharePoint list. I’m also planning to create another Power App solely for viewing or deleting records, using a gallery and an edit form. However, I’m struggling with differentiating between records, given that all sign-in details are stored vertically within these four columns. How should I structure the data to keep each form submission as a distinct, identifiable record?
Hi yy, your rows should have a unique ID in SharePoint, normally it is hidden. Would this give you the distinct, identifiable record you are looking for? You could also make a calculated field in SharePoint, Concat([Name],Text([Date])), something like that?
HI Andrew, great video! I am struggling to to get the forall function working with choice and Date & Time columns? I cant input the choice columns without getting an error and the time's input are not carrying over to SP. Hoping you can provide a resolution.
Hey thereveredbeard, A lot of times I do not make choice fields in SharePoint, but make them dropdowns in Power App, so it's just easy to write it as a text but choices are still seen on the Power Apps side. Date & Time should work just the same, but what is the error you are receiving?
@@andrewhess123 apologies, wondered off and got an answer to the date and time issue. I was only receiving the date and not the time in the collection. I like the idea of making the drop down fields only on PowerApps and not on SP. Thanks for the idea, a massive help!
Dear Andrew, I'm Brazilian and I saw your video, it has almost exactly what I need to put together a solution in my work. My question, based on your example in the video: Would it be possible to write the four cells of the filled line in a single column in SharePoint? As if it were a purchase order, where the user places all the desired products and quantities and all the order information is in table format, occupying just one line in Sharepoint
Hi Francisco, Brazil is a beautiful country I hope to visit some day. Yes it sounds totally possible to combine 4 cells into 1 single column of SharePoint. You could concat them with a comma, and then split them back up by the comma in the app. Sounds totally possible! Would be an idea for a video too. Thank you!
@@andrewhess123 Thank you very much for your feedback Andrew! Man, if you made a video of this content it would be perfect. I've been looking for this on TH-cam for months, but without success. I've looked at Indian, Spanish and other nationality channels, but none of them offer this topic. It would be wonderful to be able to see this here.
Hi Andrew, I really like the last part of your video on how you use the gallery as a form. How do you make it a required field and disable the write-to-data source button if the required field is blank with this method?
Hi linkn, so on the button to submit you make the DisplayMode Disabled until all the fields you want are filled out. So most likely an if statement on the Save/Submit button..
For the empty collection grid, is there a way to add in a copy button? I've tried adding in, but even if it set the columns to copy ThisItem, it still comes up blank
Hi Andrew, very informative video. thank you so for sharing it. 😍 I have a simple question, how we can send email from collect (myInput) data's as html? Appreciate your feedback. God bless!
Hi Mike, this sounds possible, What you would do is Create a New Collection of the Gallery that has (MyInput) and the underlying data in the gallery then you can use HTML to show the data correctly in an email. It's harder to explain in this short message, a video would be more helpful 😀
@@andrewhess123 I wait for you video then 🥰 for me to understand 😍. Thank you for giving a time reading and replying to my comments. Actually most of your video’s are easy to understand the way you presented. Thank you once again for helping us audience.
How do you create a checksum that counts the number of items the user inputted, then after patching, counts how many actually wrote to the table and keeps any errors in the gallery for further editing?
Hi Terry, does that mean sometimes it doesn't write? What is causing the patch to fail? It would be difficult to count the ones that actually wrote, depending on how large the table was to begin with. Due to delegation issues, unless you are using Dataverse or SQL or some real database.
Hi Andrew, very helpful is this, I have a kind request, I am facing an issue, i have created an App for procurement, with multi approval stages with the help power automate, you know in procurement we request multiple items at once, but in my form i have only one item option, can you please create a video on this that how i can create multi items form, like quotation, invoice etc, and then how to send in approval. Thanks I hope will understand.
For a collection you can use the Last command since it's delegable: Remove(MyCollection, Last(MyCollection)) learn.microsoft.com/en-us/power-platform/power-fx/reference/function-first-last
你好, If I wanted to do this with attachments most likely I would do with Power Automate. Power Automate could loop through each line and add attachment.
@@andrewhess123 iam looking to create employee profile similar like LinkedIn .when we want to add additional 2 to 3 company details in next line .in single list form it not possible right? That's why I asked whether they created it as a sub gallery?.can u go to your linkedin profile and click the edit button You can understand what I am asking.
Hi Andrew, very interesting and valuable video as usual. However I have a remark regarding the use of For all while patching the data to the sharepoint list. Indeed I watched a video from another Power apps expert and he explained how to directly patch a collection to a sharepoint list. basically what he does is to patch a collection specifying the ID in the clear collect function and the other fields to be patched. He does not use the For All function at all. What do you think ? Patrick
Hi Jeanlouis, I think both ways are possible, and both ways are good. It's still beneficial to know the ForAll, in case there is a reason to loop through again, maybe a count = count + 1, or some sort of math, although it can still be done and put into the collection and then patch the entire collection after the math. All depends on the requirements and the app.
Usually in my videos, I try to give ideas, instead of telling someone exactly what to do. A lot of times I try to give alternate ideas compared to the other Power Apps experts, bc they are great: like Shane, Reza, Daniel, Matthew, and Darren. I watch them all too, don't wanna copy them 😜
Thanks for sharing though, Hopefully others will see your comment and be able to decide the best way forward for their app!😀
Hi Jeanlouis, I was just doing a ForAll again, and one main reason to use the ForAll Collect or ForAll Patch, is so you don''t have to collect or use all the columns. Sometimes you want to only do a few columns. This was a huge reason I use the ForAll Collect or ForAll Patch.
Great video and great timing as usual Andrew.
Thank you John for your continual support! Glad it was perfectly timed! 😀
You are saying the name correctly, i really appreciate that❤
Thanks for watching Murat! And your support!
el mejor video que he visto!!! muchas gracias!!
gracias!!
Nice video! Really easy to follow along! Well done and thanks for sharing 😊!
Thanks so much Isabela! Appreciate it!
This is awesome! I was just recently thinking about how I can do something similar for requesting items to be purchased for a specific project. This helps thinking about that process. Thanks!
Appreciate it Blak0ut!!! Thanks for watching!
Hi Andrew, great information, appreciate sharing your knowledge. 👍
Thank you Imran for still watching! Appreciate you!
Hi Andrew,
Thanks for your video! I’m working on a similar project, creating a 'sign-in form' Power App for guests, contractors, or groups of people visiting my company. The data is stored in a SharePoint list with the following structure:
Company Name | Name of Employee | Signature | Date
Each sign-in form accommodates 10-12 rows of data, with each form submission stored as a single record in the SharePoint list.
I’m also planning to create another Power App solely for viewing or deleting records, using a gallery and an edit form. However, I’m struggling with differentiating between records, given that all sign-in details are stored vertically within these four columns. How should I structure the data to keep each form submission as a distinct, identifiable record?
Hi yy, your rows should have a unique ID in SharePoint, normally it is hidden. Would this give you the distinct, identifiable record you are looking for? You could also make a calculated field in SharePoint, Concat([Name],Text([Date])), something like that?
HI Andrew, great video! I am struggling to to get the forall function working with choice and Date & Time columns? I cant input the choice columns without getting an error and the time's input are not carrying over to SP. Hoping you can provide a resolution.
Hey thereveredbeard, A lot of times I do not make choice fields in SharePoint, but make them dropdowns in Power App, so it's just easy to write it as a text but choices are still seen on the Power Apps side. Date & Time should work just the same, but what is the error you are receiving?
@@andrewhess123 apologies, wondered off and got an answer to the date and time issue. I was only receiving the date and not the time in the collection. I like the idea of making the drop down fields only on PowerApps and not on SP. Thanks for the idea, a massive help!
Dear Andrew,
I'm Brazilian and I saw your video, it has almost exactly what I need to put together a solution in my work. My question, based on your example in the video: Would it be possible to write the four cells of the filled line in a single column in SharePoint? As if it were a purchase order, where the user places all the desired products and quantities and all the order information is in table format, occupying just one line in Sharepoint
Hi Francisco, Brazil is a beautiful country I hope to visit some day. Yes it sounds totally possible to combine 4 cells into 1 single column of SharePoint. You could concat them with a comma, and then split them back up by the comma in the app. Sounds totally possible! Would be an idea for a video too. Thank you!
@@andrewhess123 Thank you very much for your feedback Andrew! Man, if you made a video of this content it would be perfect. I've been looking for this on TH-cam for months, but without success. I've looked at Indian, Spanish and other nationality channels, but none of them offer this topic. It would be wonderful to be able to see this here.
Hi Francisco, My newest video is based on your question: th-cam.com/video/9MG3C63AaU8/w-d-xo.html@@franciscobastos893
Hi Andrew, I really like the last part of your video on how you use the gallery as a form. How do you make it a required field and disable the write-to-data source button if the required field is blank with this method?
Hi linkn, so on the button to submit you make the DisplayMode Disabled until all the fields you want are filled out. So most likely an if statement on the Save/Submit button..
For the empty collection grid, is there a way to add in a copy button? I've tried adding in, but even if it set the columns to copy ThisItem, it still comes up blank
Hi Andrew, very informative video. thank you so for sharing it. 😍 I have a simple question, how we can send email from collect (myInput) data's as html? Appreciate your feedback. God bless!
Hi Mike, this sounds possible, What you would do is Create a New Collection of the Gallery that has (MyInput) and the underlying data in the gallery then you can use HTML to show the data correctly in an email. It's harder to explain in this short message, a video would be more helpful 😀
@@andrewhess123 I wait for you video then 🥰 for me to understand 😍. Thank you for giving a time reading and replying to my comments. Actually most of your video’s are easy to understand the way you presented. Thank you once again for helping us audience.
Thank You Mike!@@BikeBallers-vlog
Hi Mike, I made a video on your question! th-cam.com/video/pIrulq4cDtE/w-d-xo.html&t@@BikeBallers-vlog
How do you create a checksum that counts the number of items the user inputted, then after patching, counts how many actually wrote to the table and keeps any errors in the gallery for further editing?
Hi Terry, does that mean sometimes it doesn't write? What is causing the patch to fail? It would be difficult to count the ones that actually wrote, depending on how large the table was to begin with. Due to delegation issues, unless you are using Dataverse or SQL or some real database.
Hi Andrew, very helpful is this, I have a kind request, I am facing an issue, i have created an App for procurement, with multi approval stages with the help power automate, you know in procurement we request multiple items at once, but in my form i have only one item option, can you please create a video on this that how i can create multi items form, like quotation, invoice etc, and then how to send in approval. Thanks I hope will understand.
Hi anderw can you explain add a row into gallery in excel format repeating table in power apps
How do I delete the last row of my collection in power apps🤔
For a collection you can use the Last command since it's delegable: Remove(MyCollection, Last(MyCollection))
learn.microsoft.com/en-us/power-platform/power-fx/reference/function-first-last
Are you the best 😃
@@javieraopazo9459 Haha nope! There are people better than me 😆
How do you write Attachments in this? Thank you?
你好, If I wanted to do this with attachments most likely I would do with Power Automate. Power Automate could loop through each line and add attachment.
So you could do combination of Power Apps with Power Automate. Enter data Power Apps, write data with Power Automate
How can we create sub galleries in a form. Like LinkedIn profile
Hi Venkatesh, interesting question. Can you explain more? I'm looking at my LinkedIn profile.
@@andrewhess123 for education ,companies details it as sub galleries in LinkedIn employee profile resume
Did u got the question?
@@Hitesh222-c7n Hi Venkatesh, still not sure what you mean by sub galleries in a Form?
@@andrewhess123 iam looking to create employee profile similar like LinkedIn .when we want to add additional 2 to 3 company details in next line .in single list form it not possible right? That's why I asked whether they created it as a sub gallery?.can u go to your linkedin profile and click the edit button You can understand what I am asking.
Thanks
Thank you paolovr for watching!