Currency not in power app form from Sharepoint

Like (0) Share

Report

Posted on 2 Nov 2022 23:26:27 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:

Using Apps Using Formulas

All responses (2)

Answers (1)

Holly_CMS 523 on 04 Nov 2022 at 15:22:48

Like (0)

Report

Re: Currency not in power app form from Sharepoint

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

Thank you!
Verified answer

v-xiaochen-msft on 03 Nov 2022 at 08:00:30

Like (1)

Report

Re: Currency not in power app form from Sharepoint

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