Bulk Add to Excel or SharePoint using Power Apps
Hope everyone had a wonderful Holiday Break! Today we create a form to bulk add multiple line items to SharePoint or Excel. We even use a GUID to fill in our Order Number. Come check it out I'm sure you'll learn a couple new things!
Thanks for watching! This is My SharePoint Questions!
Write to SharePoint:
ForAll(MyOrder,Patch(ItemsSold,{'Customer Name':CustomerName,OrderNumber:OrderNumber,Product:Product,Quantity:Value(Quantity)}));
Clear(MyOrder);
Write to Excel:
ForAll(MyOrder,Patch(ItemsSoldTable,{OrderNumber:OrderNumber,CustomerName:CustomerName,Product:Product,Quantity:Quantity}));
Clear(MyOrder);
Chapters
0:00 Introduction
1:30 Create a GUID Variable
2:53 Create MyOrder Collection
4:48 Demonstrate Collection
5:30 Creating a Gallery for the Collection
6:56 Write to SharePoint
10:15 Demonstrate Write to SharePoint
11:34 Write to Excel
14:45 Demonstrate Write to Excel
15:20 Conclusion