Select Multiple Items in Combo Box and Imput data into SharePoint list.

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a SharePoint List that is titled "Checklists".

- On this Checklist I have a column called "Form Name" where it lists every checklist name.

On my Power App I have a combo box that is titled "Checklist(s)"

- It allows me to select multiple checklists

- It allows me to search checklists

- It pulls the checklists from the "Form Names" column of my SharePoint list "Checklists"

I am trying to collect the data from the "Checklist(s)" combo box in my app and have it input that information (all selected items) into a column of a different list on my SharePoint site when the file is saved.

Currently, it does not save that information and I have my app as:

OnSelect= Collect('New Form Name', { Checklists: NewChecklistComboBox.SelectedItems})

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Please try:

OnSelect= Collect('New Form Name', { Checklists: Concat(NewChecklistComboBox.SelectedItems,'Form Names'&";")})

Please note that I considered that Checklists column is Single line of text.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

First of all,

Thank you for taking the time to help me. However, this solution did not fix it. I am guessing it is because I may not have given you all of the details you may need to help me. I apologize for that. Below is an updated question.

I have a SharePoint list titled "Checklists" and in that checklist I have a column named "FormName". This column has the entire list of every checklist we use.

In my App I have a combo box that is connected to that column of that list above (Checklists, FormName). In this combo box, I am able to successfully select multiple checklists and also search the checklists that are there to select which ones I want.

I have another SharePoint list that is titled "ChangeForm". In that list I have a column that is named "Checklist". This column is set up as a single line of text.

My goal is to take the information entered into my app and when I click save it places that information as a row into the SharePoint list named "ChangeForm".

Below is the code I have so far and right now the only issue I am having is collecting the combo box.

Collect(
'Change Form',
{
'Effective Date': NewStepEffectiveDatePicker.SelectedDate,
'New Form Name', { Checklists: Concat(NewChecklistComboBox.SelectedItems,'Form Names'&";")}
Aplicability:NewStepApplicabilityDropdown.SelectedText,
NewStepTitle: NewStepTitleTxt.Text,
NewStepDetail:NewStepDetailTxt.Text,
NewRef:NewStepManRefText.Text,
'Reason For Change':NewReasonText.Text
}
)

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous :
I have sorted out your needs, if there are errors, please help me point them out:
Your Data Source:
Checklists
·'Form Names'（Single Line of Text）
ChangeForm
·'Effective Date'    (Date and Time)
·Checklists          (Single Line of Text)
·Aplicability        (Single Line of Text)
·NewStepTitle        (Single Line of Text)
·NewStepDetail       (Single Line of Text)
·NewRef              (Single Line of Text)
·'Reason For Change' (Single Line of Text)
The ComboBox:
NewChecklistComboBox
Items

Checklists

The Function you need:
Create a new record in ChangeForm. The value of Checklists of this record is a string composed of the selected value of NewChecklistComboBox.
I assume my understanding is correct,Please try:
Set NewChecklistComboBox's OnChange property to:

Patch( 'Change Form', Defaults('Change Form'), { 'Effective Date': NewStepEffectiveDatePicker.SelectedDate, Checklists:Concat(NewChecklistComboBox.SelectedItems,'Form Names'&";"), Aplicability:NewStepApplicabilityDropdown.SelectedText, NewStepTitle: NewStepTitleTxt.Text, NewStepDetail:NewStepDetailTxt.Text, NewRef:NewStepManRefText.Text, 'Reason For Change':NewReasonText.Text } )

I think this link will help you a lot:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-patch
Best Regards,
Bof

Was this reply helpful? Yes No