Goodmorning everybody!
I am working on a challenging problem. I am implementing Dynamics 365 CE and I need to convert numbers (In a currency field) into letters (In a text field). I am trying to do it through MS Flow. I have done something like that:
When a record is created (Receipt)
Compose: input=Amount field
Compose 2: input= string(output('compose'))
Update a record
The step 3 isnt working. Right now, "20" is translated by... "20". I want here to translate "20" to "twenty".
Extra bonus points if it's translated in French!
What expression do you think I should use for my third step?
Many thanks in advance for your help!
Loïs
Solved! Go to Solution.
Hi!
For information, we have finally find an easiest way to do so.
We have created a Javascript, that trigger "OnChange" of the total amount. The Javascript convert the number into words and save it to another fields called "Total amount in Words".
Despite the -many- grammatical complexities of the french language, that was fairly easy to do so. THe process is now synchronous, which is an advantage for the end users.
Thanks for your help on that part!
Kind regards,
Loïs
Hey @LoisBarbassat
I believe there is no direct way to translate a number to words in Flow. There is a way in PowerApps though and you can follow this blog for that.
You can also setup a custom connector and build an API to do this. A readily available API for this is here:
https://github.com/BitWeb/number-to-words-api
Hope this Helps!
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
Hi @yashag2255 ,
Many thanks for your help!
This is actually very useful, I will dig that more in details,
Thanks
Hi!
For information, we have finally find an easiest way to do so.
We have created a Javascript, that trigger "OnChange" of the total amount. The Javascript convert the number into words and save it to another fields called "Total amount in Words".
Despite the -many- grammatical complexities of the french language, that was fairly easy to do so. THe process is now synchronous, which is an advantage for the end users.
Thanks for your help on that part!
Kind regards,
Loïs
Hi everyone,
I'm newie using Power Automate/Flows, could you share more details how to get this?
I need to convert number to text (spanish).
Appreciate your help!
Rgds, Marky
User | Count |
---|---|
35 | |
15 | |
14 | |
12 | |
10 |
User | Count |
---|---|
42 | |
30 | |
26 | |
14 | |
12 |