Here are my issues and if anyone could help, I would greatly appreciate it.
1st Issue: From my Archive Screen, I have submitted records in a gallery that will display the information when selected. When I go to Edit that record, everything defaults to empty. When I want to edit the submitted information.
Blank Submitted Record
Archive Screen (View Mode)
2nd Issue: When I create an entirely new record, it will override an already submitted record. When I want it to create a new row with the new information in my Sharepoint List.
Here is the code:
IfError(
Patch(
'GSE Tier 2 Sharepoint List',
If(
IsBlank(varGList),
Defaults('GSE Tier 2 Sharepoint List'),
varGList
),
{
ProductionModel: Production_Model.Selected.Value,
Owner: OwnerTxt_1.Text,
CreationDate: DateValue(CreateDatetxt_1.Text),
Title: TitleTxt_1.Text,
Location: Locationtxt_1.Text,
Department: Depttxt_1.Text,
'TotalDowntime(Minutes)': Value(TDownTime.Text),
'TotalAvailableMan-Hours': Value('Man-Hours'.Text),
CostReason: CostReason.Selected.Value,
'Plan(Cost)': CostPlantxt.Text,
'Do(Cost)': CostDotxt.Text,
'Check(Cost)': CostChecktxt.Text,
Event: {Value: CostEvent.Selected.Value},
'Act(Cost)': CostActtxt.Selected.Value,
Building: {Value: BldgChoice.Selected.Value},
DueDate: DueDatetxt.Text,
'CompletionDate(Cost)': DateValue(CostCompDate.Text),
ProductionLine: ProdLinetxt2.Text,
'Downtime%': Value(DTPercent.Text)//Number Column in the Sharepoint List
}
),
Notify(
FirstError.Message,
NotificationType.Error,
2000
)
);
UpdateContext({addNewInputText:""});
Reset(Production_Model);
Reset(OwnerTxt_1);
Reset(CreateDatetxt_1);
Reset(TitleTxt_1);
Reset(Locationtxt_1);
Reset(Depttxt_1);
Reset(TDownTime);
Reset('Man-Hours');
Reset(CostReason);
Reset(CostPlantxt);
Reset(CostDotxt);
Reset(CostChecktxt);
Reset(CostEvent);
Reset(CostActtxt);
Reset(BldgChoice);
Reset(DueDatetxt);
Reset(CostCompDate);
Reset(ProdLinetxt2);
Reset(DTPercent);
Navigate(
SucessSubmittal,
ScreenTransition.Fade
);
