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
|Item Id||Project Id|
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!!
1.Pls enable pagination in excel connector.
2.use delay of 1 min before get file content.. excel connector takes time to sync data.
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
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.
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!
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
The Super User program for 2022- Season 2 has kicked off!