web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details
Power Apps - Building Power Apps
Answered

Possible to force currency entered in increments?

Like (0) ShareShare
ReportReport
Posted on 4 Jun 2021 05:22:04 by 39

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?

I have the same question (0)
  • Verified answer
    zmansuri Profile Picture
    6,048 Super User 2024 Season 1 on 04 Jun 2021 at 08:12:32
    Re: Possible to force currency entered in increments?

    a.jpg

    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

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 688 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 499 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

Last 30 days Overall leaderboard