Dataverse Patch Choice Column to update record in Canvas Gallery not working

[todaytoo]

Hello - I am running into issues updating a record in dataverse with the Patch function. 

I have a nested gallery with a value (Capacity Value) that needs to be updated when a user updates the selected record from the gallery and modifies the dropdown number 1 – 10.

Items: Choices([@CAPACITY_TRACKERS].'Capacity Value')

On Change: Set( varRecord, Patch( varRecord,  {'Capacity Value': Dropdown2_1.Selected.Value}   ))

Default: ThisItem.'Capacity Value'

I have tried setting the On Change to: Patch('CAPACITY DETAIL TRACKERS',ThisItem,{'Capacity Value':Dropdown2_1.Selected.Value})   but get an error message ‘Expecting OptionSetValue value, but from different schema’

[AhmedSalih · Accepted solution]

Hello, @todaytoo , what do you have in your Items property of your Dropdown2_1.Selected? If you have the following formula: Choices(ChoiceName) then, you should use Dropdown2_1.Selected instead of Dropdown2_1.Selected.Value

 

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com