Creating a Custom Purchase Order App in Power Apps
4.8 هزار بار بازدید -
9 ماه پیش
-
This came from a question
This came from a question from one of you! And that was how to write multiple lines in Power Apps into 1 row into a data source. Our data source in this video was SharePoint because that is freely/easily available to me... But we wrote that one order into a multi-line text field as a HTML table.
Thank you for the questions!
We've successfully generated a purchase order using Power Apps, streamlining a procurement process with its user-friendly and efficient design. This technology empowers us to manage purchases more effectively and maintain better control over our expenditures.
Previous Videos that may be helpful:
Writing Gallery as HTML: Convert a Gallery into an HTML Email ...
Write Multiple Lines at one time: Beginner Tutorial: How to Write Multi...
My name is Andrew Hess, please like & subscribe!
OnVisible:
ClearCollect(colItemOrder,{Item:"zshowbuttonvisible",Description:"",Quantity:0,Price:0})
OnSelect of Save Button:
Clear(colMyGallery);
ForAll(
Gallery1.AllItems,
Collect(
colMyGallery,
{
Item: TextInputCanvas2.Value,
Description: TextInputCanvas2_1.Value,
Quantity: TextInputCanvas2_2.Value,
Price: TextInputCanvas2_3.Value
}
)
);
Remove(
colMyGallery,
Last(colMyGallery)
);
Patch(
Order,
{
ContactPerson: TextInputCanvas1.Value,
Address: TextInputCanvas1_1.Value,
Items: "Youtube will not let me put HTML Here"
DeliveryDate:DatePickerCanvas1.SelectedDate
}
)
0:00 Introduction
1:48 The Setup
2:50 Setting up collection colItemOrder OnVisible
5:08 Creating a button in the last row of Gallery
7:00 Changing to zshowbuttonvisible
10:20 The SharePoint List - 4 columns
11:11 Recollecting our Gallery
12:25 Creating an HTML Table
15:48 Adding the HTML Table to our Patch
16:30 Demonstration
Thank you for the questions!
We've successfully generated a purchase order using Power Apps, streamlining a procurement process with its user-friendly and efficient design. This technology empowers us to manage purchases more effectively and maintain better control over our expenditures.
Previous Videos that may be helpful:
Writing Gallery as HTML: Convert a Gallery into an HTML Email ...
Write Multiple Lines at one time: Beginner Tutorial: How to Write Multi...
My name is Andrew Hess, please like & subscribe!
OnVisible:
ClearCollect(colItemOrder,{Item:"zshowbuttonvisible",Description:"",Quantity:0,Price:0})
OnSelect of Save Button:
Clear(colMyGallery);
ForAll(
Gallery1.AllItems,
Collect(
colMyGallery,
{
Item: TextInputCanvas2.Value,
Description: TextInputCanvas2_1.Value,
Quantity: TextInputCanvas2_2.Value,
Price: TextInputCanvas2_3.Value
}
)
);
Remove(
colMyGallery,
Last(colMyGallery)
);
Patch(
Order,
{
ContactPerson: TextInputCanvas1.Value,
Address: TextInputCanvas1_1.Value,
Items: "Youtube will not let me put HTML Here"
DeliveryDate:DatePickerCanvas1.SelectedDate
}
)
0:00 Introduction
1:48 The Setup
2:50 Setting up collection colItemOrder OnVisible
5:08 Creating a button in the last row of Gallery
7:00 Changing to zshowbuttonvisible
10:20 The SharePoint List - 4 columns
11:11 Recollecting our Gallery
12:25 Creating an HTML Table
15:48 Adding the HTML Table to our Patch
16:30 Demonstration
9 ماه پیش
در تاریخ 1402/08/15 منتشر شده
است.
4,868
بـار بازدید شده