Power Automate - Fail to list ALL files in Onedrive

New Contributor

Hi all,

 

https://www.youtube.com/watch?v=ku0NM9jhp-A&t=322s

 

I am following this youtube video to send emails from excel with PDF attachments. 

The flow did work.

cgshirley_1-1658303358648.png

 

But there is an issue on step 2 - List Files in Folder. 

PowerAutomate failed to list all files on Onedrive. I got 49 files on OneDrive. No sub-folder.
But I checked, PowerAutomate is only be able to return 20 sth files. random files. not even top 20.

 

This is the setting of that action - List Files in Folder. 

cgshirley_3-1658303510718.png

 

Not sure which part goes wrong.

 

Would be great if you guys can give me some hints to edit the flow.

Thanks!

 

 

1 Reply

@cgshirley in the settings for the List files in a folder, turn on the pagination toggle and set the threshold to 2000 and see if that helps.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User