Hi @BrendonBrooksP1 ,
Could you please share more details about the error message with your formula?
How do you collect the data entered via the users in your app? Using Edit form control or just a set of simple controls?
Have you taken a try to remove the Concurrent() function and perform your formula again?
If you collect the data entered via the users in your app using a set of simple controls (e.g. Dropdown, Text Input box, etc) rather than Edit form, please modify your formula as below:
Patch(
'[dbo].[Inspections]',
LookUp('[dbo].[Inspections]', Id = Value(InspectIdHome.Text)),
{
Base: DropBaseInspHome.Selected.Value,
Unit: DropUnitInspHome.Selected.Value,
TailNumber: DropTailNumInspHome.Selected.Value,
Location: DropLocInspHome.Selected.Value,
NextInspect: DateValue(LblNextInspect_2.Text),
LastInspectionDate: DatePickMaintenance_2.SelectedDate,
Status: DropStatusInspHome.Selected.Value
}
);
Patch(
'[dbo].[Records]',
Defaults('[dbo].[Records]'),
{
alseSn: SerialInspHome.Text,
Base: DropBaseInspHome.Selected.Value,
Description: TxtBoxDescription_2.Text,
Inspector: DropInspectorInspHome1.Selected.Value,
Inspector2: DropInspectorInspHome2.Selected.Value,
Location: DropLocInspHome.Selected.Value,
maintAccomplishDate: DatePickMaintenance_2.SelectedDate,
Type: "Inspect",
Status: DropStatusInspHome.Selected.Value,
TailNumber: DropTailNumInspHome.Selected.Value
}
);
Patch(
'[dbo].[ Items]',
LookUp('[dbo].[alseItems]',Id = Value(ItemIdHome.Text)),
{
Base: DropBaseInspHome.Selected.Value,
Unit: DropUnitInspHome.Selected.Value,
location: DropLocInspHome.Selected.Value,
tailNumber: DropTailNumInspHome.Selected.Value,
status: DropStatusInspHome.Selected.Value
}
);
Navigate(
Success,
ScreenTransition.Cover
)
please take a try with above formula, then check if the issue is solved.
If you collect the data entered via the users in your app using Edit form, please consider modify your formula as below:
Set(EntryData, EditForm1.Updates); /* <-- Store the filled Forms data into a variable, then reference corresponding values from this variable within your Patch function*/
Patch(
'[dbo].[Inspections]',
LookUp('[dbo].[Inspections]', Id = Value(InspectIdHome.Text)),
{
Base: EntryData.Base,
Unit: EntryData.Unit,
TailNumber: EntryData.TailNumber,
...
}
);
Patch(
'[dbo].[Records]',
Defaults('[dbo].[Records]'),
{
alseSn: EntryData.alesSn,
Base: EntryData.Base,
Description: EntryData.Description,
Inspector: EntryData.Inspector,
...
}
);
Patch(
'[dbo].[ Items]',
LookUp('[dbo].[alseItems]',Id = Value(ItemIdHome.Text)),
{
Base: EntryData.Base,
Unit: EntryData.Unit,
location: EntryData.location,
tailNumber: EntryData.tailNumber,
status: EntryData.status
}
);
Navigate(
Success,
ScreenTransition.Cover
)
Note: If your three Patch functions reference values from multiple Edit forms, please consider take a try to save these multiple form data into separated variables (e.g. EntryData, EntryData1, EntryData2, ...). Then within your Patch formula, reference values from proper variable.
Best regards,
