I am using PowerApps to create the form for a SharePoint list. I have 2 columns that are fomatted as currency in the original list, with a 3rd that's a calculation of the difference. I've seen solutions for text fields used for numbers wherein they use a formula to change the field to start with a dollar sign and end with .00. This won't work for me. Is this being added to PowerApps soon?
This is for a new list; however, I have a number of SP lists in InfoPath that we want to convert to PowerApps and we must have that functionality in order to do that.
Solved! Go to Solution.
Hi @JC-8
Could you please try this formula expression?
Text( CurrencyColumnName, "[$-en-US]$ #.00" )
More information:
Best Regards.
Yumia
Hi @JC-8 ,
Have you tried testng @v-yuxima-msft solution?
On PowerApps are you using a Gallery to display the SharePoint list or a Form?
If you're using a Gallery:
For 2nd Column Just add TextInput or Label and change the Text() Property to: (for first Column)
Text( CurrencyColumn1, "[$-en-US]$ #.00" )
For 2nd Column add another TextInput or Label and change the Text() Property to :(for second Column)
Text( CurrencyColumn2, "[$-en-US]$ #.00" )
If you're using Form:
Find the DataCard InputBox and change the Text() Property to:
Text( Parent.Default, "[$-en-US]$ #.00" )
----------------------------------------------------------------------------
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.
Hi @JC-8
Could you please try this formula expression?
Text( CurrencyColumnName, "[$-en-US]$ #.00" )
More information:
Best Regards.
Yumia
I'm really new to PowerApps -- can you tell me where that formula goes?
Hi @JC-8 ,
Have you tried testng @v-yuxima-msft solution?
On PowerApps are you using a Gallery to display the SharePoint list or a Form?
If you're using a Gallery:
For 2nd Column Just add TextInput or Label and change the Text() Property to: (for first Column)
Text( CurrencyColumn1, "[$-en-US]$ #.00" )
For 2nd Column add another TextInput or Label and change the Text() Property to :(for second Column)
Text( CurrencyColumn2, "[$-en-US]$ #.00" )
If you're using Form:
Find the DataCard InputBox and change the Text() Property to:
Text( Parent.Default, "[$-en-US]$ #.00" )
----------------------------------------------------------------------------
Thanks,
K-A-R-L
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you thought this post was helpful, please give it a Thumbs Up.
User | Count |
---|---|
228 | |
103 | |
98 | |
57 | |
31 |
User | Count |
---|---|
283 | |
113 | |
107 | |
63 | |
63 |