기존에 아래 참고자료에 보면 사원번호 규칙을 만들고 생성하는 과정을 만들었다.
문제는 번호를 기존 번호에 추가하는 형식으로 하다보니 고유값 규칙이 손상되는 문제가 되는 것을 확인 하였다.
기존 사원번호 만들었을 때 오류 내용 :
올해 입사한 직원이 퇴사하였다. 신규 직원이 입사 하였을 때 기존 직원의 사원번호가 부여되게 되는 문제.
보다 간단하게 만드는 방법과 고유 값을 설정할 수 있는 방법에 대하여 고민하게 되었고 이를 수정한 방법이다.
고유 값을 만드는 것은 SharePoint Lists 의 ID 값을 활용하는 것으로 하였다.
🆔 SharePoint ID 필드 정의
항목설명
| 이름 | ID (시스템에서 자동 생성됨) |
| 유형 | 정수(Number, Integer) |
| 고유성 | 항목마다 자동으로 1씩 증가, 중복 불가, 수정 불가 |
| 용도 | 각 항목의 기본 식별자로 사용됨 (SQL의 기본키 역할) |
| 생성 시점 | 항목이 SharePoint 리스트에 저장된 후 자동 생성됨 |
| 삭제 시 특성 | 삭제된 ID는 재사용되지 않음 (예: 1,2,4 → 3은 영원히 비어 있음) |
여기서 문제는 Form으로 값을 저장하면 아직 값이 생성된 것이 아니어서 ID는 만들어 지지 않게 된다.
이 경우 Form으로 값을 생성 하고 생성한 값을 업데이트 형식으로 값을 추가해야 한다.
구성 항목 설명 예시 값 구현 방법 (PowerApps 기준)
| 접두어 | E- | E- | 문자열 상수 "E-" 사용 |
| 입사년도 | 입사한 연도 4자리 | 2025 | Text(Today(), "yyyy") 또는 사용자 입력값 사용 |
| 고유번호 | SharePoint의 ID 필드를 5자리로 변환 | 00023 | Text(ThisItem.ID, "00000") |
| 최종 사번 | 모든 항목을 결합한 고유 사번 | E-202500023 | "E-" & Text(Today(), "yyyy") & Text(ThisItem.ID, "00000") |
1: SharePoint ID 값 - 고유 값
2. 저장 버튼을 눌렀을 때
NewForm인 경우 내용을 저장 후 사번 추가
EditForm의 경우 내용 변경 후 저장 가능 (사번 수정 가능)
If(
Form_Employee.Mode = FormMode.New, // 폼이 새 항목(NewForm) 입력 중인 경우
// 새 항목 제출
SubmitForm(Form_Employee);
// 제출된 레코드를 변수 createdRecord에 저장한 뒤, EmpNo 필드 추가 업데이트
With(
{createdRecord : Form_Employee.LastSubmit}, // 방금 생성된 레코드 참조
Patch(
'OrgEmployee-Dev', // 대상 SharePoint 리스트
createdRecord, // 방금 생성된 레코드를 대상으로
{
// 사번: E-연도+ID (예: E-2025-00023)
EmpNo: "E-" & Text(Today(), "yyyy") & Text(createdRecord.ID, "00000")
}
)
),
// EditForm인 경우 단순히 수정된 폼 제출
SubmitForm(Form_Employee)
)
3. 갤러리에서 선택된 사번 확인
4. 사번 전체 업데이트를 위해 값을 입사일 기준으로 변경
If(
IsBlank(ThisItem.JoinDate), // JoinDate가 비어 있는 경우
"E-" & Text(Today(), "yyyy") & Text(ThisItem.ID, "00000"), // 현재 연도를 사용해 사번 생성
"E-" & Text(ThisItem.JoinDate, "yyyy") & Text(ThisItem.ID, "00000") // JoinDate의 연도를 사용해 사번 생성
)
5. EmpNo 값을 갤러리의 값으로 한꺼번에 업데이트
ForAll(
gal_Employee.AllItems, // 갤러리(gal_Employee)의 모든 항목에 대해 반복 실행
Patch(
'OrgEmployee-Dev', // SharePoint 리스트 'OrgEmployee-Dev'에 값을 업데이트
ThisRecord, // 현재 반복 중인 갤러리 항목을 대상으로 사용 (ID 기반 매핑 생략 가능)
{
EmpNo: lbl_EmpNo.Text // 갤러리 항목 내의 레이블(lbl_EmpNo)의 텍스트 값을 EmpNo 필드에 저장
}
)
)
[전체코드]
Screens:
EmployeeNo:
Properties:
Fill: =RGBA(255, 255, 255, 1)
LoadingSpinnerColor: =RGBA(0, 120, 212, 1)
Children:
- gal_Employee:
Control: Gallery@2.15.0
Variant: BrowseLayout_Vertical_TwoTextVariant_ver5.0
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
Fill: =RGBA(236, 236, 235, 1)
Height: =598
Items: ='OrgEmployee-Dev'
OnSelect: =EditForm(Form_Employee);
Width: =364
X: =160
Y: =80
Children:
- Title5:
Control: Label@2.5.1
Properties:
BorderColor: =RGBA(0, 0, 0, 1)
Color: =RGBA(50, 49, 48, 1)
DisabledColor: =RGBA(161, 159, 157, 1)
Font: =Font.'Segoe UI'
FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)
Height: =Self.Size * 1.8
OnSelect: =Select(Parent)
PaddingBottom: =0
PaddingLeft: =12
PaddingRight: =0
PaddingTop: =0
Size: =14
Text: =ThisItem.Name
VerticalAlign: =VerticalAlign.Top
Width: =Parent.TemplateWidth - 86
X: =16
Y: =(Parent.TemplateHeight - (Self.Size * 1.8 + Subtitle5.Size * 1.8)) / 2
- Subtitle5:
Control: Label@2.5.1
Properties:
BorderColor: =RGBA(0, 0, 0, 1)
Color: =RGBA(96, 94, 92, 1)
DisabledColor: =RGBA(161, 159, 157, 1)
Font: =Font.'Segoe UI'
FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)
Height: =23
OnSelect: =Select(Parent)
PaddingBottom: =0
PaddingLeft: =12
PaddingRight: =0
PaddingTop: =0
Size: =12
Text: |-
="ID : " &ThisItem.ID
VerticalAlign: =VerticalAlign.Top
Width: =133
X: =28
Y: =52
- Separator5:
Control: Rectangle@2.3.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
Fill: =RGBA(255, 255, 255, 1)
Height: =8
OnSelect: =Select(Parent)
Width: =Parent.TemplateWidth
Y: =Parent.TemplateHeight - Self.Height
- Rectangle5:
Control: Rectangle@2.3.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
Fill: =RGBA(0, 120, 212, 1)
Height: =Parent.TemplateHeight - Separator5.Height
OnSelect: =Select(Parent)
Visible: =ThisItem.IsSelected
Width: =4
- lbl_EmpNo:
Control: Label@2.5.1
Properties:
BorderColor: =RGBA(0, 0, 0, 1)
Color: =RGBA(96, 94, 92, 1)
DisabledColor: =RGBA(161, 159, 157, 1)
Font: =Font.'Segoe UI'
FontWeight: =If(ThisItem.IsSelected, FontWeight.Semibold, FontWeight.Normal)
Height: =26
OnSelect: =Select(Parent)
PaddingBottom: =0
PaddingLeft: =12
PaddingRight: =0
PaddingTop: =0
Size: =12
Text: |-
=//"사번 : " & ThisItem.EmpNo
If(IsBlank(ThisItem.JoinDate),"E-" & Text(Today(), "yyyy") &Text(ThisItem.ID, "00000") ,"E-" & Text(ThisItem.JoinDate, "yyyy") &Text(ThisItem.ID, "00000"))
Width: =154
X: =126
Y: =46
- Icon1:
Control: Classic/Icon@2.5.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
Color: =RGBA(0, 120, 212, 1)
DisabledBorderColor: =RGBA(245, 245, 245, 1)
DisabledColor: =RGBA(225, 223, 221, 1)
DisabledFill: =RGBA(0, 0, 0, 0)
FocusedBorderThickness: =4
Height: =39
HoverBorderColor: =RGBA(0, 0, 0, 0)
HoverColor: =RGBA(16, 110, 190, 1)
HoverFill: =RGBA(0, 0, 0, 0)
Icon: =Icon.Trash
OnSelect: |+
=Remove('OrgEmployee-Dev',ThisItem)
PressedBorderColor: =RGBA(0, 0, 0, 0)
PressedColor: =RGBA(16, 110, 190, 1)
PressedFill: =RGBA(0, 0, 0, 0)
Width: =45
X: =294
Y: =21
- Form_Employee:
Control: Form@2.4.3
Variant: Classic
Layout: Vertical
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataSource: ='OrgEmployee-Dev'
Fill: =RGBA(236, 236, 235, 1)
Item: =gal_Employee.Selected
X: =549
Y: =79
Children:
- Name_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Name"
Default: =ThisItem.Name
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Name')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Name')
Required: =false
Update: =DataCardValue1.Text
Width: =266
X: =0
Y: =0
Children:
- DataCardKey1:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue1:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey1.Y + DataCardKey1.Height + 5
- ErrorMessage1:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue1.Y + DataCardValue1.Height
- StarVisible1:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey1.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey1.Y
- Jobtitle_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Jobtitle"
Default: =ThisItem.Jobtitle
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Jobtitle')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Jobtitle')
Required: =false
Update: =DataCardValue2.Text
Width: =266
X: =1
Y: =0
Children:
- DataCardKey2:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue2:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey2.Y + DataCardKey2.Height + 5
- ErrorMessage2:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue2.Y + DataCardValue2.Height
- StarVisible2:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey2.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey2.Y
- Department_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Department"
Default: =ThisItem.Department
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Department')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Department')
Required: =false
Update: =DataCardValue3.Text
Width: =266
X: =2
Y: =0
Children:
- DataCardKey3:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue3:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey3.Y + DataCardKey3.Height + 5
- ErrorMessage3:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue3.Y + DataCardValue3.Height
- StarVisible3:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey3.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey3.Y
- Mail_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Mail"
Default: =ThisItem.Mail
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Mail')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Mail')
Required: =false
Update: =DataCardValue4.Text
Width: =266
X: =0
Y: =1
Children:
- DataCardKey4:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue4:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey4.Y + DataCardKey4.Height + 5
- ErrorMessage4:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue4.Y + DataCardValue4.Height
- StarVisible4:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey4.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey4.Y
- Mobile_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Mobile"
Default: =ThisItem.Mobile
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Mobile')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Mobile')
Required: =false
Update: =DataCardValue5.Text
Width: =266
X: =1
Y: =1
Children:
- DataCardKey5:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue5:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey5.Y + DataCardKey5.Height + 5
- ErrorMessage5:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue5.Y + DataCardValue5.Height
- StarVisible5:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey5.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey5.Y
- Phone_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Phone"
Default: =ThisItem.Phone
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Phone')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Phone')
Required: =false
Update: =DataCardValue6.Text
Width: =266
X: =2
Y: =1
Children:
- DataCardKey6:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue6:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey6.Y + DataCardKey6.Height + 5
- ErrorMessage6:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue6.Y + DataCardValue6.Height
- StarVisible6:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey6.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey6.Y
- JoinDate_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicDateEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="JoinDate"
Default: =ThisItem.JoinDate
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'JoinDate')
Required: =false
Update: =DataCardValue7.SelectedDate
Width: =266
X: =0
Y: =2
Children:
- DataCardKey7:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue7:
Control: Classic/DatePicker@2.6.0
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
DefaultDate: =Parent.Default
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
EndYear: =Year(Today())+100
Fill: =RGBA(245, 245, 245, 1)
Font: =Font.'Segoe UI'
IconBackground: =RGBA(0, 120, 212, 1)
IconFill: =RGBA(255, 255, 255, 1)
IsEditable: =true
PaddingBottom: =0
PaddingLeft: =If(Self.DisplayMode = DisplayMode.Edit, 5, 0)
Size: =13
StartYear: =1899
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey7.Y + DataCardKey7.Height + 5
- ErrorMessage7:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue7.Y + DataCardValue7.Height
- StarVisible7:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey7.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey7.Y
- ResignationDate_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicDateEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="ResignationDate"
Default: =ThisItem.ResignationDate
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'ResignationDate')
Required: =false
Update: =DataCardValue8.SelectedDate
Width: =266
X: =1
Y: =2
Children:
- DataCardKey8:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue8:
Control: Classic/DatePicker@2.6.0
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
DefaultDate: =Parent.Default
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
EndYear: =Year(Today())+100
Fill: =RGBA(245, 245, 245, 1)
Font: =Font.'Segoe UI'
IconBackground: =RGBA(0, 120, 212, 1)
IconFill: =RGBA(255, 255, 255, 1)
IsEditable: =true
PaddingBottom: =0
PaddingLeft: =If(Self.DisplayMode = DisplayMode.Edit, 5, 0)
Size: =13
StartYear: =1899
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey8.Y + DataCardKey8.Height + 5
- ErrorMessage8:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue8.Y + DataCardValue8.Height
- StarVisible8:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey8.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey8.Y
- Position_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="Position"
Default: =ThisItem.Position
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'Position')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'Position')
Required: =false
Update: =DataCardValue9.Text
Width: =266
X: =2
Y: =2
Children:
- DataCardKey9:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue9:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =32
Y: =40
- ErrorMessage9:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue9.Y + DataCardValue9.Height
- StarVisible9:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey9.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey9.Y
- ShortNumber_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicNumberEdit
IsLocked: true
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="ShortNumber"
Default: =ThisItem.ShortNumber
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'ShortNumber')
Required: =false
Update: =Value(DataCardValue10.Text)
Width: =266
X: =0
Y: =3
Children:
- DataCardKey10:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue10:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
Format: =TextFormat.Number
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey10.Y + DataCardKey10.Height + 5
- ErrorMessage10:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue10.Y + DataCardValue10.Height
- StarVisible10:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey10.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey10.Y
- EmpNo_DataCard1:
Control: TypedDataCard@1.0.7
Variant: ClassicTextualEdit
Properties:
BorderColor: =RGBA(245, 245, 245, 1)
DataField: ="EmpNo"
Default: =ThisItem.EmpNo
DisplayName: =DataSourceInfo([@'OrgEmployee-Dev'],DataSourceInfo.DisplayName,'EmpNo')
MaxLength: =DataSourceInfo([@'OrgEmployee-Dev'], DataSourceInfo.MaxLength, 'EmpNo')
Required: =false
Update: =DataCardValue11.Text
Width: =266
X: =1
Y: =3
Children:
- DataCardKey11:
Control: Label@2.5.1
MetadataKey: FieldName
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =34
PaddingLeft: =0
Text: =Parent.DisplayName
Width: =Parent.Width - 60
Wrap: =false
X: =30
Y: =10
- DataCardValue11:
Control: Classic/TextInput@2.3.2
MetadataKey: FieldValue
Properties:
BorderColor: =If(IsBlank(Parent.Error), Parent.BorderColor, Color.Red)
Color: =RGBA(50, 49, 48, 1)
Default: =Parent.Default
DelayOutput: =true
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
DisplayMode: =Parent.DisplayMode
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(16, 110, 190, 1)
HoverColor: =RGBA(50, 49, 48, 1)
HoverFill: =RGBA(255, 255, 255, 1)
MaxLength: =Parent.MaxLength
PaddingLeft: =5
PressedBorderColor: =RGBA(0, 120, 212, 1)
PressedColor: =RGBA(50, 49, 48, 1)
PressedFill: =RGBA(255, 255, 255, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Tooltip: =Parent.DisplayName
Width: =Parent.Width - 60
X: =30
Y: =DataCardKey11.Y + DataCardKey11.Height + 5
- ErrorMessage11:
Control: Label@2.5.1
MetadataKey: ErrorMessage
Properties:
AutoHeight: =true
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(168, 0, 0, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(168, 0, 0, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =10
Live: =Live.Assertive
PaddingBottom: =0
PaddingLeft: =0
PaddingRight: =0
PaddingTop: =0
Text: =Parent.Error
Visible: =Parent.DisplayMode=DisplayMode.Edit
Width: =Parent.Width - 60
X: =30
Y: =DataCardValue11.Y + DataCardValue11.Height
- StarVisible11:
Control: Label@2.5.1
MetadataKey: FieldRequired
Properties:
Align: =Align.Center
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
BorderThickness: =2
Color: =RGBA(50, 49, 48, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
FocusedBorderThickness: =4
Font: =Font.'Segoe UI'
FontWeight: =FontWeight.Semibold
Height: =DataCardKey11.Height
PaddingLeft: =0
Text: ="*"
Visible: =And(Parent.Required, Parent.DisplayMode=DisplayMode.Edit)
Width: =30
Wrap: =false
Y: =DataCardKey11.Y
- btn_New:
Control: Classic/Button@2.2.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
Color: =RGBA(255, 255, 255, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
Fill: =RGBA(0, 120, 212, 1)
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(0, 0, 0, 0)
HoverColor: =RGBA(255, 255, 255, 1)
HoverFill: =RGBA(16, 110, 190, 1)
OnSelect: =NewForm(Form_Employee);
PressedBorderColor: =RGBA(0, 69, 120, 1)
PressedColor: =RGBA(255, 255, 255, 1)
PressedFill: =RGBA(16, 110, 190, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Size: =13
Text: ="새로만들기"
X: =160
Y: =21
- btn_Save:
Control: Classic/Button@2.2.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
Color: =RGBA(255, 255, 255, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
Fill: =RGBA(0, 120, 212, 1)
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(0, 0, 0, 0)
HoverColor: =RGBA(255, 255, 255, 1)
HoverFill: =RGBA(16, 110, 190, 1)
OnSelect: |-
=If(
Form_Employee.Mode = FormMode.New,
SubmitForm(Form_Employee);
With(
{createdRecord : Form_Employee.LastSubmit},
Patch(
'OrgEmployee-Dev',
createdRecord,
{
EmpNo: "E-" & Text(Today(), "yyyy") & Text(createdRecord.ID, "00000")
}
)
)
,
SubmitForm(Form_Employee)
)
PressedBorderColor: =RGBA(0, 69, 120, 1)
PressedColor: =RGBA(255, 255, 255, 1)
PressedFill: =RGBA(16, 110, 190, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Text: ="저장"
X: =1168
Y: =520
- btn_Update:
Control: Classic/Button@2.2.0
Properties:
BorderColor: =RGBA(0, 0, 0, 0)
BorderStyle: =BorderStyle.None
Color: =RGBA(255, 255, 255, 1)
DisabledBorderColor: =RGBA(0, 0, 0, 0)
DisabledColor: =RGBA(161, 159, 157, 1)
DisabledFill: =RGBA(242, 242, 241, 0)
Fill: =RGBA(0, 120, 212, 1)
Font: =Font.'Segoe UI'
HoverBorderColor: =RGBA(0, 0, 0, 0)
HoverColor: =RGBA(255, 255, 255, 1)
HoverFill: =RGBA(16, 110, 190, 1)
OnSelect: "=ForAll(\r\n gal_Employee.AllItems, // 갤러리 내 모든 항목을 순회\r\n Patch(\r\n 'OrgEmployee-Dev', // 대상 SharePoint 리스트\r\n ThisRecord, // 갤러리 항목에 해당하는 SharePoint 레코드 찾기\r\n {\r\n EmpNo: lbl_EmpNo.Text\r\n \r\n }\r\n )\r\n)"
PressedBorderColor: =RGBA(0, 69, 120, 1)
PressedColor: =RGBA(255, 255, 255, 1)
PressedFill: =RGBA(16, 110, 190, 1)
RadiusBottomLeft: =0
RadiusBottomRight: =0
RadiusTopLeft: =0
RadiusTopRight: =0
Size: =13
Text: ="사번 전체 업데이트"
X: =364
Y: =21
[참고자료]
Power Apps 사원 번호 만들기
사원번호 정의 회사에서 인원 관리를 위해 부여한 관리번호를 의미한다. 사원번호 목적 결재 앱을 만들다 보면 사원의 정보를 가져와 처리해야 하는 값들이 생기게 된다. 이때 사원을 구분하는
leemcse.tistory.com
댓글