Hi @Anonymous ,
Could you please share a bit more about the 'Criado por' field within your CDS Entity (TSSR)? Is it a Option Set column or a LookUp type column?
Does the Edit form connect to your 'TSSR' Entity data source?
The 'Criado por' field is a "Created By" field in your 'TSSR' Entity, is it true? Actually, the "Created By" field is a System field in CDS Entity, we do not need to specify a proper value for it. The "Created By" field value would be populated with current sign in user automatically by CDS System.
If you specify a value for the "Created By" field, the following error message would be shown up:
so do not specify the System Field within the '{}' part of your Patch function. Please modify your formula as below:
Patch(
TSSR;
Defaults(TSSR);
{
'Dimensões da antena': DataCardValue3.Text;
Data_de_preenchimento: DateValue1.SelectedDate;
Energia: DataCardValue4.Text;
'Endereço de Correio Eletrónico': DataCardValue6.Text
}
)
Please also remove the 'Criado por' field data card from your Edit form, make sure you could not specify value for the "Created By" field.
If you just want to specify a normal LookUp field or Option Set field within the "{}" part of Patch function, please take a try with the following formula:
Patch(
TSSR;
Defaults(TSSR);
{
'Dimensões da antena': DataCardValue3.Text;
Data_de_preenchimento: DateValue1.SelectedDate;
Energia: DataCardValue4.Text;
'Endereço de Correio Eletrónico': DataCardValue6.Text;
OptionSetField: OptionSetFieldComboBox.Selected.Value;
LookUpField: LookUpFieldComboBox.Selected
}
)
If the Edit form is connected to the 'TSSR' Entity data source, you could also modify your formula as below:
Patch(
TSSR;
Defaults(TSSR);
EditForm1.Updates
)
Note: Please remove the System fields (e.g. Created On, Created By, Modified, Modified By, ... etc) data cards from your Edit form.
Best regards,
