So, I had to make some assumptions to make up for the lack of information related to your issue, but I do have something for you.
I have created a demo app with the following assumptions:
You have a screen where the users can view all the requests.
The users can either add a new request or edit existing requests.
You have a screen "Add new Request Screen" that has two galleries (i.e., LeftGallery and RightGallery), at least two buttons (i.e., Add and Remove buttons), and a form pointing to a list with a datacard for a multi-line of text field.
When adding a new request, your app works as expected. You can add or remove items between galleries, and submitting the form saves the data in your data source as a semi-colon separated string.
When editing an existing request, your collection is not being populated, and you have issues in your form as well.
In my demo implementation, I have used a variable varFormMode to track whether we navigate to the screen for a new request or to edit an existing request. I have also used the same variable to populate the various galleries and their items as well as the form datacard field. I have mostly used your existing formulas, just tweaked them a little to incorporate the variable I created to track the state.
I have created the two screens on my demo app. I am attaching some reference screenshots and the related code on these screens.
Screen1:
The gallery contains the semi-colon separated string from the multi-line of text field on my data source.
Screen1 Components:
btnAddNew OnSelect:
Set(varFormMode, "New");
Navigate(Screen2);
galCurrentItems Data source:
Title1_2 Text:
ThisItem.Employees // The multi-line of text field
btnSelectItem OnSelect:
Set(varFormMode, "Edit");
Navigate(Screen2);
Screen2:
Screen2 Components:
Screen2 OnVisible:
ClearCollect(
ColListAvailable,
Filter(
Employee,
ID > 15
)
);
ClearCollect(
ColListSelected,
[]
);
If(
varFormMode = "Edit",
ClearCollect(
ColListSelectedSplit,
Split(
galCurrentItems.Selected.Employees,// Replace with your data source multi-line of text fiel
";"
)
)
)
btnAdd OnSelect:
If(
varFormMode = "New",
Collect(
ColListSelected,
LeftGallery.Selected
),
Collect(
ColListSelectedSplit,
LeftGallery.Selected
)
)
btnRemove OnSelect:
If(
varFormMode = "New",
RemoveIf(
ColListSelected,
Value = RightGallery.Selected.Value
),
RemoveIf(
ColListSelectedSplit,
Value = RightGallery.Selected.Value
)
)
RightGallery Items:
If(varFormMode = "New", ColListSelected, ColListSelectedSplit)
LeftGallery Items:
Form2 Data source:
Form2 Default mode:
If(varFormMode = "New", FormMode.New, FormMode.Edit)
Employees_DataCard2 Update:
If(
varFormMode = "New",
Concat(
ColListSelected,
Value,
";"
),
Concat(
ColListSelectedSplit,
Value,
";"
)
)
btnSubmitForm OnSelect:
Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item.
If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like! 🩷
