Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Asha Richardson]

I feel like I’m trying to do a simple patch statement to update a  sql table from a gallery, but I’m getting an error.  I think it’s with the dropdown.selectedtext.

There are 2 dropdown boxes:  Categories and JobStatus.  Can someone help me with this patch statement:

 

Patch(
YT_Work,
ThisItem,
{Category: Categories.SelectedText,  //error here (I think)
{Title: TextInput2.Text},
{Chased: DatePicker1.SelectedDate},
{Amount: Value(TextInput1.Text)},
{LikelyStartDate: DatePicker2.SelectedDate},
{AmountLeft: Value(TextInput3.Text)},
{JobStatus: JobStatus.SelectedText}  //error here (I think)
)

I’ve tried this one too and I got the error message:  Invalid arguments:

Patch(
YT_Work,
LookUp(YT_Work, ID=ThisItem.ID),
{Category: Categories.SelectedText,
{Title: TextInput2.Text},
{Chased: DatePicker1.SelectedDate},
{Amount: Value(TextInput1.Text)},
{LikelyStartDate: DatePicker2.SelectedDate},
{AmountLeft: Value(TextInput3.Text)},
{JobStatus: JobStatus.SelectedText}
)

Let me know if you would me to post a picture of something.

Thank you for your help!

——————————
Asha Richardson
DBA
Little Rock AR
——————————

[Shailendra Turlapati]

the syntax should be

Category: Categories.Selected.Value 

Check if you bind the drop down to a list or its just values.  You can know once you type “Categories.Selected. “

Same is the case with other dropdown

——————————
Shailendra Turlapati
——————————
——————————————-

[Warren Belz]

Hi ,
I think I answered this one for you on this post
?

——————————
Warren Belz
Queensland Australia
——————————
——————————————-