cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nicovddusse
Advocate II
Advocate II

Filter text from incoming mail and post the result into excel

Hi,

 

I get daily internet usage logs by e-mail

 

 

Please note that you have used 5.201 GB of your in-bundle data service agreement.

 

I can retrieve the e-mail quite easily from Outlook.

 

Where do I get more info on isolating the 5.201 from the mail body so I can add it to an Excel file?

 

I've done something similar in Node-Red for extracting data from a Tweet 🙂

 

Thanks

Nico

1 ACCEPTED SOLUTION

Accepted Solutions

Problem not really solved. 

 

But for now I accept that the solution still needs to be developed and implemented 🙂

 

 

View solution in original post

6 REPLIES 6
abm
Super User III
Super User III

Hi @Nicovddusse,

 

Can you please explain a little bit about isolating 5.201 info and adding to an excel sheet?

 

Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Hi, the mail body contains the daily usage. I want to log this in Excel

 

For this, I need to extract the usage (number 5.201) from the mail body.

 

How do I do this?  Just a pointer to the info would be great 🙂

 

 

Hi @Nicovddusse,

 

I am not aware of Flow supports any string functions? You could add a filter in the email body contains a text you looking for and add the email body in an excel sheet. Use some excel macros to find the number you want.

 

Other option is you could do a custom API (Developer skills you need) to pass the input parameter as email body. Do the string manipulation in your custom code and return the value back to flow.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Ok.  Can't be done currently in an easy way 🙂

 

Would be nice to have a FUNCTION block as in Node-Red where one could write custom code 🙂

 

 

Hi @Nicovddusse,

 

You can share your ideas here https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

Thanks

 

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

Problem not really solved. 

 

But for now I accept that the solution still needs to be developed and implemented 🙂

 

 

View solution in original post

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (37,094)