PATCH FORMULA

[Jeziel_Victor]

Hi, I would like to know what error this formula is:

Patch('Security ActionPlan1';Defaults('Security ActionPlan1';
{
Responsável:TextInput1.Text;
'Descrição do Problema':TextInput2.Text;
Ação:TextInput3.Text;
Prazo:DatePicker1.SelectedDate;
Status:Dropdown1.Selected.Value
}));;

[StalinPonnusamy]

Hi @Jeziel_Victor 

For Dropdown.Selected

Patch('Security ActionPlan1';Defaults('Security ActionPlan1';
{
Responsável:TextInput1.Text;
'Descrição do Problema':TextInput2.Text;
Ação:TextInput3.Text;
Prazo:DatePicker1.SelectedDate;
Status:Dropdown1.Selected
}));;

[v-albai-msft]

Hi @Jeziel_Victor ,

Seem that your Status column is a Choice column, if yes, you should use code like this:

Status:{Value:"Your Value"}

So try this formula:

Patch('Security ActionPlan1';Defaults('Security ActionPlan1';
{
Responsável:TextInput1.Text;
'Descrição do Problema':TextInput2.Text;
Ação:TextInput3.Text;
Prazo:DatePicker1.SelectedDate;
Status:{Value:Dropdown1.Selected.Value}
}));;

Best regards,

Allen

[Jeziel_Victor]

It didn't work, more errors appeared,

I deleted your change and the error that appears is this

[StalinPonnusamy]

Hi @Jeziel_Victor 

As I Mentioned, For the choice Column Patch command

Status:Dropdown1.Selected

[Jeziel_Victor]

It didn't work either

[StalinPonnusamy]

Hi @Jeziel_Victor

Can you please share the error information?

[Jeziel_Victor]

[StalinPonnusamy]

Hi @Jeziel_Victor 

Looks like one closing parenthesis is missing. Highlighted below

Patch('Security ActionPlan1';Defaults('Security ActionPlan1');

and remove one at the end

Refer below example

Patch('Security ActionPlan1';Defaults('Security ActionPlan1');
{
Responsável:TextInput1.Text;
'Descrição do Problema':TextInput2.Text;
Ação:TextInput3.Text;
Prazo:DatePicker1.SelectedDate;
Status:Dropdown1.Selected
});

[Jeziel_Victor]

But it is being shut down

Patch ('Security ActionPlan1'; Defaults ('Security ActionPlan1';
{
Responsável: TextInput1.Text;
'Descrição do Problema': TextInput2.Text;
Ação: TextInput3.Text;
Prazo: DatePicker1.SelectedDate;
Status:Dropdown1.Selected
}));;