Button to increment (missing inital value)

(0) Share

Report

Posted on by swindmiller

Just learning PowerApps so forgive me, really basic question.

I have an app that is connected to an excel file and works fine.

I have a field (OrderedValue) with a numeric value and want to increment that value with a button on the Edit Form. I added the button and set the button like this: UpdateContext({varOrdered: OrderedValue.Text + 1}) and set the Default on OrderedValue to varOrdered. This works fine once I press the button and updates the correct cell in the excel file.

The problem is when the form loads the OrderedValue field is blank and I need it populated with the current value of the excel form to start off with. I know exactly why this is not working (because I set the Default to a blank var) but not sure of the correct way to do this 🙂

Thanks, Scott

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 152,867 Most Valuable Professional on at

Like (0)

Report
Hi @swindmiller ,

Set the Default to

If( !IsBlank(varOrdered), varOrdered, Parent.Default )

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. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
swindmiller 4 on at

Like (0)

Report

Told you it was an easy question 🙂 Thanks! Scott

Was this reply helpful? Yes No
WarrenBelz 152,867 Most Valuable Professional on at

Like (0)

Report

Thanks @swindmiller ,

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
swindmiller 4 on at

Like (0)

Report

I tried doing that but keep getting this message:

Was this reply helpful? Yes No
WarrenBelz 152,867 Most Valuable Professional on at

Like (0)

Report

@swindmiller ,

That is nothing to do with the script. I found this article

Was this reply helpful? Yes No