Тёмный

PowerApps Bulk Save to SharePoint List Demo 

KeaPoint Tech Tips
Подписаться 10 тыс.
Просмотров 31 тыс.
50% 1

In this step-by-step tutorial video, I walk through how to save data in bulk to SharePoint List using PowerApps Collection.
You can use a collection to store data that users can manage in their PowerApps. A collection is a group of items that are similar, such as products in a product list. In this example I will create a blank canvas app, I will then create a form which will be used to collect data. On button click the forms data will be added to a collection, I will then implement the bulk operation on all the records in a collection and save them to a SharePoint list. In short, I will save PowerApps collection to SharePoint list.
★ TABLE OF CONTENTS ★
• 00:00 Intro
• 01:28 How to Create a Canvas App in PowerApps
• 04:32 PowerApps How to Add Data to Collection
• 10:01 PowerApps Bulk Save to SharePoint List
• 14:34 Outro & Subscribe
🔴 ** BE OUR FRIEND **
✅ Website: www.keapoint.com
✅ LinkedIn: h / 18782324
✅ Twitter: / kea_point
✅ Facebook: / keapointuk
🔎 HASHTAGS 🔎
#PowerApps
#PowerAppsCollection
#PowerAppsSharePoint

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

 

8 июл 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 59   
@AlvinRyellPrada
@AlvinRyellPrada 3 года назад
This is really good. I am having a look at all your tutorials now. Straight to the point and you really walked me thru from beginning til the end. Please do more power automate and power apps innovations for beginners :)
@KeaPointTechTips
@KeaPointTechTips 3 года назад
Thanks for your kind feedback.
@denilsonmucavel8150
@denilsonmucavel8150 Год назад
Thank you man its all working🙃
@sarank75
@sarank75 2 года назад
this is an awesome video is more helpful
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Glad it was helpful to you!
@jpremium5478
@jpremium5478 Год назад
Your video answered by project requirements. Thank you!
@KeaPointTechTips
@KeaPointTechTips Год назад
Glad I could help!
@TakahiroHanawa
@TakahiroHanawa 3 года назад
This is really what I want to do on my app. Great! Thank you.
@KeaPointTechTips
@KeaPointTechTips 3 года назад
Glad it was helpful!
@eduardschnebel1835
@eduardschnebel1835 2 года назад
Thank you so much for your great explanations and your great videos!!! They have really helped me 👍🏼
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Thanks for your kind words.
@eduardschnebel1835
@eduardschnebel1835 2 года назад
@@KeaPointTechTips Hey :) its me again. Is it possible to collect a Image to a collection and patch it afterwards to a SharePoint-List? If so could you give me a hint how? Thx in advance ;)!
@hardlifting150
@hardlifting150 2 года назад
Wow this is super and ideal for my immediate need. Thanks so much.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
You are welcome, Steve!
@guerreirodancante
@guerreirodancante 2 года назад
Awesome video!!!
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Thanks for the visit
@jray1429
@jray1429 2 года назад
Thank you, great job
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Thanks for watching!
@aashritsrhymeandactivities4911
@aashritsrhymeandactivities4911 2 года назад
This is really good and easy.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Thanks.
@MrKhulaid
@MrKhulaid 2 года назад
Very Very helpful video.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Glad it was helpful!
@aamerkhan9699
@aamerkhan9699 Месяц назад
Awesome 😊
@KeaPointTechTips
@KeaPointTechTips 29 дней назад
Thank you! Cheers!
@jayashreevasudevan3641
@jayashreevasudevan3641 2 года назад
Hi, Thanks much this is sooper useful.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Glad it was helpful 😀
@singhprabhat90
@singhprabhat90 Год назад
Very helpful! Just wondering how would you do it if you there are multiple rows of data for the 3 columns you've shown. Also, can we club two collections together with completely different columns in both the collections?
@KeaPointTechTips
@KeaPointTechTips Год назад
Club two collections is possible but the data won't be normalised.
@ashvinraval7265
@ashvinraval7265 2 года назад
This is really a very good video. very good explanation. Just want to know like once we add data to collection how to clear single selected item rather than clearing all items.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
When you will select a different record, it will override the selection. You don't need to clear the selected record.
@VijayKumar-cd9bh
@VijayKumar-cd9bh 2 года назад
Thank you for this wonderful explanation. Is there a way to copy data from clipboard inti collection? There are multiple users who will make data entry in bulk (both add and edit bulk rows) and I need to get all the changes into SharePoint list.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
You can use collection to temporarily store data and then can process the collection to SharePoint list
@adilaishak1476
@adilaishak1476 9 месяцев назад
Hi, just started learning Powerapps couple of days ago, I'm wondering what data type should I use if I'm using column with multiple line text and column that contains people profile from sharepoint list?
@josemag4617
@josemag4617 3 года назад
I took some ideas. Thank you! I am dealing with a 2-branch approval process, but I need to add to it, the ability to go back in each branch if one of them rejects the document and requests changes. Do you know how I can do that? It seems that the same solution can be done in both branches, so it can be considered as 1-branch approval process. Regards!
@KeaPointTechTips
@KeaPointTechTips 3 года назад
Hi Jose You can use Power automate switch control to create multiple approval branches and depending on the outcome, you can easily switch between the branches. This video of mine will give you some ideas on how you can implement it for document approval. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Xe-nvaXekRw.html
@sanzocgaming6579
@sanzocgaming6579 2 года назад
Thanks for the video and I wanted add a validation with the Collect function to check if all the required data filled by the user. Can you help me on this pls?.
@KeaPointTechTips
@KeaPointTechTips 2 года назад
You probably need to do that while filling the data and disable save button if required info is not filled in. This will be more clean approach.
@muru4541
@muru4541 3 года назад
Good one... Can you help with this What if I want my user to delete the saved SharePoint record from Power apps
@KeaPointTechTips
@KeaPointTechTips 3 года назад
You can get SharePoint list record in a gallery view and can implement edit or delete button with logic easily.
@ducatiteam
@ducatiteam 2 года назад
A very helpful instruction :) Well done! How can I add photo and other file as attachments to the SharePoint list?
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Glad it was helpful! Are you looking to save attachments to SharePoint list via the PowerApps?
@ducatiteam
@ducatiteam 2 года назад
@@KeaPointTechTips Yes, I am looking for exactly this solution (without using flow)
@KeaPointTechTips
@KeaPointTechTips 2 года назад
try this article powerapps.microsoft.com/en-us/blog/add-attachments-to-sharepoint-lists/
@mdiwakarmba
@mdiwakarmba 3 года назад
Just for an understanding, if we need to link the data to sharepoint -- without creating the connection in power app can we link it to sharepoint? If yes, could you please let me know the formula? If i use Patch i am getting error message.
@KeaPointTechTips
@KeaPointTechTips 3 года назад
You will have to connect SharePoint list to PowerApps before you can patch records to it. The question is why you don't want to connect list with the PowerApps?
@mrwhammer
@mrwhammer Год назад
So my question is how do they access that power apps page in the first page. Right now i have a sharepoint list, and i want that user to access the page list of items in power apps but when you are on the sharepoint list, it doesnt lead me directly to the item but instead the list i created which is the screen. So it wouldnt make sense for me to click on an item in a sharepoint list, and then it would show me the list of items in the sharepoint list instead of the items itself. If that was resolved, then how would a user get access to the power apps list instead? Would they need a specific link to get to it?
@singhprabhat90
@singhprabhat90 Год назад
I tried and it worked, partially. When I'm adding the column values to the collection, it's showing the value in the table but in diagonal manner. For eg the first item title value is book. In my case, the color blue shows up diagonally and the date 15 02 shows up diagonally as well. Due to this, I'm able to add more values to collection but those don't show up
@KeaPointTechTips
@KeaPointTechTips Год назад
Did you figure it out?
@singhprabhat90
@singhprabhat90 Год назад
@@KeaPointTechTips I did manage to fix it eventually. Thanks!
@adilaishak1476
@adilaishak1476 9 месяцев назад
Hi there, I'm receiving errors in columns that have Person or Groups data type. There are also errors in columns which I allowed multiple selections. Can you help me with this?
@dankanezuu
@dankanezuu Год назад
how can i make a button to create a collection? thx
@olivaadak
@olivaadak 3 года назад
In My List of SharePoint I am having a Primary field and some connected fields with other List. so can You please give me a idea how to connect that table?
@KeaPointTechTips
@KeaPointTechTips 3 года назад
Hi Oliva, you can use lookup columns in SharePoint to connect tables (Lists).
@olivaadak
@olivaadak 3 года назад
@@KeaPointTechTips yes I am using that only. But in power apps for the ForAll function there are some errors. Like patch fucntion having invalid argument. Thank you for the reply
@olivaadak
@olivaadak 3 года назад
ForAll( ProjectUserCollection, Patch(ProjectUser, Defaults(ProjectUser ), {ProjectID: Project_ID, UserID: User_ID, RoleID: Role_ID, AssignmentStartDate: AssignmentStart_Date, IsActive: Is_Active, Title: Comments_IFAny})) this is my function but its giving errors.
@KeaPointTechTips
@KeaPointTechTips 3 года назад
You need to patch lookup Id and value for lookup columns. See this example. matthewdevaney.com/power-apps-patch-function-examples-for-every-sharepoint-column-type/patch-a-sharepoint-lookup-column-in-power-apps/
@vishaljhaveri7565
@vishaljhaveri7565 2 года назад
@@olivaadak Hello Oliva, I got many errors while performing patching ie. this same step. How did you resolve these errors. Can you please reply and help me out on the same?
@vishaljhaveri7565
@vishaljhaveri7565 2 года назад
The Patch function won't work for me. Showinng multiple errors in Power Apps..
@KeaPointTechTips
@KeaPointTechTips 2 года назад
Not sure why it is not working for you. Make sure you follow the steps.
Далее
Редакция. News: 124-я неделя
52:01
Просмотров 1,8 млн
100❤️
00:19
Просмотров 2,9 млн
How to Use the NEW Forms Experience in Microsoft Lists
16:28
The One MISTAKE Everyone is Making with SharePoint
6:21