Power Platform Community Forum Thread Details

Patch(Tabela3_2; LookUp(Tabela3_2; Equipamento = varEquipamento.Equipamento); {EstoqueAtual: varEstoque});; Notify("Saida efetuada com sucesso");;Navigate(TelaInicial;ScreenTransition.Cover)

afternoon guys i would like to make some questions

as you can see i'm tried a lot to correct the patch function error

everytime i submit the form to the excell its update the old data, but also build a new line with the last input

can you guys answer me how to it not build a new line ?

Categories:

Building Power Apps

@Anonymous

First of all, Excel is a terrible datasource. SharePoint is much better and I would recommend that you move your data there. Your formula will notify that there is a success and navigate to another screen whether the patch works or not. Also, Ideally, the Lookup should identify a single record in your table. It is much better to use an ID value in the lookup and your table should have a sequence of numbers for each record that is not replaced or changed. If not that , then each item should have a product code and that should be used in the LookUp(). However, given what you have, I suggest the following:

Patch(
 Tabela3_2;
 LookUp(Tabela3_2; Equipamento=varEquipamento.Equipamento);
 {
 EtoqueAtual:varEstoque
 }
 );;
 If(
 // check if there were any errors when the patch was submitted
 !IsEmpty(Errors(Tabela3_2));
 // if true, show any error message
 Notify(
 Concat(Errors(Tabela3_2); Column&": "&Message);
 NotificationType.Error
 );
 // else, notify success and navigate away to next screen
 Notify("Saida efetuada com sucesso"; NotificationType.Success);;
 Navigate(TelaInicial;ScreenTransition.Cover)
 )