cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Update Function Help

Hey Guys, i need update a row in a excel file with update function, but when i try to update appears the message "__PowerAppsId__:Campo obrigatório"

 

Here is my code:

 

Update( Credential;
First( Filter( Credential; Username = InputUser2.Text) ); {Username: InputUser2.Text; Password: InputNewPassword.Text})

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Update Function Help

@Anonymous 

Sorry - typo!

 

Patch(Credential;
           Lookup(Credential; Username = InputUser2.Text);
           {
             Username: InputUser2.Text; 
             Password: InputNewPassword.Text
           }
     )
_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

4 REPLIES 4
Super User
Super User

Re: Update Function Help

@Anonymous 

The Update function will update an entire record, and as such, will require all fields be supplied.

You might want to consider changing to the Patch function for this:

 

Patch(Credential;
           Lookup(Credential; Username = InputUser2.Text) );
           {
Username: InputUser2.Text; Password: InputNewPassword.Text } )

I hope this is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Anonymous
Not applicable

Re: Update Function Help

@RandyHayesI try to use your code but appears the message " Unexpected Characters. Characters are used in the formula unexpectedly."

 

 
 
Highlighted
Super User
Super User

Re: Update Function Help

@Anonymous 

Sorry - typo!

 

Patch(Credential;
           Lookup(Credential; Username = InputUser2.Text);
           {
             Username: InputUser2.Text; 
             Password: InputNewPassword.Text
           }
     )
_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.

View solution in original post

Anonymous
Not applicable

Re: Update Function Help

@RandyHayesthanks man, its help me a lot.

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,198)