Share
ReportHi all,
First post :) (and new to PowerA)
I have been searching on here, youtube, websites, etc etc trying to find the answer, but not having much luck.
I created a simple flow in PA, to look at emails, and extract data and add to a row (table) in an excel file.
That flow picks up the: FROM \ Subject \ Data received.
I know i need to add "HTML TO TEXT" into the flow, along with BODY so it can read the email.
What i want is, is it possible to extract telephone numbers ?
My excel file (Table) has 4 columns which are: FROM | SUBJECT | RECEIVED | TELEPHONE
The first 3 fields get popuplated as its easy to tell the Flow to get that data, but i am stuck on the telephone number.
In any email that comes in, the telephone number might begin with +44 0000 000000 , or: 0208 0000000 (example) , and could be anywhere in the email.
I cant figure out how to get PA to find/identify the number so it can write it to the table in my excel file.
Is it possible to extract telephone numbers ?
First post :) (and new to PowerA)
I have been searching on here, youtube, websites, etc etc trying to find the answer, but not having much luck.
I created a simple flow in PA, to look at emails, and extract data and add to a row (table) in an excel file.
That flow picks up the: FROM \ Subject \ Data received.
I know i need to add "HTML TO TEXT" into the flow, along with BODY so it can read the email.
What i want is, is it possible to extract telephone numbers ?
My excel file (Table) has 4 columns which are: FROM | SUBJECT | RECEIVED | TELEPHONE
The first 3 fields get popuplated as its easy to tell the Flow to get that data, but i am stuck on the telephone number.
In any email that comes in, the telephone number might begin with +44 0000 000000 , or: 0208 0000000 (example) , and could be anywhere in the email.
I cant figure out how to get PA to find/identify the number so it can write it to the table in my excel file.
Is it possible to extract telephone numbers ?
Categories:
All responses (
Answers (
249
