Currency not in power app form from Sharepoint

(0) Share

Report

Posted on by Holly_CMS

523

Hi,

I just used the Power Apps integration from the Sharepoint list. The 2 currency fields are in the list. Why am I not able to get this formatted in the form? It was throwing the "the value '$' cannot be converted to a number." error.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-xiaochen-msft on at

Like (1)

Report

Hi @Holly_CMS ,

Do you have such an error?

This is because currency column is number column in SharePoint, only numbers can be saved.

To avoid this error, need to make the saved data is number. You can set the 'Update' of the Card in the form so that the content of the submission is only numbers.

I made a sample for you.

Create a list in SharePoint, and ‘ESTCost’ is a currency column.

Create a form and set the Textinput ‘DataCardValue8’ to the following format:

"$" & Text(ThisItem.ESTCost,"0.00")

Set the Update of the Card. Only the content after the symbol '$' is submitted.

Value(Mid(DataCardValue8.Text,2))

After testing, no error is reported:

Best Regards,

Wearsky

Was this reply helpful? Yes No
Holly_CMS 523 on at

Like (0)

Report

The error yes and I changed the fields to numbers and did the "$" & Text(display.parent, "0.00") and it works!!

Thank you!

Was this reply helpful? Yes No