I am creating an app. which contain one Form (Materialanforderungform) and gallery in this form for repeating table is a collection (coldetails).
I am trying to save the two Patch in one list in SP and use one Button.
the patch of repeating table is done but i cant save the data from the form in the same line of repeating table.
Curruntly my code of Patch for Form is:
//SubmitForm(MaterialanforderungForm);;
Patch(
'Materialanforderung Liste'; Defaults('Materialanforderung Liste');
{
Lieferanten: LieferantenDataCardValue.Text;
Zustandshinweis: ZustandshinweisDataCardValue.Text;
'Bereich / Kostenstelle': KostenstelleTextInput.Text;
Kostenstelle:BKDataCardValue;
Anlagen: AnlagenDataCardValue;
'Gewünschter Liefertermin': 'Gewünschter LieferterminDataCardValue'.SelectedDate;
//Lookup columns
Firma: FirmaDataCardValue;
'Standort Anforderer': standOrtDataCardValue;
Lieferort: ddLieferOrt.Selected;
//Person column
Anforderer: {
Claims: "i:0#.f|membership|" & Lower(AnfordererDataCardValue.Selected.Mail);
DisplayName: AnfordererDataCardValue.Selected.DisplayName;
Department: AnfordererDataCardValue.Selected.Department;
Email: AnfordererDataCardValue.Selected.Mail;
JobTitle: AnfordererDataCardValue.Selected.JobTitle;
Picture: ""
};
'Kostenstelle Verantwortlicher': {
Claims: "i:0#.f|membership|" & Lower(KostenstelleVATextInput.Text);
DisplayName: KostenstelleVATextInput.Text;
Department: "";
Email: KostenstelleVATextInput.Text;
JobTitle: "";
Picture: ""
}
)
Here is a collection patch
'Optional Beteiligter': ForAll(
OptionalBeiteiligterDataCardValue.SelectedItems;
{
Claims: "i:0#.f|membership|" & ThisRecord.Mail;
// Lower(AnfordererDataCardValue.Selected.Mail);
DisplayName: ThisRecord.DisplayName;
Department: ThisRecord.Department;
Email: ThisRecord.Mail;
JobTitle: ThisRecord.JobTitle;
Picture: ""
}
)
// ;'Status (Status0)':{Value: "New"}
}
);;
If(
CountRows(colDetails) > 0;
ForAll(
colDetails;
If(
!IsBlank(LineBezeichnung);
Patch(
'Materialanforderung Liste';
Defaults('Materialanforderung Liste');
// MaterialanforderungForm.Updates;
{
//IDTable:First(colPatchBase).ID;
// IDTable:Value( First(colPatchBase).IDTable) ;
//*******Single line of text columns****/
'Bezeichnung Title': Text(LineBezeichnung);
Investnummer: Text(LineInv);
Art: LineArt.Value;
/***Number columns******/
'Einzelpreise/Nettopreise': Value(LinePriseNetto);
'Gesamtpreis/Nettopreis': Value(LineGesNetto);
'Einkaufspreis/Brutto': Value(LineGesBrutto);
'Menge/Einheit': Value(LineMenge)
;IDTable: MaterialanforderungForm.LastSubmit.ID
}
)
)
)
)
;;
RequestHide();;
// check for errors
If(
IsEmpty(Errors('Materialanforderung Liste'));
// on Success
Notify(
// Success;
"Thank You For Submitting The Data";
NotificationType.Success
);
// on failure
Notify(
"Failed to start session! Error: ";//Last(Errors('Materialanforderung Liste')).Message;
//Concat(Errors('Materialanforderung Liste'); Column & ": " & Message);
First(Errors('Materialanforderung Liste')).Message;
NotificationType.Error
)
);;
Set(varEditForm;false);;
ResetForm(MaterialanforderungForm);;
Clear(colDetails);;
Navigate(HomeScreen);;
//Refresh('Materialanforderung Liste');;
//RequestHide();;
