I am trying to build a flow which takes a set of records from Oracle database and then overwrite the existing data in Excel table which is in Onedrive for business and then send this excel file in email. I am able to delete the excel rows using Apply to each loop and also insert records of Oracle data using another Apply to each loop. I see the actual file in Onedrive is updated properly.
But when I checked the email, the excel attachment has only partial data. Eg. there are 25 records in the actual file, but it only sends with 2 records. And when I run the flow again, this time it sends the sheet with 23 records.
I am new to flow and not sure what is the issue here, there are no errors as well. Should we do some refresh before sending email? I have provided the flow details below, I have omitted the top part with trigger (Reoccurence) and the step to take the data from Oracle database.
