PowerApps to SP Combo Box Patches the Same Value

(0) Share

Report

Posted on by david_castillo

105

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

v-monli-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
david_castillo 105 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No