Power Platform Community Forum Thread Details

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!

Categories:

Using flows

@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