Hi all,
I have an issue whereby I cannot patch ALL selected items from a pick list (From SharePoint List A "Maintenance Questions") and write them to List B "Planned Maintenance Submissions".
I have 5 fields that I wish to Patch to "Planned Maintenance" which technically works, however, when I select multiple items from a Pick List (lstActivity) the Patch function only passes through the final item you selected. For example, if you pick, A,B, C and G; only item G will appear in the SharePoint list even though the others are selected. My formula is:
Patch(
'Planned Maintenance Submissions',
Defaults('Planned Maintenance Submissions'),
{
Title: txtName.Text,
Machine: drpMachines.Selected.Value,
'Maintenance Type': drpType.Selected.Value,
'Maintenance Activity': lstActivity.Selected.Value,
Comments: txtComments.Text
}
);
Reset(txtName);
Reset(drpMachines);
Reset(drpType);
Reset(lstActivity);
Reset(txtComments);
Navigate(scrSuccess)
I have also tried to "trick" Power Apps by Concatinating the selected items into an invisible text box which would be patched instead of the pick list:
Concat(lstActivity.SelectedItems, ", ")
This doesn't work either and whilst the box appears to see items are selected, they do not show and appear as " , , , "
I have also looked at using a collection but cannot get this to work either.
Can anyone help please?
Thanks!
