MS Flow Process Does Not Grab Entire Email Body

[Anonymous]

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 Id	Login
1	login email

Tasks

Item Id	Project Id
1	10
2	11
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!!

[Anonymous]

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

[Hardesh15]

@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]

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

[chsanche]

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!

[Anonymous]

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.