Incremental values

(0) Share

Report

Posted on by R Bakker

725

I have an ordering app with Excel as the data source.

I have a minimum quantity column in my Excel file, and a current quantity column. I can update my current quantity. So minimum quantity - current quantity = the amount I need to reorder. So that's good. But some of our suppliers can supply in lot amounts. Like 6 bottles of hand sanitiser or 90 scrubber pads.

So the objective is when the current quantity is below minimum it reorders in lots of. E.g suppliers distributes in lots of six and my minimum qty is 6 bottles, current quantity is 5 bottles, reorder 6.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@Corissandageri

I don't see any question here, only a description of your app. What's your question?

Was this reply helpful? Yes No
R Bakker 725 on at

Like (0)

Report
Copy link

Link copied!

What would the expression look like to automatically order in lot amounts? So if I had an item that gets supplied to me in lots of six, and I currently have only 5, that it would reorder 6.
Sorry, I'm struggling to make myself clear.

Was this reply helpful? Yes No
timl 36,682 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @Corissandageri

Maybe if you provide us a screenshot of your app with the formula and buttons that you already have, and the fields in your Excel spreadsheet that denote the batch quantities, we can more easily help you. That way, we can more specifically let you know the changes that you need to make in order to accomplish this.

Was this reply helpful? Yes No