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

Categories:

Using flows

I have the same question (0)

All responses (8)

Answers (0)

v-yetonggu-msft on at

Like (0)

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

Best Regards,
Sunshine Gu

Was this reply helpful? Yes No
KamleshKadu 9 on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
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

Was this reply helpful? Yes No
KamleshKadu 9 on at

Like (0)

Report

I am not able to add data in excel

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
KamleshKadu 9 on at

Like (0)

Report

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

Was this reply helpful? Yes No
KamleshKadu 9 on at

Like (0)

Report

I need expression which i can add in ps id column.

Was this reply helpful? Yes No