Skip to main content

Notifications

Power Automate - Using Flows
Unanswered

Flow writes less rows than in the source file

(0) ShareShare
ReportReport
Posted on by 85

Hello,

 

I am using a flow to transform and add new columns from one Excel to another.

 

On file upload (Excel) to SharePoint, the flow beggins by grabbing the table from the Excel and writing it down to a SharePoint List.

The contents of Sharepoint list is then loaded and using Write function some data are transformed (ex. input = 01; output = 0001) and written to the list.

The updated contents is loaded and then the flow proceeds to write the List contents into an Excel template.

 

The issue I am having is that the input file has 200 rows but in the new Excel generated, there are only 186 rows.

 

I turned on the pagination and set the limit to 5000 rows so that shouldn't be an issue. I don't understand how I am losing 14 rows in the process.

 

Any ideas?

 

Thank you!

  • creativeopinion Profile Picture
    creativeopinion 10,056 on at
    Re: Flow writes less rows than in the source file

    @JanDras Can you share a screenshot of your flow? 

     

    In the meantime you might find these troubleshooting tips in this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

     

    In this Power Automate tutorial, I explore 5 frequently asked questions that pop up when troubleshooting a flow. If you’d like to to level up your Power Automate flow skills and learn how to troubleshoot your Power Automate flow—this tutorial is for you!

     

    IN THIS VIDEO:

    ✅ How to troubleshoot a false Condition action result

    ✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

    ✅ How to troubleshoot an Apply to Each action that isn’t looping through

    ✅ How to troubleshoot a skipped Apply to Each action

    ✅ How to troubleshoot a Filter Query

    ✅ How to use a SharePoint yes/no column in a Filter Query

    ✅ How to use Compose actions to troubleshoot a Power Automate flow

    ✅ How to troubleshoot multiple emails being sent

    ✅ How to troubleshoot multiple Teams messages being sent

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution ✅.
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram

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,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard

Featured topics

Restore a deleted flow