Missing data when sending a Onedrive excel file using power automate

Hello,

I need some help! I am trying to create an Excel in OneDrive and send it as an email attachment. When I look at the Excel file in OneDrive - all the data is there. When I open the Excel file from my email, I only see the first record.

I did put a delay in but it did not help.

Any help would be greatly appreciated!!!

Kevin

Here is my app flow logic:

Trigger - When email is received
- Subject – PO Received
- Has PDF attachment
Run Script
- Delete all rows in Email PO Template file/table
Current Time
Convert Time Zone
- Format date
Apply to each
- Create File
  - Create an archive file of received PDF
Apply to each 3
- Extract the information
  - Using the AI Model – PO Extraction
- Apply to each 4
  - Add a row into a table
    - into Email PO Template file/table
List Rows present in a table
- Email PO Template file/table
Get file metadata
- Email PO Template file/table
Get the content
- Email PO Template file/table
Send an email (v2)