Hi @RandyHayes ,
Yes I am running into a few issues - mostly with I need to put my code to make things save and load (for viewing and editing).
This is one of several errors that I am experiencing:
The tutorial that I linked to states that you create a save button to hold the code to save. Since I am using the SharePoint integration, that won't be much good as people are going to press the wrong save link.
This is the code from the screenshot above (This works on the on select option):
UpdateContext(
{
NewItemsString: Concat(
RepeattingTable_1.AllItems,
Concatenate(
'sr.no_1'.Text,
";",
Dropdown2.SelectedText.Value,
";",
technicalcontent_1.Text,
";",
description_1.Text,
";",
"|"
)
)
}
);
SubmitForm(SharePointForm1)
The next block of code that is giving me errors is this one:
This code is meant to be set for when the form become viable. The full code for that is
UpdateContext({EditStringVal: SelectedItem.RepeatedSection});
UpdateContext({EditStringVal2: SelectedItem.RepeatedSection2});
Clear(EditCols);
Clear(EditCols2);
Set(
Editstr,
SelectedItem.RepeatedSection
);
Set(
Editstr,
Left(
Editstr,
Len(Editstr) - 1
)
);
ForAll(
Split(
Editstr,
"|"
),
Collect(
EditCols,
{
CItemSerialNumber: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
1
).Result
).Result
),
Clevel: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
2
).Result
).Result
),
Ctc: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
3
).Result
).Result
),
Cdescription: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
4
).Result
).Result
)
}
)
);
Set(
Editstr1,
SelectedItem.RepeatedSection2
);
Set(
Editstr1,
Left(
Editstr1,
Len(Editstr1) - 1
)
);
ForAll(
Split(
Editstr1,
"|"
),
Collect(
EditCols2,
{
CItemSerialNumber: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
1
).Result
).Result
),
Clevel: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
2
).Result
).Result
),
Ctc: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
3
).Result
).Result
),
Cdescription: Text(
Last(
FirstN(
Split(
Result,
";"
).Result,
4
).Result
).Result
)
}
)
)
Please note that this is from my testing app where I had this working (I needed 2 repeating tables)
For now they are the only issues that I have ran into - as you can see, I am playing with this in my dev environment before getting this out in production.
Also, I do intend to copy FormScreen1 several times (for edit and view screen), just taking baby steps to make sure that codes goes where they should.
Update, I tried to get sneaky by setting setting the onsave function to 'Select(Button1_1)' and that didn't work as shown below:
Any help would be much appreciated.
