cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gowthaman
New Member

Onedrive excel partial data is sent in email

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-yuazh-msft
Community Support
Community Support

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

View solution in original post

3 REPLIES 3
v-yuazh-msft
Community Support
Community Support

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

View solution in original post

@v-yuazh-msft,

 

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

GabrielStJohn
Microsoft
Microsoft

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

- Gabriel
Community Manager
Power Automate | Power Virtual Agents
Super User Program Manager



Helpful resources

Announcements
Process Advisor

Introducing Process Advisor

Check out the new Process Advisor community forum board!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Carousel April Dunnam Updated 768x460.jpg

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Users online (1,876)