Create a Flow Email to OneDrive Excel

[Venkata1989]

Dear Team,

I'm not able create proper Work Flow.

Step1: Email 

Step 2: Creating WorkFlow Email ==> One Drive Excel file

Step 3: We need to see under Body "INDIADifferent is not bad, different means possible!" but we are receiving overall mail.

Please guide me here.

Advance Thanks,

Venkata.

[v-mingkz-msft]

Hi @Venkata1989,

Do you want to extract specific string from email body?

I notice that the contents you want to extract is not significantly different from the rest.

Therefore, I suggest you use some specific character to wrap the string you need.

For Instant, I use '[]' wrap the string and use substring function to extract from it.

sub(indexOf(variables('string'),']'),indexOf(variables('string'),'['))

substring(variables('string'),add(indexOf(variables('string'),'['),1),sub(variables('length'),1))

Best Regards,

Kyrie

[Venkata1989]

@v-mingkz-msft 

Please guide me were we need to store sting before your 1st step

[Venkata1989]

@v-mingkz-msft 

Please respond waiting for your response.

Thanks,

Venkata,

Cell: +91 8309454052.

[v-mingkz-msft]

Hi @Venkata1989,

No, my string is used to simulate your email body.

[Venkata1989 · Accepted solution]

@v-mingkz-msft 

As per your suggestion created below flow please guide me.

I'm getting on like below error :"he length of substring can't be longer than '255' which is the length of the source string.".

Please guide me.

Please check below error image.

[v-mingkz-msft]

Hi @Venkata1989,

Please show me your body preview string, I could not repeat your issue.

[Venkata1989]

@v-mingkz-msft 

Please find below Body Preview string:

Image:

Word:

Hi Venkata Ravi Kumar Iyanavolu.
Power BI
Venkata Ravi Kumar Iyanavolu mentioned you in a comment on Mock Dashboard_quality_v8 (1)

Venkata Ravi Kumar Iyanavolu Trending News on Accenture Portal

Open Comments >

Privacy Statement

Micro

plz guide me.

[v-mingkz-msft]

Hi @Venkata1989,

You should add the '[' before what substring you want to extract, and ']' after it.

Following is my email.

My compose.

Best Regards,

Kyrie

[Venkata1989]

@v-mingkz-msft  but we need dynamically right.

[v-mingkz-msft]

Hi @Venkata1989,

You must make a rule or make some difference between the text you want to extract and other email body, otherwise it will not be recognized.

Add '[' is my suggestion.

Best Regards,

Kyrie

[Venkata1989]

@v-mingkz-msft  

Yes you are right but large string not supporting. 

[Venkata1989]

@v-mingkz-msft 

Thanks for your valuable suggestions, we are implemented all those things but facing small blocker getting on updating in Excel file both.

Power BI Workspace Image:

Flow Image:

OneDrive Excel Image:

Getting 2 out puts at a time, 1 belongs to required one another one HTML format.

Please guide me here.

Thanks,

Venkata.