Answered

Possible to force currency entered in increments?

(0) Share

Report

Posted on by asmith2

Hi all! I have a form that serves as a cash order. I have text boxes that update the SharePoint list with the amount of denominations they need. The denominations need to be in certain increments, however.

For instance,

Ones - increments of $1,000

Twos - increments of $2,000

Fives - increments of $5,000

Tens - increments of $10,000

Twenties - increments of $20,000.

I know you can test for a value in-between numbers, but I'm not sure how to enforce that when the number can be so many different options. I have an error box that I'm trying to implement this idea into the visible function. Anyone do something like this?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Bilakanti 1,226 on at

Like
a
(0)

Report
Copy link

Link copied!

@asmith2 Can you send me the screenshot of what you are trying to achieve.

Was this reply helpful? Yes No
asmith2 39 on at

Like
a
(0)

Report
Copy link

Link copied!

So the value entered needs to be incremented by the specific amounts under it. So the value in Ones must be in increments of $1,000. If a user entered $1,200 they'd get an error because that's not a $1,000 increment. It would only accept $1,000 , $2,000 , etc.

Was this reply helpful? Yes No
Verified answer

zmansuri 6,048 Super User 2024 Season 1 on at

Like
a
(3)

Report
Copy link

Link copied!

Mod will give you remainder. If remainder is 0 that mean is divisible by 100 and not error. If it is not zero then error.
You can customize this logic anyway you want

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @asmith2,

Do you means that you want to each Text input add increments based on the specific number?

Could you please share a bit more about the scenario?

I think the Mod() could achieve your needs.

I think you could set the OnChange property of each TextInput control as below:

If( Mod( Value(TextInput4.Text), 1000 ) <> 0, Notify( "Please incremented by the specific amounts!", NotificationType.Error ) )

Note that you could replace the 1000 within the Mod() function with another specific number as you expect.

Check if this could help you.

Regards,

Qi

Was this reply helpful? Yes No
asmith2 39 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect, thank you!

Was this reply helpful? Yes No