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.
Solved! Go to 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
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
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.