Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Onedrive excel partial data is sent in email

(0) ShareShare
ReportReport
Posted on by 6

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.

 

Error 1.JPGError2.JPG

  • Re: Onedrive excel partial data is sent in email

    Hello, @Gowthaman!

     

    Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @v-yuazh-msft‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!


    Thank you for being an active member of the Flow Community!

     

    -Gabriel
    Flow Community Manager

  • Gowthaman Profile Picture
    Gowthaman 6 on at
    Re: Onedrive excel partial data is sent in email

    @v-yuazh-msft,

     

    Thanks. I will try this and will confirm if the issue is resolved.

  • Verified answer
    v-yuazh-msft Profile Picture
    v-yuazh-msft on at
    Re: Onedrive excel partial data is sent in email

    Hi @Gowthaman,

     

    Please take a try to add a "Delay" to delay 5 minutes before the "Get file metadate" action in your flow to see if the issue still exists.

     

    Best regards,

    Alice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,445

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,741

Leaderboard

Featured topics