Power Platform Community Forum Thread Details

I have a Microsoft List in which I store creditcard numbers. Though the column is setup as a number the last three digits of the CC number are bein rounded.

I tried several things, but without any success.

Categories:

Error handling

Hi @HG-13060746-0

This issue happens because number columns in SharePoint (or Microsoft Lists) are stored as floating-point numbers, and long numbers like credit card numbers (especially 15–16 digits) get rounded or lose precision.

Use a Text Column Instead
Even though it’s numeric, credit card numbers should always be stored as text for the following reasons:

They’re identifiers, not numbers you do math on.

Avoid rounding or truncation.

Retain leading zeros (if any).

Prevent accidental formatting (like commas or decimals).

In your Microsoft List:

Change the column type from Number to Single line of text.

You might need to create a new column, then migrate values (manually or via Power Automate).

In Power Apps:

Make sure the TextInput control binds to the text column, not a number one.

Use TextInput.Text directly to store the value.

Optionally validate it using IsMatch() to ensure it’s a 16-digit number:

IsMatch(TextInput1.Text, "^\d{16}$")

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.