Beginner Tutorial: How to Write Multiple Lines at a Time in Power Apps

Рет қаралды 8,016

Күн бұрын

My name is Andrew Hess and I have been creating Power Apps and Power Platform tutorials. This video sparked from a question in the comments from one of my other videos. How to write multiple lines at a single time to a datasource?
Today we go over using Collect and ForAll statements in 2 different ways to write to our datasource which was SharePoint.
Collect from a Form:
Collect(colMenu,{Title:DataCardValue1.Text,FoodType:DataCardValue2.Text,Allergies:DataCardValue3.Text, Calories:DataCardValue4.Text})
ForAll from a Form Collection:
ForAll(colMenu,Patch(Menu,{Title:Title,FoodType:FoodType,Allergies:Allergies,Calories:Calories}));
Clear(colMenu)
ForAll using a Gallery:
ForAll(Gallery2.AllItems,Patch(Menu,{Title:TextInput1.Text,FoodType:TextInput1_1.Text,Allergies:TextInput1_2.Text,Calories:TextInput1_3.Text}));
Clear(myInput)
Chapters:
0:00 Introduction
1:15 Adding the first Form
2:25 Adding Blank Space in a Form
2:55 New Form Button
4:20 Adding a Gallery
5:20 Creating a Collection in the Memory of the App
6:11 Fixing a Mistake in SharePoint Datasource
7:00 Internal Column Name in SharePoint
8:30 Adding the Collection to the Gallery
11:00 Writing a ForAll Statement
13:15 Using a Gallery to Write Instead
14:05 Creating an Empty Collection
16:45 ForAll Gallery Items
19:05 Conclusion

Пікірлер: 46

@jeanlouisterranova2042 Жыл бұрын

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

@andrewhess123 Жыл бұрын

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!😀

@andrewhess123 11 ай бұрын

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.

@imran002ali 15 күн бұрын

Hi Andrew, great information, appreciate sharing your knowledge. 👍

@andrewhess123 15 күн бұрын

Thank you Imran for still watching! Appreciate you!

@johnbrennan8442 Жыл бұрын

Great video and great timing as usual Andrew.

@andrewhess123 Жыл бұрын

Thank you John for your continual support! Glad it was perfectly timed! 😀

@turisabela Жыл бұрын

Nice video! Really easy to follow along! Well done and thanks for sharing 😊!

@andrewhess123 Жыл бұрын

Thanks so much Isabela! Appreciate it!

@sagaisaac Жыл бұрын

el mejor video que he visto!!! muchas gracias!!

@andrewhess123 Жыл бұрын

gracias!!

@evilmob Жыл бұрын

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!

@andrewhess123 Жыл бұрын

Appreciate it Blak0ut!!! Thanks for watching!

@muratcaglayan9242 Жыл бұрын

You are saying the name correctly, i really appreciate that❤

@andrewhess123 Жыл бұрын

Thanks for watching Murat! And your support!

@user-do6gs1qg7t 4 ай бұрын

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.

@paolovr1970 Жыл бұрын

Thanks

@andrewhess123 Жыл бұрын

Thank you paolovr for watching!

@ilikeshineys 10 ай бұрын

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.

@andrewhess123 10 ай бұрын

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?

@ilikeshineys 10 ай бұрын

@@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!

@kamalakarreddyuppala3772 2 ай бұрын

Hi anderw can you explain add a row into gallery in excel format repeating table in power apps

@linkn0094 7 ай бұрын

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?

@andrewhess123 7 ай бұрын

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..

@SuperBethTastic 7 ай бұрын

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

@franciscobastos893 8 ай бұрын

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

@andrewhess123 8 ай бұрын

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!

@franciscobastos893 8 ай бұрын

@@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 KZfaq 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.

@andrewhess123 8 ай бұрын

Hi Francisco, My newest video is based on your question: kzfaq.info/get/bejne/b7N3ZqZnmKfFhWw.html@@franciscobastos893

@BikeBallers-vlog 10 ай бұрын

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!

@andrewhess123 10 ай бұрын

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 😀

@BikeBallers-vlog 10 ай бұрын

@@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.

@andrewhess123 10 ай бұрын

Thank You Mike!@@BikeBallers-vlog

@andrewhess123 10 ай бұрын

Hi Mike, I made a video on your question! kzfaq.info/get/bejne/pq-iqM-imcmopHk.html&t@@BikeBallers-vlog

@terryhughes1005 7 ай бұрын

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?

@andrewhess123 6 ай бұрын

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.

@user-cp6rm4kr3z 2 ай бұрын

How do you write Attachments in this? Thank you?

@andrewhess123 2 ай бұрын

你好, 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 2 ай бұрын

So you could do combination of Power Apps with Power Automate. Enter data Power Apps, write data with Power Automate

@venkateshu1796 Жыл бұрын

How can we create sub galleries in a form. Like LinkedIn profile

@andrewhess123 Жыл бұрын

Hi Venkatesh, interesting question. Can you explain more? I'm looking at my LinkedIn profile.

@venkateshu1796 Жыл бұрын

@@andrewhess123 for education ,companies details it as sub galleries in LinkedIn employee profile resume

@venkateshu1796 Жыл бұрын

Did u got the question?

@andrewhess123 Жыл бұрын

@@venkateshu1796 Hi Venkatesh, still not sure what you mean by sub galleries in a Form?

@venkateshu1796 Жыл бұрын

@@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.