Looking for another set of eyes. This formula is to patch to a Sharepoint list. The list column JobName in Sharepoint (and in Power Apps) is a Lookup to another table TMPC Job Names.
ForAll(
RequestCollection,
If(!IsBlank(Location),
Patch('Per Diem Request Detail List', Defaults('Per Diem Request Detail List'),
{
PerDiemDate: DateValue(PerDiemDate),
Location: Location,
PerDiemRate: PerDiemRate
{
JobName:
{
Value: JobName,
Id:
LookUp(
'TMPC Job Names',
JobName= JobName
).ID
}
}
Notes: Notes,
TravelDay: {Value:TravelDay},
Reimbursement: Reimbursement,
CompanyHousing: {Value:CompanyHousing},
CompanyCar: {Value:CompanyCar},
MasterID: frmMaster.LastSubmit.ID
}
)))
