cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
RobertD
Level: Powered On

How to update numbers SharePoint list from PowerApps

2019-08-11_23h25_47.jpg

2 ACCEPTED SOLUTIONS

Accepted Solutions
shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD 

 

onSelect of the submit/save button you can write the patch method as:

 

Patch('SP List', First(Filter('SP List', ID = ListItemID)),{Utlevert: Value(Utlevert.Text) + Value(Antall.Text)})

 

Assuming the controls names are as shown in the screen shot shared.

#1 - Antall.Text

#2 - Utlevert.Text

 

Thanks.

 

 

shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD 

 

as material no is unique you can use this column while updating

 

Patch('SP List', First(Filter('SP List', 'material no' = 'CONTROLNAME.Text')),{Utlevert: Value(Utlevert.Text) + Value(Antall.Text)})

 

#CONTROLNAME - the label control which hold the material no value

 

Thanks. 

7 REPLIES 7
shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD 

 

onSelect of the submit/save button you can write the patch method as:

 

Patch('SP List', First(Filter('SP List', ID = ListItemID)),{Utlevert: Value(Utlevert.Text) + Value(Antall.Text)})

 

Assuming the controls names are as shown in the screen shot shared.

#1 - Antall.Text

#2 - Utlevert.Text

 

Thanks.

 

 

RobertD
Level: Powered On

Re: How to update numbers SharePoint list from PowerApps

Thanks  shailendra74.

but I wonder what is: ID = ListItemID??? 

shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD  

 

When you patch(update) a list item in SP List, you need to provide the condition which List Item you want to update.

 

ID = The autogenerated number in the SP List, you can also consider a unique column value in you SP List

ListItemID = Value of the list item (here ID) which you want to update.

 

Thanks.

RobertD
Level: Powered On

Re: How to update numbers SharePoint list from PowerApps

2019-08-12_16h01_13.jpg

shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD 

 

Per your previous screen shot you want to add 1 & 2.  If so, you can do as mentioned earlier.  And per updated screen shot you can use material no in place of ID.

 

Or from List settings, you can get the ID:

 

Screenshot 2019-08-13 at 5.37.16 AM.png

 

Thanks.

RobertD
Level: Powered On

Re: How to update numbers SharePoint list from PowerApps

This is a warehouse system.
The case is that I want to log all the items that goes out of the warehouse.
The value of AntallLog should be added to VareLog and then update the "Utlevert".
For example: VareLog is showing the current number of items in the warehouse. I add 1 item to AntallLog (this means that im taking out a item from the warehouse). This should add the value to "Utlevert" and update it with +1 item. 

shailendra74
Level 8

Re: How to update numbers SharePoint list from PowerApps

Hi @RobertD 

 

as material no is unique you can use this column while updating

 

Patch('SP List', First(Filter('SP List', 'material no' = 'CONTROLNAME.Text')),{Utlevert: Value(Utlevert.Text) + Value(Antall.Text)})

 

#CONTROLNAME - the label control which hold the material no value

 

Thanks. 

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

SecondImage

PowerApps Monthly Community Call

Tomorrow, September 18th at 8am PDT

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Users Online
Currently online: 303 members 4,733 guests
Please welcome our newest community members: