Unanswered

Create an Excel File from the list of files present in Onedrive Folder

(0) Share

Report

Posted on by SalmanShaik

Hi Team,

I am very new to Power Automate. I am trying to add a row in the excel table based on the no of files present in a OneDrive (Business) folder using Power Automate Cloud. I already created a table and mapped the headers but the problem is if the folder contains 2 files it updating the excel table as 4rows duplicating each file.

when I checked the flow, its going for two iterations only but updating in the excel as four rows. Am i missing anything?
Can anyone help me out on this?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SalmanShaik

As per the flow execution, it should add only 2 rows to the excel table, so other top 2 rows were present earlier ?

Does last 2 rows were added by flow, i think it is like that only.

May be you can show entire flow design and tell how thing should work 🙂 so that we can resolve the issue quickly 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SalmanShaik 30 on at

Like (0)

Report

Hi @Nived
No, those top 2 rows are not present earlier, both 4 rows are being added by the flow.
If i keep 2 files its adding 4 rows, 3 files means 9 rows are getting added i guess some loop issue. I verified the things but all looks fine for me. Please find the complete flow

Can you share me the sample flow to list all the files and add accordingly the rows in excel table.

let me know if anything is required....

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Now i got the reason by we got more data than expected !

@SalmanShaik

See in your flow, you are using trigger which trigger when file is created in a folder, then you are using list files and then adding all the row details in excel table , i think list all files option is not needed in your case. I hope this simple design is itself enough !

This will add details of each file which is added in a specific folder.

Hope this helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SalmanShaik 30 on at

Like (0)

Report

Hi @Nived_Nambiar
It Worked for me, now i got to know if we place 100 files then 100 times the flow will be triggered. but i have few more questions for you
1. Actually i placed 3 image files in the folder, sometimes the files are being read in order as 2,3,1 and sometimes 3,2,1 is there any logic behind this? i can see the the date modified for all the files are same & they are uploaded at the same time also. I need the files in order like 1,2,3 only.
2. I have to place 1800 files at a single time in the folder is there any limitations in power automate? If i follow the flow shared by you then in the run history i have to verify the 1800 runs whether each one is successful or not.
Is there any other better way in a single flow all the files will be read in a single instance like loop which will fit my use case?
Screenshots are attached for your reference...

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SalmanShaik

in the trigger settings, could you enable the concurreny control option like below

See whether that helps !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SalmanShaik 30 on at

Like (0)

Report

Hi @Nived_Nambiar ,
No it doesn't helped me now the flow is triggering 2 times as i can see it in run history. The reason behind is 2 files are uploading at a time and another file is slightly getting delayed while uploading. so its considering 2 files only.

Is there any logic to read the files in an order like i pasted in the folder?

Was this reply helpful? Yes No
Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

Hi @SalmanShaik

Sorry for late response !

May be you can try this flow design

Not sure how files are being sorted being in one drive, currently assuming ascending order as of now.

So in the trigger settings, disable the below option :

Now next in compose action, use below expression to sort the list of files obtained from trigger output in ascending order:

Expression used:

sort(triggerOutputs()?['body'],'NameNoExt')

Now use the output of compose action to loop over like below:

see the results below:

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
SalmanShaik 30 on at

Like (0)

Report

Hi @Nived_Nambiar
It Worked for me, do we have any limitations for the actions List Files in Folder & when a file is created like they can read only 100 files at a time?
In my use case i have to upload 1800 files at a time in the folder.

Was this reply helpful? Yes No