Hi @Anonymous :
Firstly,let me explain why you encounted this problem.
Some areas use "," as a list separator, but some use ";".
In the formula you provided, both ";" and "," are used as the list separator, which will inevitably lead to errors.In the picture below, the symbols I marked with a red paintbrush and those marked with a green paintbrush belong to different regions.
The correct formula must be one of the following two codes, please try:
Case1:Some areas use ";;" as a separator
Select(Parent);;
Patch(
Bestilling;
LookUp(Bestilling;ID=ThisItem.Id);
{
‘Navn (Title)’:TextNavn.Text;
'CVR nr':TextCVR.Text;
Adress:TextAdress.Text
}
);;
Set(ItemId;0);;
Case2:Some areas use ";" as a separator
Select(Parent);
Patch(
Bestilling,
LookUp(Bestilling,ID=ThisItem.Id),
{
‘Navn (Title)’:TextNavn.Text,
'CVR nr':TextCVR.Text,
Adress:TextAdress.Text
}
);
Set(ItemId,0);
I think this link will help you a lot:
Formula separators and chaining operator
Best Regards,
Bof
