Unlock the Secret: Effortlessly Extract Numbers from Strings with Power Automate!

Welcome to my channel. In today's tutorial, I'll be demonstrating how to extract numeric values from a string using Power Automate. 📊

Recently, I encountered a challenge where I needed to extract the price from a receipt scan. The receipt contained both numeric and non-numeric values, making it a bit tricky to isolate just the numbers. To solve this, I designed a Power Automate flow that efficiently extracts only the numeric values from the receipt.

Code for "Append to string variable" flow action:

concat
(
if(equals(substring(outputs('compose'), variables('Counter'), 1), '0'), '0', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '1'), '1', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '2'), '2', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '3'), '3', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '4'), '4', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '5'), '5', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '6'), '6', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '7'), '7', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '8'), '8', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '9'), '9', ''),
if(equals(substring(outputs('compose'), variables('Counter'), 1), '.'), '.', '')
)

📌 Chapters:
0:00 Introduction
0:21 Overview of the Challenge
1:10 Setting Up Power Automate to Extract Numbers only
5:20 Testing the Flow
6:45 Conclusion

🔴 *** Stay Connected ***

🔎 HASHTAGS 🔎
#powerautomate
#regularexpressions
#microsoft365