Unanswered

Extract Outlook table data in excel table

(0) Share

Report

Posted on by KamleshKadu

Hello everyone.

I need one help in extracting data from outlook. i manage to extract all data from outlook but i stuck at place. I am not able to understand how to extract data which have no specific end character. i need help in extracting last column data pls someone help me.

I am using function like:

1. When a new email arrives

2. HTML to text

3. add a row into a table

My data is like

Region : South

trim(first(split(last(split(body('Html_to_text'),'Region:')),'Branch')))

Branch Name: 445

trim(first(split(last(split(body('Html_to_text'),'Branch Name:')),'Branch Code:')))

RM Name: Rohit Nair

trim(first(split(last(split(body('Html_to_text'),'RM/BSSM Name:')),'RM ID:')))

PS ID: 2003272

Please help in getting ps id number.

Thank you

All responses (8)

Answers (0)

KamleshKadu 9 on at

Like (0)

Report

Re: Extract Outlook table data in excel table

I need expression which i can add in ps id column.
KamleshKadu 9 on at

Like (0)

Report

Re: Extract Outlook table data in excel table

Hello, I am new in power automate. can you please help me with this. project stuck on that part only.
v-yetonggu-msft on at

Like (0)

Report

Re: Extract Outlook table data in excel table

Hi @KamleshKadu ，
When you finished writing the formula, did you click the update button?
Please check the formula of your ‘PS ID’ column.

Best Regards,
Sunshine Gu
KamleshKadu 9 on at

Like (0)

Report

Re: Extract Outlook table data in excel table

I am not able to add data in excel
v-yetonggu-msft on at

Like (0)

Report
Re: Extract Outlook table data in excel table

Hi @KamleshKadu ,
Because there are many newlines, an error will occur when you use decodeUriComponent('%0A') to locate, so you'd better find a special and fixed index field.
You can also try this:
trim(split(split(outputs('Html_to_text')?['body'],'*')[0],'PS ID: ')[1])

Best Regards,
Sunshine Gu
v-yetonggu-msft on at

Like (0)

Report
Re: Extract Outlook table data in excel table

Hi @KamleshKadu ，
Is your PS ID number a fixed length?
If so, please try this expression:

substring(split(outputs('Html_to_text')?['body'],'PS ID: ')[1],0,7)

Best Regards,
Sunshine Gu
KamleshKadu 9 on at

Like (0)

Report

Re: Extract Outlook table data in excel table

You have add HI in text but that is body text and that wont fix i need ps id and its number after that number there will be blank or other text. and request you to pls suggest expression
v-yetonggu-msft on at

Like (0)

Report
Re: Extract Outlook table data in excel table

Hi @KamleshKadu ，
Please try this expression:
trim(split(split(body('Html_to_text'),'HI')[0],'PS ID:')[1])

Best Regards,
Sunshine Gu