Creating A Completely Custom Form in Power Apps

Опубликовано: 10 Февраль 2025
на канале: Andrew Hess

7,119

In this video we create an autonumber field for our task order ID, using a lookup and adding +1 to our previous TaskOrderID for that project. Then we work on creating a completely custom form in Power Apps. This current custom form is only for creating new line items and not for editing, yet. I will get to that in another video, but for now we are just creating a form to write new line items. We are not setting all the defaults of our fields until we decide how we will edit.

Part 4: Changing Order of Gallery:    • Editable Task List with Progress Bar ...
Part 3: Creating Project Center:    • Let's Create a Project Dashboard in P...
Part 2: Defaulting Content Types:    • Power Apps with Content Types and set...
Part 1: Content Types:    • Creating 2 Forms with 1 List in Share...

Autonumbering formula: LookUp(Sort(ProjectTasksList,TaskOrderID,Descending),ProjectID = galProjects.Selected.ID,TaskOrderID+1)

Patch Statement:
Patch(
ProjectTasksList,
{
ProjectID: Value(txtProjectID.Text),
TaskOrderID: Value(txtTaskOrderID.Text),
Title: txtProjectTitle.Text,
Priority: txtPriority.Text,
'% Complete': Value('txt%Complete'.Text),
Cost: Value(txtCost.Text),
'Actual Cost':Value(txtActualCost.Text),
Risk:drpRisk.Selected.Value,
TaskStatus:drpTaskStatus.Selected.Value,
TaskType:drpTaskType.Selected.Value,
StartDate:dteStartDate.SelectedDate,
EndDate:dteEndDate.SelectedDate,
Comment:txtComment.HtmlText

}
)

Chapters:
0:00 Introduction
1:44 Autonumbering Task Order ID
5:56 Using a Submit Form or a Custom Form
7:12 Changing a field in a Submit Form
8:50 Creating a Custom Form
17:03 Formula to Save Custom Form using Patch()
21:23 Conclusion