Saving datacardvalue as number

(0) Share

Report

Posted on by rawatn

Hello All,

This is my first post.

I have a collection from a sql database table. Which is collected as soon as the screen is visible.

In this screen I am collecting order details for customers. I am finding difficulty in saving the data form to collection.

In the collection I have a column pieces (number of items ordered). In sql database this is "INT" (Integer) type.

When I collect my collection it is giving incompatible type error.

Collect(ProductDetails, { productname : productname.Text, productcode : productcode.Text, pieces : pieces.Text });ResetForm('Form-proddetails');NewForm('Form-proddetails')

How can I save the text in as number?

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@rawatn

My assumption is you want to save the pieces field as a number

pieces : pieces.Text

To convert to a number we can use the VALUE function

pieces: Value(pieces.Text)

We can also ROUND the value if needed

pieces: Round(Value(pieces.Text))

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
rawatn 9 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks a lot. I was strangling the code for a while.
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@rawatn

You're welcome. Glad I could get you unstuck.