Hello everyone,
I am facing an issue with my PowerApp and hope someone can help me out.
In my PowerApp, I have the ability to create new text input fields for a column from a SharePoint list. These fields are then saved in the SharePoint list in one column and are separated by semicolons. I use the new Modern Form with the old Text Input fields.
However, I am unsure if I have correctly implemented the loading of the fields when opening the form with the right record. Here is my current code:
OnVisible for my EditScreen:
Set(varProblemStatementsTable, Split(SelectedUseCaseEditandView.'Problem Statement', ";"));
Set(varSolutionsTable, Split(SelectedUseCaseEditandView.Solution, ";"));
Set(varBenefitsGoalsTable, Split(SelectedUseCaseEditandView.'Benefits / Goals', ";"));
Set(varNumberOfFields_ProblemStatement, CountRows(Filter(varProblemStatementsTable, !IsBlank(Value))));
Set(varNumberOfFields_Solution, CountRows(Filter(varSolutionsTable, !IsBlank(Value))));
Set(varNumberOfFields_BenefitsGoals, CountRows(Filter(varBenefitsGoalsTable, !IsBlank(Value))));
Code for Loading the Text Fields (Example for the second Text Input field):
DataCardValue66_16.Default = If(varNumberOfFields_ProblemStatement >= 2, Last(FirstN(varProblemStatementsTable, 2)).Value, "")
OnSelect Event for the Minus Button (Example for the first Minus Button):
If(
varNumberOfFields_ProblemStatement > 1,
Switch(
varNumberOfFields_ProblemStatement,
2, Reset(DataCardValue66_16),
3, Reset(DataCardValue66_17),
4, Reset(DataCardValue66_18)
);
Set(varNumberOfFields_ProblemStatement, varNumberOfFields_ProblemStatement - 1)
)
Visible of the Minus Button:
Visible = FormModeVariable = FormMode.Edit && varNumberOfFields_ProblemStatement >= 2
My goal is that when clicking a Minus button, the corresponding text field is cleared and remains editable. Currently, the text content is immediately reloaded when I also do it manually clear the field and then load again if I click on the add button.
Does anyone have an idea how I can ensure that the text field is truly cleared and stays empty until a new value is entered?
Thank you in advance!
