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.
The error yes and I changed the fields to numbers and did the "$" & Text(display.parent, "0.00") and it works!!
Thank you!
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
WarrenBelz
791
Most Valuable Professional
MS.Ragavendar
410
Super User 2025 Season 2
mmbr1606
275
Super User 2025 Season 2