PowerApps to SP Combo Box Patches the Same Value

[david_castillo]

Hello!

I have the following data for my Patch function to SharePoint:

Patch('SP-CM-Test',Defaults('SP-CM-Test'),{
    Title:CardNo.Text,
    MIN:MIN.Text,
    BusinessName:BizName.Text,
    AuthorizedRep:CO.Text,
    BusinessAddress:BizAdd.Text,
    Attendee:AttendeeName.Text,
    Position:Position.Text,
    FBUserName:FBUsername.Text,
    DateAttended:DateAttended.SelectedDate,
    Merch: ForAll(
                               Merch.SelectedItems,
                               {
                                 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                                  Value: Merch.Selected.Value
                               }
                          ),
    TopicsTrained:{
                                 '@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
                                  Value: TopicsTrained.Selected.Value
                               }

});

Here are the fields:

Page 1:

Page 2:

Merchandise Combobox values currently are:

Merch 1

Merch 2

Merch 3

For some reason, when I patch the Merchandise combo box and pick more than one choice (for example, I picked Merch 1, Merch 2), it seems to only get the value of Merch 3, even though I selected two items. Please note that I used ForAll when patching.

Here is the screenshot in SharePoint:

It acknowledges the number of choices I picked, but always defaults to the highest (?) choice tier.

[v-monli-msft · Accepted solution]

Hi @david_castillo ,

Is the Merch column a Choice type column (which enables multiple options) within your SP list? Please try below formula:

ClearCollect(
    ChoiceCollection,
    ForAll(Merch.SelectedItems,{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:Value})
);
Patch(
        'SP-CM-Test',
        Defaults('SP-CM-Test'),
        {
          Title:CardNo.Text,
          MIN:MIN.Text,
          BusinessName:BizName.Text,
          AuthorizedRep:CO.Text,
          BusinessAddress:BizAdd.Text,
          ...
          Products_x0020_2: ChoiceCollection
        }
)  

Regards,

Mona

[david_castillo]

It worked! Thanks a lot, Mona!

For the other people to see, I retained my code but changed the Value: Merch.Selected.Value to Value:Value. It seems I misunderstood how the Value works - instead of calling the actual value, I'm calling the dropdown only.