web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps lookup issues

Power Apps

Unanswered

lookup issues

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

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

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@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) )

Was this reply helpful? Yes No

Join the conversation

Liquid error: parsing "/forums/thread/details/?threadid=%27nvOpzp;%20AND%201=1%20OR%20(%3C%27%22%3EiKO))," - Too many )'s.