Patch Combobox to SharePoint Choice Coloum

[Mac]

Looking for some help please.

I’m trying to patch a combo box to a SharePoint Choice Column (Checkbox) but can’t seem to get anywhere. I can patch to a simple choice column, however after reading tutorials and videos on YouTube for combobox I’ve hit a dead end. Ive highlighted in red the patch string i found online, i think im nearly there, but need the forum help.

[Drrickryp]

Hi @Mac,

my simple suggestion is to get rid of choice columns in PowerApp by either changing the column type in SharePoint to single line of text or adding a calculated column with the choice column selected and using that instead.

[v-xida-msft · Accepted solution]

Hi @Mac,

Is the Products 2 column a Choice type column (which enables multiple options) within your SP list?

Do you want to save a Combo box selected values/options into the Products 2 column of your SP list?

Further, could you please share more details about the error message with the formula that you provided?

I have made a test on my side, and don't have the issue that you mentioned. The screenshot as below:

Set the OnSelect property of the "Patch" button to following formula:

Patch(
   '20181015_case13',
    Defaults('20181015_case13'),
   {
    Title:"PowerAppsTest2",
    FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
   }
)

On your side, you should type following:

ForAll(
    CallBack,
    Patch(
        'Call Back Form',
        Defaults('Call Back Form'),
        {
          Customer_x0020_Name: CustomerName,
          Title: Number,
          ...
          Products_x0020_2: ForAll(
                               DataCardValue17.SelectedItems,
                               {
                                 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                                  Value: Value
                               }
                          )
        }
    )
)

Or

ClearCollect(
    ChoiceCollection,
    ForAll(DataCardValue17.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
);
ForAll(
    CallBack,
    Patch(
        'Call Back Form',
        Defaults('Call Back Form'),
        {
          Customer_x0020_Name: CustomerName,
          Title: Number,
          ...
          Products_x0020_2: ChoiceCollection
        }
    )
)

Best regards,

Kris

[Nate1]

Hello @v-xida-msft ,

In this example:

Patch(
   '20181015_case13',
    Defaults('20181015_case13'),
   {
    Title:"PowerAppsTest2",
    FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
   }
)

Is there a way to concatenate an additional value outside the ForAll statement? For example, I have an "Other" option in the combobox which allows text input (OtherInput). So I would want to do something like:

FruitChoice:ForAll(ComboBox1.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})&", "Value: OtherInput.Text

This doesn't work, but I wanted to see how I might do this.

thanks

[Anonymous]

I had a similar issue.
I need to paste multiple selected items in a combobox to a sharepoint list text column.
This is how I did this inside Patch:

Patch(DestinationList,{TextColum: Concat(ComboBox.SelectedItems,VariableValue,", ")}

Concat(ComboBox.SelectedItems,VariableValue,", ") 

This separates the items selected in combobox with ", " and converts the whole into text and allows me to patch the Sharepoint list.