cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
phh
Helper IV
Helper IV

Problems whit editing the saw icon?

Hi
I'm having trouble getting it to work.
Maybe it's because I can not follow some instructions when mine runs in Danish

I hope you can help me

Looking forward to hearing from you 🙂

- Peter

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @phh :

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.

2.JPG

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

 

 

View solution in original post

21 REPLIES 21
v-bofeng-msft
Community Support
Community Support

Hi @phh :

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.

2.JPG

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

 

 

View solution in original post

Hallo again 🙂

It works now!
I do not quite understand why "LookUp" should be used?
Can you explain it? 

and again thanks for the help.

- Peter

v-bofeng-msft
Community Support
Community Support

Hi @phh :

LookUp(Bestilling;ID=ThisItem.Id) is used to find the record that needs to be updated in Bestilling.

Best Regards,

Bof

@v-bofeng-msft Hello again,

The Sharepoint list will no longer be updated ??? I dont understand why. I have done some different things but do not think I have changed anything. Some suggestions

- Peter

@v-bofeng-msft 

You can see a picture of the format in "OnSelect" for my "save" icon.

I'm frustrated it does not work 😞

plz help

- Peter

v-bofeng-msft
Community Support
Community Support

Hi @phh :

The formula looks fine.Are there any errors?

In addition, I suggest you to check whether lookup(xx,xxx) can find the corresponding record.

Best Regards,

Bof

@v-bofeng-msft 
Hello again, I have tried with the other fields.
I do not quite understand it with (xx, xxx).
I get no fault of the others
 

I have choice type in the liste, change it somewhat on whether it can update.



-Peter

v-bofeng-msft
Community Support
Community Support

Hi @phh :

No error indicates that the formula is not problematic, so we must consider the logic of the formula.

Now the target record you want to update is ‘LookUp(Bestilling;ID=ThisItem.Id)’. I suspect that this record does not exist in Bestilling.

Best Regards,

Bof

Hi @v-bofeng-msft 

What do you suggest should be done for it is possible?
can you show me what i can try or do you have a solution for it? 🙂

-Peter

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,334)