Answered

Patch function on Choice button to submit to SP list

(0) Share

Report

Posted on by Snacham

Hi,

I have a list with few text fields and one dropdown choice field with three choices. I am trying to submit the data using patch and able to submit values for other text fields but not the dropdown field.

List - Social, Dropdown choice field in list -SM,

Dropdown field name in PowerApps -SocialMedia (Items property - Choices(Social.SM))

Here is my code on Submit button OnSelect -

Patch(Social,
Defaults(Social),
{
'Net Working Media': NWMediaValue.Text,
Mediatypes: MediaTypeValue.Text,
SM:{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",Value:SocialMedia.Selected.Value}
}
);

Thanks in Advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Snacham ,

I assume the target is a Choice field?

Patch(Social, Defaults(Social), { 'Net Working Media': NWMediaValue.Text, Mediatypes: MediaTypeValue.Text, SM:{Value:SocialMedia.Selected.Value} } )

or is it a Lookup field?

Patch(Social, Defaults(Social), { 'Net Working Media': NWMediaValue.Text, Mediatypes: MediaTypeValue.Text, SM: { Value:SocialMedia.Selected.Value Id:SocialMedia.Selected.Id } } )

This one is assuming the Items of the drop-down are simply

Choices(ListName.FieldName)

Also you no longer need the "long" Azure.Connectors reference.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Snacham 57 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @WarrenBelz ,

Yes the target is a choice field and I have tried using the below but no luck -
Patch(Social, Defaults(Social), { 'Net Working Media': NWMediaValue.Text, Mediatypes: MediaTypeValue.Text, SM:{Value:SocialMedia.Selected.Value} } )
I have tried passing the value to dropdown like below and it worked -
Patch(
Social,
Defaults(Social),
{
'Net Working Media': NWMediaValue.Text,
Mediatypes: MediaTypeValue.Text,
SM:{Id: 5,Value:"Test Media"}
}
);

Not sure, what might be the mistake here. Let me know if you need anything else.

Thanks,

Was this reply helpful? Yes No
WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Snacham ,
Are you sure this is not a Lookup field - you do not need Id for a Choice field - it does not have one.

Also what are the Items of your SocialMedia control and is it a Drop-down or a Combo Box?

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Snacham 57 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it is a choice field in list -
It is a combo box and Items property of SocialMedia dropdown - Choices([@Social].SM).

Thanks,

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,409 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Snacham ,

Your code

Patch(Social, Defaults(Social), { 'Net Working Media': NWMediaValue.Text, Mediatypes: MediaTypeValue.Text, SM:{Value:SocialMedia.Selected.Value} } )

should work on a Choice field. Also it does not have an Id, therefore the other code should actually error. For a bit of debugging, do a collection

ClearCollect(colSocial,Social)

Go to View > Collections and see what is in SM.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No