web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Send Updated Excel-Fil...
Power Automate
Unanswered

Send Updated Excel-File via Flow attaches only first row

(1) ShareShare
ReportReport
Posted on by 62

Hey Guys, 
i have an issues with one of my flows.

What i want to achieve:

-> Select specific data from a SharePoint List (The ODATA Query happens in PowerApps) - first step of the flow and works fine 🙂

-> Delete the current Rows in the Spreadsheet i use on SharePoint - fourth step of the flow and works fine 🙂
-> Paste in the queried rows -> fifth step of the flow and also works fine 🙂
-> get Metadata from updated excel file -> it seems like it only works for the first row? ID is alwas 2, no matter how many rows are in the excel file
-> get Data value -> works fine

-> send Mail with the Excel File Attached -> works fine 🙂

My Problem is, that no matter how many rows i have queried in sharepoint and afterwards added to the excel file, i always get an excel file where i only have one row (the first one of my query) in the table which is attached to the e-mail. But on the other hand if i take a look on the excel file on sharepoint it pasted the right amount of rows and updated everything well. 

Whicht step did i miss in my flow, so that the flow only send me the first row? 
Somebody has experience with these kind of problems?

I've attached the flow.


 

Flow.PNG

 

Categories:
I have the same question (0)
  • rimatos Profile Picture
    on at

    Hi @KChristoph ,

     

    Could you share a print on how you are trying to retrieve the metadata from the excel file? Are you using any filters in the advanced options?

     

    Which of these action are you using to retrieve this information?

    image.png

     

     

     

     

    It could be that the filter you are using is not retrieving the information you are expecting, or that the data format is different than you would expect.

     

    You can also consult our documentation of this connector, which contains some known limitations of the connector, that may be causing your issue.

     

     

    Let me know if this helped you in any way!

     

    Regards,

    Ricardo

  • Verified answer
    KChristoph Profile Picture
    62 on at

    Hey @rimatos

    I do not use advanced filtering, but I think I was able to solve the problem yesterday. 

    I always had the feeling that OneDrive didn't have time to save the updated file, so I added a delay of one minute after inserting the new rows... I haven't had any problems since I added this delay :-)... I deleted the rows and added only one row and I also tested it by adding up to 200 rows and always got the "queried" Excel file...
    So it seems that giving OneDrive some time will solve my problem 😄

     

    Thanks for your answer and kind regards 🙂

  • iamcstevenson Profile Picture
    50 on at

    Thanks for the idea to add a "delay" feature.  I was having a very similar problem and this resolved it.  Great job!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard