cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

MS Flow Process Does Not Grab Entire Email Body

Hi,

 

As the title says, my flow process does not gather the entire body of an email in outlook.

 

Every Monday, internal members of my organisation get hundreds of emails in the same format. These emails each have two tables in the following format.

 

Report from 2020-06-15 00:00:00 to 2020-06-21 23:59:59

User IdLogin
1login email

 

Tasks

Item IdProject Id
110
211
3

12

 

The top table will always have one row. However, the bottom table can have multiple rows ranging from 10 - 100+. 

 

I need to gather both top and bottom rows in an excel spreadsheet for easier review.

 

My current flow process does not grab all the rows of the bottom table if there are over 100+ rows - it seems to stop around row 70. I am unsure if there is a character limit to MS flow or something to do with time duration.

 

Here is my current flow process:

 
 
 
 

Does anyone have any advice? Thank you!!

5 REPLIES 5
Anonymous
Not applicable

For some reason, did not input the flow process....

 

Capture.PNG

Hardesh15
Super User
Super User

@Anonymous 

Steps.

1.Pls enable pagination in excel connector.

2.use delay of 1 min before get file content.. excel connector takes time to sync data.

 

Thanks 

Hardesh

 

Anonymous
Not applicable

Hi @Hardesh15 

 

Thank you for your quick reply! How do I enable pagination in excel connector? I don't see a pagination option in 'add row to table' portion of the flow process

Hi @Anonymous 

 

From your screenshot, you are only adding 1 row into the Excel Table with the entire body of the email between the fields in your Excel: Login, Top and Bottom. Also, the pagination option is for "Get" actions, the action that you are using with the Excel connector doesn't have a pagination setting.

 

Best Regards

--

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

If this post helps you give a :thumbs_up: and if it solved your issue consider Accept it as the solution
Anonymous
Not applicable

Thank you @chsanche ! Is it possible to get each individual row of the table into excel? Yes, I do just dump the plain text into one cell and then split it out by row / column in Python. From my investigation, the way the table is formatted now makes it harder to add to excel.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (3,914)