Hi,
I am trying to convert one of my old excel worksheets into PowerApps. This way I can edit and add new items as needed. However, I can't seem to figure out how to get the formulas to work before the submission of the edited or new entry.
For example:
I have columns in Excel that are named as such:
DateC: (Date Field) - Manually Entered
DateR: (Date Field) - Manually Entered
ReqEmp: (Text Field) - Manually Entered
PenC: Formula - If Statement
DatePMI: (Date Field) - Manually Entered
Exp: (Text Field) - Dropdown
PenD: (Number Field) - Formula
ProcD: (Number Field) - Formula
Clear: (Text Field) - Formula
T/C: (Text Field) - Formula
TPenD: (Number Field) - Formula
Basically, Once all the Manually Entered fields are either entered or blank the formulas will automatically update in excel. However, I can't get them to work in PowerApps. Moreover, I would need them to calculate before the form can be submitted to make changes to the SharePoint List.
Below is the formulas I am using:
'ProcD:
If(
IsBlank(ThisItem.'DateC:'),
"",
ThisItem.'DateC:' - ThisItem.'DateR:'
)
'PenD:
If(
IsBlank(ThisItem.'ReqEmp:'),
"",
If(
ThisItem.'PenC:' = "P",
Today() - ThisItem.'DateR:',
"")
)
'Clear:
If(
IsBlank(ThisItem.'ReqEmp:'),
"",
If(
ThisItem.'PenC:' = "P",
"",
If(
ThisItem.'PenC:' = "PC",
"Y",
If(
ThisItem.'ReqEmp:' = "Record Completion",
"X",
If(
IsBlank(ThisItem.'DateC:'),
"N",
"Y"
)
)
)
)
)
'PenC:
If(
And(
!IsBlank(ThisItem.'DatePMI:'),
!IsBlank(ThisItem.'DateC:')
),
"PC",
If(
And(
!IsBlank(ThisItem.'DatePMI:'),
IsBlank(ThisItem.'DateC:')
),
"P",
""
)
)
'T/C:
f(
ThisItem.'Exp:'.Value <> "T/C",
"",
If(
And(ThisItem.'Exp:'.Value = "Train/CR",
!IsBlank(ThisItem.'DateC:')
),
"TCR",
"N"
)
)
'TPenD:
If(
ThisItem.'PenD:' >= 0.0001,
If(
ThisItem.'PenD:' <= 83.9950,
1,
If(
ThisItem.'PenD:' <= 119.9980,
2,
If(
ThisItem.'PenD:' <= 174.9950,
3,
If(
ThisItem.'PenD:' <= 99999.0000,
4,
""
)
)
)
),
""
)


Report
All responses (
Answers (