Answered

Problems whit editing the saw icon?

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

{9114235E-D48D-43...

I have the same question (0)

All responses (21)

Answers (1)

Verified answer

v-bofeng-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :
LookUp(Bestilling;ID=ThisItem.Id) is used to find the record that needs to be updated in Bestilling.
Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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

{7E68B994-BB96-4D...

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report
Hi @Anonymous :
You can try using this formula to update the first record in Bestilling.
If it succeeds, then my reasoning is correct.This means that you cannot use ID as a match.

Select(Parent); Patch( Bestilling, First(Bestilling), { ‘Navn (Title)’:TextNavn.Text, 'CVR nr':TextCVR.Text, Adress:TextAdress.Text } ); Set(ItemId,0);

Best Regards,
Bof

Was this reply helpful? Yes No