Announcements
Hi,
I'm not being able to properly extract prices from a website to Excel.
If I extract 30.000€ it is imported as 30 €.
Anyone know how to solve this?
I would imagine that this is an underlying setting built into power automate where the default number format is identified by the system. If you are on an American Region Power Automate setting, and trying to use this feature, this should work as a workaround: 1) Extract the text (30.000) as a variable2) Use "Replace Text" to replace all periods with commas(30,000)3) Use "Convert text to number" (30,000)
Best of luck. If you want to provide the site, and it has public access, I can give it a shot, and maybe find other option.Update Edit 7/13/2021:
For #2, Use "Replace Text" to replace all periods with nothing.
The code for nothing in the Replace with field is "%%"
Thank you to @fraenK for the solution found here: https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Remove-delete-text-in-Power-Automate-Dedktop/td-p/869141
Hi Michael,
Thanks for your help! It worked, however, it's being added a blank paragraph after the price:
I don't have any experience with this. If you have converted the text to a number and it is still showing the trailing paragraph, try this either before or after converting it to a number.Replace text:Text to find: \n (this is a regular expression for a new line)
Use Regular Expressions: True
Replace with: .00 (assuming all your amounts are full dollar amounts, this should work as it won't affect the number)
Activate Escape Sequences: True
If this doesn't work, I am not sure. I am pulling from the manual. Replace text information is here:https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/text#replace
Regular expression information is here:https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expression-language-quick-reference
Again, if the text has already been converted to a number, it shouldn't have a trailing paragraph, so that part is hard to troubleshoot. Best of luck.
Michael, after replacing the text ("." by " " ), I tried converting the number into text and the new line disappeared...
Thanks for your help!
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
David_MA 262 Super User 2026 Season 1
11manish 167
Haque 154
