Answered

Value update

(0) Share

Report

Posted on by ABJ1s1

I'm creating an App for updating a SP list with Sales order information. And just got one last hurdle.

When a line is sent to SP by clicking Send button, I clear some of the fields like Material number and Qty, - and then I wan't my Order Item number to increase by 10

I have added for the Button in OnSelect in the end a Value, - an it is working, - meaning it does calculate my previous value by adding 10, - but it is not updating the field in the app. So next time I press Send it again sends 10. (see attachment)

What should I do to change that value in the Order Item field in the APP?

Br Anders

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi!

I am not sure what is the OrdItem if it is a variable in Power Apps maybe you could update its value
Set(ordItem;ordItem+10);
If it's a variable that is dependent from a value on SP. After submitting maybe force the refresh on the SP list.

Was this reply helpful? Yes No
ABJ1s1 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks Jose for a quick reply.

My OrdItem field is a Text Input field in the app.
And when adding the Set(OrdItem,OrdItem+10) I get 3 flow errors. 2 that are the same issue?

If I have the Value(OrdItem+10) There is no issues

Was this reply helpful? Yes No
WarrenBelz 156,454 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ABJ1s1 ,

What exactly are you trying to do here? Assuming OrdItem is a Text control, then

Value(OrdItem) + 10

will add 10 to its Value. The Set() command sets a Variable - you cannot set a control value with it. If OrdItem is a field, is it Numeric or Text? Are you trying write the value to your list?

Was this reply helpful? Yes No
ABJ1s1 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi WarrenBelz
Yes, - my OrdItem is a Text Input field in the App and Format is set to Numbers
When adding your string above I need to add extra brackets to avoid errors, - so it looks like this: Value((OrdItem) + 10)
And it is calculation correctly, - but does not update the field in the app. It stayes at 10.
I do send the value from the field to my sharepoint list. And the Idea here is when I create another line in the SP for the same Customer it should get Order Item number 20, 30... etc. I have an unique Identification column in the SP list that will be the same as long as my new entry is done on the same date and with the same customer (ddmmyyyy_[Customerno])

Was this reply helpful? Yes No
ABJ1s1 48 on at

Like
a
(0)

Report
Copy link

Link copied!

I ended up creating Variable with SET function.
So it's is working now.
Thanks for the help.

Was this reply helpful? Yes No