Hello,
I'm experiencing a persistent issue while working with Power Apps and a SQL database. The specific error message I'm encountering is "Network error when using Patch function: Field 'Id' is required." It seems that, even though the 'Id' field should be auto-generated, the error persists.
Patch(
ProjectsRisks,
{
ProjectsCatalogId: 2,
RiskCatalogId: Drp_new_risk_suggested_risk.Selected.Id,
RiskCategoryId: Drp_new_risk_suggested_risk.Selected.RiskCategoryId,
RiskScopeId: Drp_new_risk_suggested_risk.Selected.RiskScopeId,
RiskProcessId: Drp_new_risk_suggested_risk.Selected.RiskProcessId,
RiskTypeId: Drp_new_risk_suggested_risk.Selected.RiskTypeId,
RiskSubtypeId: Drp_new_risk_suggested_risk.Selected.RiskSubtypeId,
RiskTodoTypeId: Drp_new_risk_todo_type.Selected.Id,
RiskStatusId: Drp_new_risk_status.Selected.Id,
ProbabilityId: Drp_new_risk_probabilty.Selected.Id,
ImpactId: Drp_new_risk_impact.Selected.Id,
PriorityId: Drp_new_risk_probabilty.Selected.Id * Drp_new_risk_impact.Selected.Id,
Notes: Txt_new_risk_description.Text,
ExpirationDate: Date_new_risk_expiration.SelectedDate,
CreatedBy: User().Email,
CreateDate: Now()
}
);
Set(riskCreated, First(SortByColumns(Filter(ProjectsRisks, CreatedBy = User().Email),"CreateDate",SortOrder.Descending)).Id
);
Refresh(ProjectsActions); // Esto no hace nada
If(
!IsBlank(CombinedItems),
ForAll(
CombinedItems As action,
Patch(
ProjectsActions,
{
ProjectsRisksId: riskCreated,
RiskActionCatalogId: action.riskCatalogId,
RiskActionTypeId: action.RiskActionTypeId,
Description: action.RiskAction,
CancelStateId: 1,
CreateDate: Now(),
CreatedBy: User().Email
}
)
;ForAll(Filter(tasks, ProjectActionIdDynamic = action.varNextId) As task,
Patch(ProjectsTasks,
{
ProjectsActionsId: First(SortByColumns(Filter(ProjectsActions, CreatedBy = User().Email),"CreateDate",SortOrder.Descending)).Id,
Description: task.Description,
ExecutionStart: DateTimeValue(task.ExecutionStart),
ExecutionEnd: DateTimeValue(task.ExecutionEnd),
TaskResultId: task.TaskResultId,
CancelStateIdTask: 1,
CreateDate: Now(),
CreatedBy:User().Email,
Notes:task.Notes
}
)
)
),
false
);Notify(NotificationType.Success, "El registro ha sido guardado correctamente")
; Navigate(SCR_RISKS_LIST_VIEW)
I am having the erro in this part of the code:
Patch(
ProjectsActions,
{
ProjectsRisksId: riskCreated,
RiskActionCatalogId: action.riskCatalogId,
RiskActionTypeId: action.RiskActionTypeId,
Description: action.RiskAction,
CancelStateId: 1,
CreateDate: Now(),
CreatedBy: User().Email
}
)
I've confirmed that the 'Id' field is properly configured in the SQL database, and I'm not manually assigning a value to 'Id' elsewhere in the code.
If anyone in the community has encountered a similar issue or has insights into resolving this problem, I would greatly appreciate your guidance.
Thank you!
