web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Use Button to update N...

Power Apps

Suggested Answer

Use Button to update Numeric Value in Text Field of SharePoint list.

(0) Share

Report

Report

Posted on by LF-28030123-0

Hi All,

I have a SharePoint list which has a power apps front end. i am trying to configure so that when a button is selected it will update the value of one of the fields in the SharePoint list to one less than the current.

So in PowerApps I have an edit form, with data pulled from the SharePoint list:

I can edit the form manually by retyping the value and saving the form which will update the form but i want to use an add/ subtract button to increase the value/quantity.

i have tried a line of the below:

DataCardValue13.Text = Value.Number-1)

which displays a warning message :

any assistance would be appreciated.

thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Suggested answer

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi #@LF-28030123-0

Change it to this

DataCardValue13.Text = Text(Value.Number-1)

So that it converts the value to text

Was this reply helpful? Yes No
Suggested answer

MS.Ragavendar 6,961 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@LF-28030123-0,

Update the form value before saving, use a variable Button to Decrease Value just add Value() function which help you to store the numeric value

UpdateContext({varQuantity: Value(DataCardValue13.Text) - 1});

Default Value of the Text Box

If(IsBlank(varQuantity), Parent.Default, varQuantity)

Patching to SP

Patch(

YourSharePointList,

YourForm.LastSubmit,

{ Quantity: varQuantity }

)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item

Was this reply helpful? Yes No

Join the conversation