Тёмный

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

Andrew Hess - MySPQuestions
Подписаться 8 тыс.
Просмотров 8 тыс.
50% 1

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

Опубликовано:

 

21 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 46   
@jeanlouisterranova2042
@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
@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
@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
@imran002ali 11 дней назад
Hi Andrew, great information, appreciate sharing your knowledge. 👍
@andrewhess123
@andrewhess123 11 дней назад
Thank you Imran for still watching! Appreciate you!
@johnbrennan8442
@johnbrennan8442 Год назад
Great video and great timing as usual Andrew.
@andrewhess123
@andrewhess123 Год назад
Thank you John for your continual support! Glad it was perfectly timed! 😀
@turisabela
@turisabela Год назад
Nice video! Really easy to follow along! Well done and thanks for sharing 😊!
@andrewhess123
@andrewhess123 Год назад
Thanks so much Isabela! Appreciate it!
@evilmob
@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
@andrewhess123 Год назад
Appreciate it Blak0ut!!! Thanks for watching!
@sagaisaac
@sagaisaac Год назад
el mejor video que he visto!!! muchas gracias!!
@andrewhess123
@andrewhess123 Год назад
gracias!!
@muratcaglayan9242
@muratcaglayan9242 Год назад
You are saying the name correctly, i really appreciate that❤
@andrewhess123
@andrewhess123 Год назад
Thanks for watching Murat! And your support!
@user-do6gs1qg7t
@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.
@linkn0094
@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
@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..
@franciscobastos893
@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
@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
@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 RU-vid 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
@andrewhess123 8 месяцев назад
Hi Francisco, My newest video is based on your question: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9MG3C63AaU8.html@@franciscobastos893
@SuperBethTastic
@SuperBethTastic 6 месяцев назад
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
@BikeBallers-vlog
@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
@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
@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
@andrewhess123 10 месяцев назад
Thank You Mike!@@BikeBallers-vlog
@andrewhess123
@andrewhess123 10 месяцев назад
Hi Mike, I made a video on your question! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-pIrulq4cDtE.html&t@@BikeBallers-vlog
@ilikeshineys
@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
@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
@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
@kamalakarreddyuppala3772 2 месяца назад
Hi anderw can you explain add a row into gallery in excel format repeating table in power apps
@paolovr1970
@paolovr1970 Год назад
Thanks
@andrewhess123
@andrewhess123 Год назад
Thank you paolovr for watching!
@terryhughes1005
@terryhughes1005 6 месяцев назад
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
@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
@user-cp6rm4kr3z 2 месяца назад
How do you write Attachments in this? Thank you?
@andrewhess123
@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
@andrewhess123 2 месяца назад
So you could do combination of Power Apps with Power Automate. Enter data Power Apps, write data with Power Automate
@venkateshu1796
@venkateshu1796 Год назад
How can we create sub galleries in a form. Like LinkedIn profile
@andrewhess123
@andrewhess123 Год назад
Hi Venkatesh, interesting question. Can you explain more? I'm looking at my LinkedIn profile.
@venkateshu1796
@venkateshu1796 Год назад
@@andrewhess123 for education ,companies details it as sub galleries in LinkedIn employee profile resume
@venkateshu1796
@venkateshu1796 Год назад
Did u got the question?
@andrewhess123
@andrewhess123 Год назад
@@venkateshu1796 Hi Venkatesh, still not sure what you mean by sub galleries in a Form?
@venkateshu1796
@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.
Далее
Power Apps Barcode Scanner For Inventory Records
8:06
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Creating an Edit Form and Fixing Defaults in Power Apps
25:51
Saving Power Apps Data with the Patch Function
17:59
Просмотров 51 тыс.
Power Apps Editable Table
20:42
Просмотров 132 тыс.
Dynamic Repeating Combo boxes in Power Apps
26:12
Просмотров 2,4 тыс.